Access 2016 Training & Certification Course
Overview
Successful candidates for the Access 2016 exam have a fundamental understanding of the application’s environment. They understand basic database design principles and are able to complete tasks independently. They know and demonstrate the correct application of the principle features of Access 2016, and they demonstrate the ability to create and maintain basic Access database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries.
Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills, and abilities using the MOS 2016 programs:
- MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
- The MOS 2016 exam format incorporates multiple projects.
Prerequisite
While there is no formal prerequisite for this training, however candidates with basic computer knowledge can undergo this training.
Full Description
Module 1: Getting Started with Access
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help in Microsoft Access
Module 2: Working with Table Data
- Modify Table Data
- Sort and Filter Records
- Create Lookups
Module 3: Querying a Database
- Join Data from Different Tables in a Query
- Sort and Filter Data in a Query
- Perform Calculations in a Query
Module 4: Designing Forms
- Create a Form
- Modify the Design of a Form
- View and Edit Data Using an Access Form
Module 5: Generating Reports
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
Module 6: Designing a Relational Database
- Relational Database Design
- Create a Table
- Create Table Relationships
Module 7: Creating Advanced Queries
- Create Parameter Queries
- Create Action Queries
- Create Unmatched and Duplicate Queries
- Summarize Data
Module 8: Organizing a Database for Efficiency
- Data Normalization
- Create a Junction Table
- Improve Table Structure
Module 9: Joining Tables
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
- Work with Subdatasheets
- Create Subqueries
Module 10: Advanced Reporting
- Organize Report Information
- Format Reports
- Include Control Formatting in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report
Module 11: Implementing Advanced Form Design
- Add Controls to Forms
- Create Subforms
- Organize Information with Tab Pages
- Enhance Navigation of Forms
- Apply Conditional Formatting
Module 12: Using Data Validation
- Field and Record Validation
- Form Validation
Fees & Schedule
Delivery Mode | Course Duration | Fees |
---|---|---|
Live Virtual Training | 2 Days | Ask for Quote |
Onsite Classroom Training | 2 Days | Ask for Quote |
Customized Training | 2 Days | Ask for Quote |