Study Guide for Exam 77-730: Microsoft Access 2016

The Study Guide for Exam 77-730: Microsoft Access 2016 is designed to help candidates prepare for the Microsoft Office Specialist (MOS) certification exam. The guide offers a structured approach to mastering the core features and functionalities of Microsoft Access 2016. It focuses on essential topics, including database creation, table design, query formulation, form and report building, and maintaining data integrity. The guide starts by covering how to create and manage databases, emphasizing database creation from scratch, the use of templates, and establishing relationships between tables. It also covers the application of primary and foreign keys, along with enforcing referential integrity to ensure consistent data. Building tables is a major section, where candidates learn how to define field data types, use input masks, and apply validation rules to maintain data accuracy. The study guide dives deep into creating and modifying queries, including how to use select, action, and aggregate queries. Techniques for joining tables and using calculated fields are also taught. Form and report creation are crucial aspects of the exam. The guide demonstrates how to design forms and configure their controls, apply formatting, and set properties for efficient data entry. Similarly, report creation focuses on grouping, sorting, and inserting key elements like charts and page numbers. The guide also emphasizes maintaining data integrity through validation rules, as well as importing and exporting data to and from external sources like Excel. This study guide equips candidates with the skills needed to confidently sit for and pass the MOS 77-730 exam.