Microsoft Access 2019

Introduction

Steps to Open Microsoft Access 2019

​Course Overview & Layout

Creating Our First Table and Data Type PDF

Adding, Editing and Deleting Records

Using Primary Keys

Adding Auto numbers, Primary Keys and Restructuring Tables

Basic Table Sorting and Filtering

What do reports do?

Modifying the Report

Working with Controls, Report

Layout Views

Basic Queries

Query Criteria

Date Criteria and Between

Using OR in Criteria

Parameter Queries  

Viewing Table Properties

Custom Formatting PDF

Field Validation and

Field Properties

Query Properties

Report Properties

Creating a Form with the Wizard

Cleaning Up the Form

Working with Controls

More Form Clean-up - Moving Labels, Adding Rectangles

Font Color

Resize Header and Detail and Finish Form

Using the Lookup Wizard

Setup Lookups Without the Wizard

Advanced Sorting and Filtering

Working with Related TABLES

Using TOP queries

Using TOTAL Queries

ACTION queries - UPDATE

ACTION queries - APPEND

Multi Table and MAKE TABLE ACTION Queries

ACTION queries - DELETE

Calculations in Queries and Formatting Results

A Parameter Query Trick

Reports based on the Parameter Query Trick

Calculations in Reports

Sorting with Reports

Adding an Order Month to Our Query

Subtotals in Reports

Label the Subtotals and Report Total

Conditional Formatting