This is the first Microsoft Access video tutorial in the Expert series. It picks up where Beginner Level 9 left off. This class covers fixing the contact history table that we started in the last class. I intentionally showed you the wrong way to build it last time. Now we'll build it correctly. You will learn:
- Relational Database Concepts
- Primary & Foreign Key Fields
- Types of Relationships
- Focus on One-to-Many Relationships
- Ad Hoc Query Joins
- Left Joins to Show All Records
- Relational Combo Boxes
- Fixing Lead Source & Shipping Combos
- Select a Customer on the Contact Form
Click here for more information on Access 2010 Expert Level 1, including a course outline, sample videos, and more.