Introduction To Microsoft Access 2016

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Course Outline
Getting Started With Access

• Orientation to Microsoft Access

• Create a Simple Access Database

• Get Help and Configure Options in Microsoft Access

Working With Table Data

• Modify Table Data

• Sort and Filter Records

Querying A Database

• Create Basic Queries

• Sort and Filter Data in a Query

• Perform Calculations in a Query

Using Forms

• Create Basic Access Forms

• Work with Data on Access Forms

Generating Reports

• Create a Report

• Add Controls to a Report

• Enhance the Appearance of a Report

• Prepare a Report for Print

• Organize Report Information

• Format Reports

Designing A Relational Database

• Relational Database Design

• Create a Table

• Create Table Relationships

Joining Tables

• Create Query Joins

• Relate Data Within a Table

• Work with Subdatasheets

Using Data Validation

• Use Field Validation

• Use Form and Record Validation

Creating Advanced Queries

• Create Parameter Queries

• Summarize Data

• Create Subqueries

• Create Action Queries

• Create Unmatched and Duplicate Queries

Organizing A Database For Efficiency

• Data Normalization

• Create a Junction Table

• Improve Table Structure

Using Advanced Reporting Techniques

• Include Control Formatting in a Report

• Add a Calculated Field to a Report

• Add a sub-report to an Existing Report