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

About this course

About the Exam: Microsoft Specialist: Access (Office 2016) – Exam 77-730The Exam 77-730: Microsoft Access (Office 2016) measures your ability to create, manage, and work with databases using Microsoft Access. The exam focuses on real-world tasks such as organizing data, building tables, creating queries, and generating forms and reports for practical use.The certification covers how users interact with databases to store, structure, and retrieve data efficiently. Candidates are expected to understand how data is organized within tables, how relationships connect information, and how queries are used to extract meaningful results.The exam includes topics related to creating and managing databases, where candidates work with database objects, configure relationships, and navigate within the Access environment. This includes tasks such as setting up databases, maintaining structure, and handling data protection activities.Another major area focuses on building and managing tables. Candidates should understand how to define fields, set data types, apply validation rules, and manage records. These skills are essential for maintaining accurate and consistent data within a database.The exam also evaluates how candidates create and modify queries. This includes building queries to filter, sort, and group data, as well as creating calculated fields and working with different query types such as parameter queries, action queries, and crosstab queries.A key focus area is working with forms and reports. Candidates should know how to create forms for data entry and design reports that present data in a clear and structured format. This includes applying layouts, formatting elements, and preparing outputs for printing or sharing.Additional topics include importing and exporting data</