Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Access 2010 Expert 2
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   8 years ago

This is the second Microsoft Access video tutorial in the Expert series. It picks up where Expert Level 1 left off.

This class is 1 hour, 25 minutes long and covers database table normalization, defining explicit relationships, referential integrity, cascade updates and deletes, setting values across different forms, and lots more. You will learn:

- Database Table Normalization
- Global Relationships
- Working with the Relationships Window
- Referential Integrity
- Preventing Orphaned Records
- Cascade Update & Delete
- Table Subdatasheets
- Setting Values Across Different Forms
- Forms ! FormName ! FieldName

Click here for more information on Access 2010 Expert Level 2, including a course outline, sample videos, and more.

First normal form Upload Images   Link 
Bojana Bozovic 
22 days ago
Hi, can somebody help me about first normal form, about single value. I have a table with buyers, to be  more specific table what they are looking for. For example they are looking for first, second or third floor in a building. That is 3 values in a field. How can I improve that? Is it so big problem to have multiple values in one field?
Scott Axton
22 days ago
Each field should only contain 1 value.
NEVER put multiple values in a single field.  That will cause problems in the future.

Example:  Building XYZ has 3 floors with different departments on each floor - retail store, accounting and business office.

Your table would look like this:
Building name:  XYZ
Floor: 1
Department: Retail Store

So the second record would look like:
Building name:  XYZ
Floor: 2
Department: Accounting

Building name:  XYZ
Floor: 3
Department: Business Office

This way if you are searching for the Accounting floor you can tell right away it is floor 2 in building XYZ.
Does that help?  Watch the Expert 2 videos again.  it will come to you.
Richard Rost
22 days ago
What Scott said is absolutely correct. Also check these out: Relationships Tip, Relationships Seminar
Add a Reply
Report Building Upload Images   Link 
Julie Hunt 
35 days ago
For my transcript reports, I do not want the attendees name to show on every line but of course they are related to the dates.  How do I just show their name once and dates of activities, credits and provider information separately? Or is it better to use a form to develop transcripts?
Richard Rost
35 days ago
If you're making a report, create a sorting and grouping level for each attendee.
Adam Schwanz
35 days ago
You have grouping options inside of reports, are you able to group by the attendee?
Add a Reply
Employee Certifications Upload Images   Link 
Deborah Linehan 
5 months ago
I am creating an employee database. Currently I have a main employee table, and as I have viewed the last few lessons I realized that I need to take some things out and create separate tables. I am struggling with how to deal with the list of 12 certifications and their expiration dates that each employee may have. Currently I have fields for each cert and its expiration date, but it seems like that does not follow the rules of normalization. Should I create a many to many relationship? How would I use that to still keep track of expiration date? I would appreciate any feedback before I go farther in development. Thank you
Richard Rost
5 months ago
Hi Deborah. I just made a video on this last week: Many to Many Relationships
Add a Reply
Default Value Problem Upload Images   Link 
Abraham Breuer 
8 months ago
when i default my new orderform to the curent open form to that opened customer i entered a description and it went to a new record not to that customer, and it didnt let me save the new order, wye is it so?
Richard Rost
8 months ago
Hi Abraham. It's impossible for me to tell exactly what's happening based on your description without seeing your database. Follow the steps again carefully from the video. You probably missed a step, like setting the Default Value for the CustomerID on the Order Form.
Add a Reply
Referential Integrity Upload Images   Link 
Virginia Mergl 
5 years ago
Hi, on my database I have a customer table and a pet table.
One customer can have more than one pet
One to many relationship. I did set a referential integrity so on my database I can not have a pet without a customer. Read More...
Add a Reply
Customer Combo Upload Images   Link 
Elizabeth R 
5 years ago
Ok. Thanks! I'll give it a try. (I did think that might work, but wondered if I missed something in the lecture.)
Add a Reply
Customer Combo Upload Images   Link 
Elizabeth Roche 
5 years ago
Right now if my user changes the customer combo box...he modifies who the comment is about...This is probably a programmer party foul. I'm hoping you'll show how to disable that ability (in a future class?) Thanks!! Love this tutorial series. Your explanation of Normalization and Ref. integrity was excellent!! Read More...
Add a Reply
ON Expert 2 values across forms section Upload Images   Link 
Zacharias Martinez 
5 years ago
ON Expert 2, values across forms section.  There is a portion where you go into dropping a command button, form operations, open form.  In that section a portion of the wizard comes up which states "specify which data to display"...this does not show up in my wizard when I make this button.  How do I get this function back into my access 2010 program, I need this function but I am stuck without it.  Please advise. Read More...
Add a Reply
Relationships Upload Images   Link 
Carolina Cervantes 
5 years ago
In which lesson do we learn how to line up customer id's to relate to other table without entering the ID for each record in the other tables?

I basically have a table of "customers/clients" I want to create a few other tables of "clinic admits" and another of "client referrals" and I want them to all relate to the Custmer/Client ID in table one. I would like to import that data, but do I need to enter the Customer ID/Foreign ID for each record in each table or is there an easier way? Read More...
Add a Reply
Database Design Upload Images   Link 
vicki Hudson 
5 years ago
I need to track multiple horses that get trimmed multiple times a year by multiple people.  I need to see at a glance what horse is due to be trimmed each month. Then print a report to give to barn mgr.  What is going to be the best way to set this up? i am having trouble normalizing the TrimT with the HorseT. In my form it repeats the date in every TrimDate field (9 of them) when i enter a date. I need to see every date in a column like an excel sheet to determine which horse gets done first.  not sure if this makes sense Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

7/24/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access 2010 expert 2 normalization referential integrity global relationships  Page Tag: whatsnew  PermaLink