About this Course
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