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

Upcoming Dates:
Register