Access 2016, Level 2 - Intermediate
Versions 2013, 2016, 2019, Office 365, & Online are also available.
Course Outline
Lesson 1 - Database Relationships
- a Look at Relationships
- Creating a One-To-One Relationship
- Creating a One-To-Many Relationship
- Creating a Many-To-Many Relationship
- Enforcing Referential Integrity
- Cascade Update Related Fields
- Cascade Delete Related Records
- Creating & Printing a Relationship Report
Lesson 2 - Working with Tables
- Setting Validation Rules
- Formatting Fields
- Indexing Fields
- Requiring Data Entry
- Creating an Input Mask
- Creating a Lookup Field
- Creating a Value List
- Modifying a Value List
- Creating Calculated Fields
- Creating Multiple Primary Keys
- Creating Multiple Field Values
Lesson 3 - Working with Queries
- Creating Multi-Table Queries
- Using Calculations in Queries
- Changing Query Properties
- Working with the Expression Builder
- Creating a Totals Query
- Creating a Parameter Query
- Creating a Find Duplicates Query
- Creating a Find Unmatched Records Query
- Modifying Query Joins
Lesson 4 - Working with Forms
- Adding Headers and Footers
- Adding Controls to a Form
- Moving and Sizing Controls
- Creating a Calculated Control
- Changing Control Properties
- Changing Form Properties
- Changing the Tab Order
- Adding a Lookup Control
- Inserting Graphics
- Creating a SubForm
Lesson 5 - Working with Reports
- Working with Report Sections
- Adding Controls to a Report
- Changing Control Properties
- Creating a Calculated Control
- Changing a Control’s Data Source
- Changing a Report’s Data Source
- Sorting and Grouping Data
- Changing Report Section Properties
- Inserting Graphics
- Applying a Theme to a Report
- Applying Conditional Formatting
