Microsoft Access Database Relationships: Betec017

Workshop | January 8 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 Human Resources

This course details the concepts and practices of designing a relational Microsoft Access database. Emphasis is placed on Table normalization strategies, defining multi-table relationships, and understanding the implications and benefits of a relational environment on other database objects such as Queries, Forms, and Reports.

Learning Objectives
* Understand the purpose and interdependencies of the six major database object types.
* Contrast flat file data storage against relational database management systems.
* Apply Table normalization strategies to mitigate data anomalies. Use the Table Analyzer to verify normalization efforts.
* Define one-to-many, many-to-many, and one-to-one relationships between multiple Tables.
* Enforce referential integrity between related Tables, defining cascading update and deletion policies.
* Modify join properties between Tables to define database-level inner or outer joins.
* Insert Table Subdatasheets to visualize and manage records in related Tables.
* Understand the implications of database relationships on Table, Query, Form, and Report objects.