Microsoft Access Expert Level 7 is 1 hour, 37 minutes long and focuses on Many-to-Many Relationships. You will learn how to place customers into multiple groups, work with table lookups and junction tables, send letters to groups of customers, format a report to print post cards, track products from multiple vendors, and more. Topics include:

- Many-to-Many Relationships
- Table Lookup Wizard
- Multi-Valued Fields
- Assign Customer to Multiple Groups
- Junction Tables
- Prevent Duplicate Records in a Query
- Format a Report for Post Cards
- Products from Multiple Vendors
- Track Unit Cost and Profit

Click here for more information on Access Expert Level 7, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 6.

Junction Table Link  Joe Beniacar     4 years ago Hi Alex, Thank you very much for replying to my questions. Is it possible to have 3 ID fields in a junction table? Reply from Alex Hedley: You can create as many joins as you'd like, say you have an OrderID with the CustomerID and a DiscountID Read More... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

SubForm Issues Link  Robert S      4 years ago Richard, I noticed that the last news item from you on the website was for September 2016, have you published and further news items since then? if so I am not getting them. Reply from Alex Hedley: Read More... None have been published since then but there should be one soon Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

SubForm Issues Link  Joe Beniacar     4 years ago Hi Alex, thanks for your response. My question is: If the Subform doesn't have all of the Table's fields, then when you enter the Subform's record, won't that transfer back to the Table as incomplete records? Is there a way around this issue? Read More... Thank you very much for your help. Reply from Alex Hedley: Yes, only the Fields on the Form will be added as a Record in your Table. You would need to put ALL the Fields from the Table on your Form, you can set DEFAULT VALUES in these Fields and make then Hidden if necessary. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Upgrade a database to Sharepoint Link  Joe Beniacar     4 years ago Is it still possible to upgrade a database to Share Point without using Lookup Wizards (even if you want that functionality, by doing it the better way instead)? Reply from Alex Hedley: Read More... What is the better way? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

1035 Link  Joe Beniacar     4 years ago At 10:35, you say that SQL statements should be stored in  Queries or Forms    do you mean  Forms or Reports  (to Query from Tables)? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first. Add a Reply

Show Older Comments...
View in Table Format