Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  

< 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 Expert Level 2
Description: Access Expert Level 2
Versions: This class was recorded with Microsoft Access 2010. The material is valid for Access 2007 up to 2021.
Pre-Requisites: Access Expert Level 1
Running Time: 1 Hour, 25 Minutes
Cost: $21.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 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
Improve Performance
Storing History Data

02. Explicit Relationships (14:00)
Global Relationships
Relationships Window
Add Tables
Edit Relationships Window
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
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 tutorial, microsoft access 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


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/23/2024 8:53:42 AM. PLT: 0s