Microsoft Access 2016 Introduction Training
    About Lesson

    After completing this course, participants will have learned to:

    Topic 1

    Getting Started with Access

    • Microsoft Access 2016
    • Database Templates
    • Using Tell Me

    Topic 2

    Working with Table Data

    • AutoCorrect
    • Adding New Records
    • The Sort Feature
    • Lookup Fields

    Topic 3

    Querying a Database

    • Query Views
    • Query Criteria
    • Arithmetic Operators

    Topic 4

    Creating Advanced Queries

    • Parameter Queries
    • Action Queries
    • The Find Duplicates Query Wizard
    • Crosstab Queries

    Topic 5

    Generating Reports

    • Report Creation Tools
    • Report Sections
    • Galleries
    • Adding a Header or Footer

    Topic 6

    Customizing the Access Environment

    • Access Options

    Topic 7

    Designing a Relational Database

    • Relational Databases
    • Table Creation Options
    • Renaming a Table
    • The Relationships Window

    Topic 8

    Joining Tables

    • Query Joins
    • Joining Tables with No Common Fields
    • Self-Joins
    • Subdatasheets
    • Subqueries

    Topic 9

    Organizing a Database for Efficiency

    • First Normal Form
    • Many-to-Many Relationships

    Topic 10

    Sharing Data Across Applications

    • Data Importing
    • Data Exporting
    • Exporting Access Data to Excel
    • The Microsoft Word Mail Merge Wizard

    Topic 11

    Advanced Reporting

    • Report Design Elements
    • Report Format Tools
    • Data Bars
    • Calculated Fields
    • Sub reports

    Topic 12

    Additional Reporting Options

    • The Label Wizard
    • Publishing a Report as PDF