Microsoft Office Specialist: Access (Office 2016)

The Microsoft Office Specialist (MOS): Access (Office 2016) certification validates a candidate’s ability to create, manage, and maintain Microsoft Access databases. It demonstrates proficiency in database design, data management, queries, forms, and reports using Microsoft Access 2016.

Certification Overview

To earn the Microsoft Office Specialist: Access (Office 2016) certification, candidates must pass one required exam.

📌 Important

This is a single-exam certification.
There are no prerequisite exams or certifications required.
The certification focuses on database creation and management using Microsoft Access 2016.

Track Details & Exam Requirements

🔹 MOS Exam (Required)

77-730: Access 2016

This exam measures the ability to create and manage databases using Microsoft Access 2016.

Exam Details

Exam Code: 77-730
Exam Name: Access 2016
Exam Duration: ~50 minutes
Exam Type: Performance-based certification exam
Delivery: Certiport authorized testing centers
Certification Level: Microsoft Office Specialist (MOS)

What This Certification Validates

With the Microsoft Office Specialist: Access (Office 2016) certification, you demonstrate the ability to:

Create and manage Access databases
Build and maintain database tables and relationships
Create and run queries to analyze data
Design forms for data entry and management
Generate reports for data presentation and analysis

These skills help organizations manage structured data and build custom database solutions using Microsoft Access.

Exam Skills Measured

The 77-730 exam evaluates several major database management domains.

1. Create and Manage Databases (25–30%)

Candidates must understand how to:

Create new databases
Import and export data
Manage database objects

2. Build Tables and Relationships (20–25%)

Candidates should be able to:

Create tables and fields
Define data types and properties
Establish relationships between tables

3. Create and Modify Queries (20–25%)

This domain focuses on:

Creating select queries
Filtering and sorting data
Implementing calculations and expressions

4. Design Forms for Data Entry (15–20%)

Candidates must understand how to:

Create and customize forms
Implement form controls
Manage user input

5. Create Reports (15–20%)

Candidates must understand how to:

Generate database reports
Format and organize report data
Present information for business analysis

Validity & Recertification

Microsoft Office Specialist certifications do not expire, because they validate proficiency in a specific product version (Office 2016).

Who Should Pursue This Certification?

This certification is ideal for professionals such as:

Office Administrators
Database Assistants
Data Analysts using Access
Business Professionals managing structured data
Administrative and operations staff

Career Benefits

Demonstrates expertise in Microsoft Access database management
Validates skills in database design and data analysis
Recognized globally as a Microsoft Office Specialist credential
Helps professionals improve data organization and reporting capabilities

Summary

The Microsoft Office Specialist: Access (Office 2016) certification validates a candidate’s ability to design and manage relational databases using Microsoft Access.

Key points

Requires one exam: 77-730
No prerequisite certification required
Focuses on database creation, queries, forms, and reporting
Part of the Microsoft Office Specialist (MOS) certification program.