Microsoft Specialist: Access (Office 2016) - Exam 77-730

About this course

About the Certification: Microsoft Specialist: Access (Office 2016) – Exam 77-730The Microsoft Specialist: Access (Office 2016) certification is earned by passing Exam 77-730. This credential focuses on individuals who work with databases using Microsoft Access to store, manage, and analyze structured data in real-world scenarios.Professionals preparing for Exam 77-730 are expected to work with key areas such as creating and managing databases, building tables, designing queries, and creating forms and reports. The exam focuses on how users organize data efficiently and retrieve information through structured queries.The official exam outline is organized around core skill areas including database creation and management, table design and data handling, query development, and form and report creation. These areas reflect practical tasks where users structure data, manage relationships, and produce outputs that support decision-making.In practical terms, the exam covers creating databases from scratch or templates, managing relationships between tables, and navigating database objects. Candidates are expected to understand how to maintain data integrity, protect databases, and perform backup and recovery operations.Another key area is working with tables. This includes adding and modifying fields, applying validation rules, configuring data types, and managing records. These skills help organize data accurately and support consistent data entry.Query creation is a central part of the exam. Candidates are expected to build queries that filter, sort, and group data, creat