Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

< Previous: Access Expert 1

Next: Access Expert 3 >

Access Expert Level 2

Expert Microsoft Access Tutorial - 1 Hour, 25 Minutes
 
 
This Microsoft Access video tutorial picks up where Expert Level 1 left off. This class covers database table normalization, defining explicit relationships, referential integrity, cascade updates and deletes, setting values across different forms, and 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

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first and last lessons of this course (free of charge), or scroll down for more information.




 

Access 2010 Expert Level 2
Description: Access 2010 Expert Level 2
Versions: Recorded with Microsoft Access 2010
Works fine with Access 2013 and 2007
Pre-Requisites: Access 2010 Expert Level 1
Running Time: 1 Hour, 25 Minutes
Cost: $19.99


This class picks up where Expert Level 1 left off. In Expert 1 we learned the very basics of setting up relationships between our tables. In this class we'll begin by going into more depth on database design theory. The first topic we'll cover is called normalization, which is making sure your tables are designed correctly. We'll go over the first three "normal forms." Plus, we'll talk about when it's prudent to ignore proper normalization.

 

In Expert 1, the relationships we created were "ad hoc" relationships - just set up in the queries themselves. In this class, we'll learn how to define global relationships on the database level. We'll learn how to work with the Relationships Window and how to add, edit, and delete relationships. We'll learn how to work with table subdatasheets. We'll learn how to set up Referential Integrity to prevent orphaned child records.

 

There are some times when you want to delete all of the child records when a parent record is deleted. If you delete an order, for example, you want all of the line items on that order to also be erased. This is where it's important to know how to set up cascade updates and deletes.

 

We'll create a button on our customer form to display all of the contacts just for that customer. When we go to add a new contact, however, we have to manually select the customer again. It would be nice if we could just get the value of the currently open customer. To do this, we have to learn how to get a value from another open form. Now we no longer have to select the customer from a combo box. We'll also see some additional form layout tricks, like having multiple text boxes bound to the same data field, and moving fields to the form header or footer.

 

This is the second class in the Access Expert series. If you want to take your database skills to the next level, this is the class for you. Understanding proper relational database construction is absolutely vital to the success of your projects. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

 

Complete Outline - Access 2010 Expert Level 2

00. Intro (7:04)

01. Normalization (21:06)
What is Normalization
First Normal Form (1NF)
Flat Tables
Atomic Fields
Repeating Groups of Data
Entities (Entity)
Second Normal Form (2NF)
Update Anomalies
Third Normal Form (3NF)
Remove Derived Fields
Calculated Values
Denormalization
Improve Performance
Storing History Data

02. Explicit Relationships (14:00)
Global Relationships
Relationships Window
Add Tables
Edit Relationships Window
SubDatasheet
Subtable
Orphaned Child Records
Edit Relationship
Referential Integrity
Unable to Delete Parent
03. Cascade Update & Delete (13:16)
Cascade Updates
Why you should never need them
Cascade Deletes
Automatic Delete of Children
Backup Your Data!
Can't Delete Tables in Relationships
Arrange Tables in Relationship Window
Hide Tables
Delete Relationships
Relationships Report
Object Dependencies
Subdatasheet Table Properties
Subdatasheet Expanded
Subdatasheet Height
Subdatasheet Name
Link Child Fields
Link Master Fields

04. Values Across Forms (23:13)
Find Contacts for Current Customer
Command Button
Open Form
Find Specific Data To Display
Save Form Position
Set Values Between Forms
Forms Collection
Forms!FormName!FieldName
Default Value
Value of a Combo Box
Combo Box Columns
Bigger Notes Field in Form Footer
Move Combo Box to Form Footer
TabStop Property
Brief Intro to Expression Builder
Dirty Records Refresh Problem

05. Review (6:11)

 


 
Keywords: Normalization, Relationships, Referential Integrity, Cascade Delete, Values Across Forms, microsoft access tutorial, microsoft access 2010 tutorial, microsoft access 2010 training, normalization, normalize, flat tables, entities, entity, first normal form, second normal form, third normal form, denormalization, global relationship, relationship window, subdatasheet, subtable, orphan, cascade update, cascade delete, object dependencies, forms collection, save form position, tabstop, dirty record
 

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

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP