Microsoft Access Expert 7

News User Comments History Notify Me

6/18/2013 12:12:45 AM
Microsoft Access Expert 7
By Richard Rost

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.

Permanent Link
Course Link: Microsoft Access Expert 7
Keywords: access expert 7 many to many relationships multivalued fields lookup junction tables
Page Tag: whatsnew

Post Reply

Not using lookups in tables Comment from D. Forman @ 7/19/2013

You said not to use lookups in tables. How about using them in Forms?

Also, are there times when using a lookup in a table is okay (assuming SQL Server is not in the database's future)? For instance, when the value is something very simple such as a 1, 2 or 3 in a rating system. Do you really want to create a new table just for this?

Reply from Richard Rost:

It's a general rule of thumb, but like I said in the video, there are exceptions. If you're sure you're never going to upgrade to SQL Server, and you're pretty sure you're not going to add options in the future, then go ahead. It's my STRONG recommendation, but not a rule.

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 3+8:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard