Course length: 1-day
Course Overview
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 advanced course builds upon intermediate Microsoft Access skills to help students become power users.
In this advanced Microsoft Access course, students will delve deeper into the program by studying how to manage a database, create macros, write SQL queries, split databases for multi-user environments; and much more.
Prerequisites
Access Level 1 Foundation or have equivalent knowledge.
Access Level 2 Intermediate or have equivalent knowledge.
Outline
- Managing Your Database
- Advanced Query Tasks
- Creating Basic Macros
- Advanced Macro Tasks
- Creating Navigation Forms
- Creating Modal Dialog Boxes
- Splitting the Database
You may also be interested in:
Certification
Before testing you will need:
- Access Level 1 Foundation
- Access Level 2 Intermediate
- Access Level 3 Advanced