Overview
Access 2016 – Level 1
In this course, participants will use Access 2016 to manage their data including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter and sort data.
Access 2016 – Level 2
In this course, participants add to their Access education in order to provide themselves with marketable job skills. This course builds on the foundational skills obtained by attending the Access 2016 – Level 1 course.
Prerequisites
Access 2016 – Level 1
Participants should be familiar with using personal computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer. Specifically, participants should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Access 2016 – Level 2
Access 2016 – Level 1
Who Should Attend?
This course is designed for anyone 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 Level 1
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help and Configure Options in Microsoft Access
- Modify Table Data
- Sort and Filter Records
- Create Basic Queries
- Sort and Filter Data in a Query
- Perform Calculations in a Query
- Create Basic Access Forms
- Work with Data on Access Forms
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- Organize Report Information
- Format Reports
- Relational Database Design
- Create a Table
- Create Table Relationships
- Create Query Joins
- Relate Data Within a Table
- Work with Subdatasheets
- Use Field Validation
- Use Form and Record Validation
- Create Parameter Queries
- Summarize Data
- Create Subqueries
- Create Action Queries
- Create Unmatched and Duplicate Queries
- Data Normalization
- Create a Junction Table
- Improve Table Structure
- Include Control Formatting in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report
Course Outline Level 2
- Add Controls to Forms
- Enhance Navigation and Organization of Forms
- Apply Conditional Formatting
- Import Data into Access
- Export Access Data
- Link Tables to External Data Sources
- Create a Mail Merge
- Create a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Getting Started with VBA
- Enhance Across Using VBA
- Manage a Database
- Determine Object Dependency
- Document a Database
- Splitting a Database for Multiple User Access
- Implement Security
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
