ACSL2: Microsoft Access - Creating Relational Databases

Access - The Essentials class or equivalent knowledge.

After completing this course, students will be able to:

• Design a relational database.
• Join tables to retrieve data from unrelated tables.
• Validate data entered into a database.
• Use advanced queries to manipulate your data.
• Organise a database for efficiency and performance, and to maintain data integrity.
• Customise reports to organise the displayed information and produce specific print layouts.

Designing a Relational Database 
 Relational Database Design 
 Create a Table 
 Create Table Relationships 

Joining Tables 
 Create Query Joins 
 Relate Data Within a Table 
 Work with Subdatasheets 

Using Data Validation 
 Use Field Validation 
 Use Form and Record Validation 

Creating Advanced Queries 
 Create Parameter Queries 
 Summarise Data 
 Create Subqueries 
 Create Action Queries 
 Create Unmatched and Duplicate Queries