Course length: 1-day
Course Description
Microsoft’s Office Access is Microsoft’s popular database program. Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.
This Level 2 class is intended to help those who are familiar with the basics of Access to do more with their database; including managing data in tables, using data management queries, adding controls to forms and formatting reports. The class will also help more experienced users with previous versions of Access to understand the ribbon interface.
Prerequisites
Access Level 1 Foundation or have equivalent knowledge.
Course Outline
Advanced Table Tasks
Managing Data Entry in Tables
Creating Advanced Queries
Formatting Forms
Creating Subforms
Formatting Reports
You may also be interested in:
Certification
Before testing you will need:
- Access Level 1 Foundation
- Access Level 2 Intermediate
- Access Level 3 Advanced
Is Level 2 right for you?
Try our self-assessment