Access Expert Level 7

This class picks up where Expert Level 6 left off. We will continue working with the letter writer that we started in the previous classes. We will begin, however, by focusing on Many-to-Many Relationships. You will learn what they are, when you should use them, and how to set them up. First, we'll see how the Access Table Lookup Wizard works (and why you shouldn't use it). We'll also learn about multi-valued fields.

Next, we'll learn the correct way to set up Many-to-Many Relationships using a Junction Table (also called a Cross-Reference Table). This is the proper way to set up your relationships. We'll set up a junction table to track customers into multiple groups.

You'll be able to open the Group form and see all of the customers in that group AND open the Customer form to see all of the groups that customer is in.

With our groups in place, we'll be able to send letters to just customers in the selected groups. We'll add this functionality to our Letter Writer form.

We'll also learn some new manual report formatting techniques. We'll format a report to print post cards (from scratch). We'll learn about columns, margins, row and column spacing, and lots more.

Finally, we'll go over another example of many-to-many relationships. We'll track products and vendors. Each vendor supplies us with multiple products, of course, but each product can be sold by multiple vendors. We'll store a unit cost for each product, and this will allow you to comparison shop to pick the lowest-cost inventory.

This is the seventh class in the Access Expert series. If you want to understand many-to-many relationships, then this is definitely the right class to take. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

Complete Outline - Access Expert Level 7