Advanced Microsoft Access

Overview

​

This Advanced Access training class is for students who intend to design databases

at an advanced level and/or want to improve existing Access databases.

​

Who Should Attend

​

Students who have basic skills with Microsoft Access who want to learn advanced-level skills

or students who want to learn the topics covered in this course in the Microsoft Access interface.

​

Course Objectives

​

• Learn about database relationships.

• Learn to work with table relationships.

• Learn to work with queries at an advanced level.

• Learn to work with forms at an advanced level.

• Learn to work with reports at an advanced level.

• Learn to work with macros.

• Learn to complete the desktop application with the navigation form.

​

Class Prerequisites

​

Experience in the following is required for this Microsoft Access class:

• Introductory-level knowledge and skills working with Microsoft Access.

​

Certifications

​

• Microsoft Office Access 2016

Course Overview

​

1    Relationships

• Review

• Referential Integrity

• Relationships

• Data Types and Relationships

• Formalize the Relationship between Tables

• A Few Words about Naming Conventions

• Creating Relationships

​

2    Queries

• Query Design View 

• Review of Select Queries

• Review of Select Queries with Criteria

• Logical Operators

• Parameter Queries

• Action Queries

• Make Table Queries

• Append Queries

• Update Queries

• Delete Queries

• Creating Crosstab Queries

• Delete a Query

• Rename a Query

• Creating Select and Action Queries

• Creating a Parameter Query

​

3    Table Functions

• Importing Data

• Linking Tables from External Sources

• Import Tables from other Databases

• Tables from Templates and Application Parts

• Importing Data from Excel

• Exporting Data to Excel

​

4    Forms

• Design View

• Form Sections

• Adding a Header and Footer 

• Adding a Logo to the Header 

• Adding a Title to the Header 

• Adding Fields to a Form

• Arranging Fields on a Form

• Spacing Objects on a Form

• Formatting

• Tab Order

• Setting Properties on a Form

• Controls

• Create Forms with Application Parts

• Creating a Subform

• Creating Forms

• Alter a Form

• Delete Forms

• Remove Form Controls

• Format a Form

​

5    Reports

• Design View

• Report Sections

• Report Header

• Page Header

• Group Header

• Detail

• Group Footer

• Page Footer

• Report Footer

• Adding a Report Header/Footer 

• Adding a Logo to the Report Header 

• Adding a Title to the Report Header 

• Adding Fields to a Report

• Add Calculated Fields

• Arranging Fields on a Report

• Resizing the Detail Section

• Eliminating Repeating Headings

• Set Margins

• Grouping and Sorting

• Setting Properties on a Report

• Report Property Sheet

• Section Property Sheet

• Object Property Sheet

• Adding Record Counts

• Special Report Fields

• Dates

• Page Numbering

• Controls

• Printing a Report

• Subreports

• Application Parts

• Deleting a Report

• Formatting a Report

• Adding a Background and Images and Applying a Theme

• Creating Reports

​

6    Macros

• Macro Basics

• Open a Table, Form, and Report

• Run a Query

• Print a Report

• Running a Macro

• Creating Simple Macros

​

7    Completing the Desktop Application

• The Navigation Form 

• Running Macros from a Navigation Form 

• Setting the Navigation Form as the Default Form 

• Creating a Navigation Form

• Splitting the Database

• Encrypt with a Password

• Distributing the Front-End Database

• Database Maintenance

• Compact and Repair

• Backup/Recover a Database

• Maintain Backward Compatibility