Microsoft Access

Microsoft Access 2019

01 Introduction:

1. Introduction

2. Steps to Open Microsoft Access 2019

3. ​Course Overview & Layout

02 TABLE Objects - The Basics

1. Creating Our First Table and Data Type PDF

2. Adding, Editing and Deleting Records

3. Using Primary Keys

4. Adding Auto numbers, Primary Keys and Restructuring Tables

5. Basic Table Sorting and Filtering

03 Report Objects

1. What do reports do?

2. Modifying the Report

3. Working with Controls, Report

4. Layout Views

04 QUERY Objects

1. Basic Queries

2. Query Criteria

3. Date Criteria and Between

4. Using OR in Criteria

5. Parameter Queries

05 PROPERTIES

1. Viewing Table Properties

2. Custom Formatting PDF

3. Field Validation and

4. Field Properties

5. Query Properties

6. Report Properties

06 FORM Objects

1. Creating a Form with the Wizard

2. Cleaning Up the Form

3. Working with Controls

4. More Form Clean-up - Moving Labels, Adding Rectangles

5. Font Color

6. Resize Header and Detail and Finish Form

07 Advanced TABLES

1. Using the Lookup Wizard

2. Setup Lookups Without the Wizard

3. Advanced Sorting and Filtering

4. Working with Related TABLES

08 Advanced QUERIES

1. Using TOP queries

2. Using TOTAL Queries

3. ACTION queries - UPDATE

4. ACTION queries - APPEND

5. Multi Table and MAKE TABLE ACTION Queries

6. ACTION queries - DELETE

7. Calculations in Queries and Formatting Results

8. A Parameter Query Trick

09 Advanced REPORTS

1. Reports based on the Parameter Query Trick

2. Calculations in Reports

3. Sorting with Reports

4. Adding an Order Month to Our Query

5. Subtotals in Reports

6. Label the Subtotals and Report Total

7. Conditional Formatting