MS Access Level 2

Access 2019 Level 2 – Intermediate

Access 2019 Level 2 – Intermediate. Versions 2013, 2016, 2019, Office 365, & Online are also available. This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019.

Course Outline

Lesson 1 – Database Relationships

• a Look at Relationships
• Creating a One-To-One Relationship
• Creating a One-To-Many Relationship
• How to 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
• How to create a Value List
• Modifying a Value List
• Creating Calculated Fields
• Creating Multiple Primary Keys
• Create 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
• Create 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
• How to Change 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