Access 2016 Training & Certification Course

Module 1: Getting Started with Access

•  Orientation to Microsoft Access
•  Create a Simple Access Database
• Get Help in Microsoft Access

Module 2: Working with Table Data

•  Modify Table Data
•  Sort and Filter Records
•  Create Lookups

Module 3: Querying a Database

•  Join Data from Different Tables in a Query
•  Sort and Filter Data in a Query
•  Perform Calculations in a Query

Module 4: Designing Forms

• Create a Form
•  Modify the Design of a Form
•  View and Edit Data Using an Access Form

Module 5: Generating Reports

•  Create a Report
•  Add Controls to a Report
•  Enhance the Appearance of a Report
•  Prepare a Report for Print

Module 6: Designing a Relational Database

•  Relational Database Design
•  Create a Table
• Create Table Relationships

Module 7: Creating Advanced Queries

•  Create Parameter Queries
•  Create Action Queries
•  Create Unmatched and Duplicate Queries
•  Summarize Data

Module 8: Organizing a Database for Efficiency

•  Data Normalization
•  Create a Junction Table
•  Improve Table Structure

Module 9: Joining Tables

•  Create Query Joins
• Join Tables That Have No Common Fields
•  Relate Data within a Table
•  Work with Subdatasheets
•  Create Subqueries

Module 10: Advanced Reporting

•  Organize Report Information
•  Format Reports
• Include Control Formatting in a Report
•  Add a Calculated Field to a Report
•  Add a Subreport to an Existing Report

Module 11: Implementing Advanced Form Design

•  Add Controls to Forms
•  Create Subforms
•  Organize Information with Tab Pages
• Enhance Navigation of Forms
•  Apply Conditional Formatting

Module 12: Using Data Validation

•  Field and Record Validation
•  Form Validation