Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills

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.

Skills Measured

• Create and manage a database (20-25%)
• Build tables (25-30%)
• Create queries (20-25%)
• Create forms (15-20%)
• Create reports (15-20%)

Value of Microsoft certification

Microsoft certification gives students and workforce candidates the power to chart their own course, fulfill their ambition, and realize their potential. See the statistics that validate that these certifications give you the tools to build a brighter future and prepare yourself for a successful career.