Welcome to ABCD Part 2: Core. Total running time is 4 hours, 17 minutes.

In lessons 1 and 2 we build the HelperF form. This allows the user to double-click on any of the combo boxes using Helper data to open a form that lets them edit or add items quickly. Then that form will update the underlying combo box and send the value back to it when closed. In lesson 3 we create the Helper Data Editor. In Lesson 4 we set up Groups so we can categorize people however we choose (students, faculty, employees, parents, etc.) In lessons 5 and 6 we set up Relations (parent/child, co-workers, etc.)

Lessons

• 0. Intro (7:19)
• 1. Helper Form Part 1 (26:26)
• 2. Helper Form Part 2 (37:18)
• 3. Helper Form Part 3 (35:01)
• 4. Groups (51:46)
• 5. Relations 1 (46:21)
• 6. Relations 2 (45:11)
• 7. What's Next? (7:35)

Database Files

I'm only posting the 32-bit versions for now. That's what I use. If you are using 64-bit Access, just create a new blank database file and import all of my objects into yours. I'll post a 64-bit version when the Core is finished. If you experience any code that doesn't work under 64-bit let me know. Click here for more information about 32 v 64 bit.

• Database After Lesson 3
• Database After Lesson 4
• Database After Lesson 6

Resources

• ABCD Home Page
• Video Lessons Download ZIP File (863 MB)

Learn More

• Free Access Beginner 1
• Access Expert 1, Expert 2, and Relationship Seminar
• Access Developer 1 for VBA Beginners
• Access Insider Circle

Questions

Post your questions or comments below