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

Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills are offered by Microsoft. The candidate for Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills should have a fundamental understanding of the application’s environment. They should understand basic database design principles and are able to complete tasks independently. Also, they should know and demonstrate the correct application of the principal 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.

Learning Path

Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills is a part of the requirement for the Microsoft Office Specialist: Microsoft Access 2016. The certification demonstrates that the candidate has the skills needed to get the most out of Access by earning a Microsoft Office Specialist (MOS) 2016 certification.

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.

Exam Format

The next step is understanding the format of Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills. The candidate will get 120 minutes to complete the exam, in total. The exam includes 40-60 questions. The questions will appear in the form of multiple-choice. The exam is available in English, Chinese (Simplified), Chinese (Traditional), Dutch, Spanish, French, Japanese, Korean languages. The candidate has to pay $100 USD as the examination fee. The passing score for 77-730 is 700 (on a scale of 1-1000).

Registering and Scheduling!

Pearson VUE

In order to take the Microsoft exam, the candidate has to register and schedule the Microsoft exam. The candidate can schedule their exam with the Pearson VUE.

Certiport

The candidate also schedules Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Certiport. Schedule Your Exam Now!

Now, we have acquired all the information related to Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills. It’s time for you to understand the specific domains. The Course Outline shows the most concern areas of the examination.

Microsoft Exam 77-730: Access 2016 Interview Questions

Microsoft Exam 77-730: Targeted Domains

Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills include tasks such as creating and maintaining basic Access database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries, etc. So, it is important to go through the whole course outline once and to understand and learn all the objectives. Below is the course outline for Exam 77-730.

Create and manage a database (20-25%)

Create and modify databases

Create a blank desktop database, create a database from a template, create a database by using Import objects or data from other sources, delete database objects (Microsoft Documentation: Create a database in Access, Create a new database, Import database objects into the current Access database)

Manage relationships and keys

Create and modify relationships, set the primary key, enforce referential integrity, set foreign keys, view relationships (Microsoft Documentation: Create, edit or delete a relationship, Guide to table relationships)

Navigate through a database

Navigate specific records, create and modify a navigation form, set a form as the startup option, display objects in the Navigation Pane, change views of objects (Microsoft Documentation: Use the Navigation Pane, Create navigation forms, Create a form in Access)

Protect and maintain databases

Compact a database, repair a database, back up a database, split a database, encrypt a database with a password, recover data from backup (Microsoft Documentation: Compact and repair a database, Encrypt a database by using a database password)

Print and export data

Print reports, print records, save a database as a template, export objects to alternative formats (Microsoft Documentation: Document and print your database design, Export a database object to another Access database)

Build tables (25-30%)

Create tables

Create a table, import data into tables, create linked tables from external sources, import tables from other databases, create a table from a template with application parts (Microsoft Documentation: Create a table and add fields, Create a new database, Import or link to data in another Access database)

Manage tables

Hide fields in tables, add total rows, add table descriptions, rename tables (Microsoft Documentation: Sum data by using a query)

Manage records in tables

Update records, add records, delete records, append records from external data, find and replace data, sort records, filter records (Microsoft Documentation: Ways to add, edit, and delete records, Create and run an update query, Add records to a table by using an append query)

Create and modify fields

Add fields to tables, add validation rules to fields, change field captions, change field sizes, change field data types, configure fields to auto-increment, set default values, using input masks, delete fields (Microsoft Documentation: Introduction to data types and field properties, Restrict data input by using validation rules)

Create queries (20-25%)

Create a query

Run a query, create a crosstab query, create a parameter query, create an action query, create a multi-table query, save a query (Microsoft Documentation: Run a query, Introduction to queries, Use a screen reader to create a query in Access desktop databases)

Modify a query

Rename a query, add fields, remove fields, hide fields, sort data within queries, format fields within queries (Microsoft Documentation: Create a table and add fields, Introduction to queries)

Create calculated fields and grouping within queries

Add calculated fields, set filtering criteria, group and summarize data, group data by using comparison operators, group data by using arithmetic and logical operators (Microsoft Documentation: Create a grouped or summary report)

Create forms (15-20%)

Create a form

Create a form, create a form from a template with application parts, save a form (Microsoft Documentation: Create a form in Access)

Configure form controls

Move form controls, add form controls, modify data sources, remove form controls, set form control properties, manage labels, add sub-forms (Microsoft Documentation: Add controls to customize an object, Add a field to a form or report)

Format a form

Modify tab order, configure Print settings, sort records by form field, apply a theme, control form positioning, insert backgrounds, insert headers and footers, insert images (Microsoft Documentation: Set the tab order for controls, Modify, edit, or change a report)

Create reports (15-20%)

Create a report

Create a report based on the query or table, create a report in Design view, create a report by using a wizard (Microsoft Documentation: Create a query, form, or report in Access, Create a simple report, Guide to designing reports)

Configure report controls

Group and sort fields, modify data sources, add report controls, add and modify labels (Microsoft Documentation: Create a grouped or summary report, Add a field to a form or report)

Format a report

Format a report into multiple columns, add calculated fields, control report positioning, format report elements, change report orientation, insert header and footer information, insert images, apply a theme

Exam Policies

While preparing for Microsoft Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills, the candidate will be completely responsible for knowing and complying with Microsoft Certification exam policies, together with the specified exam delivery provider’s policies and procedures.

Microsoft Exam 77-730 FAQ

Also, you can go through the Exam Retake Policy together with other Microsoft exams available and exam testing procedures. The exam policy page provides details of the exam provider’s policies and procedures together with the exam provider’s details. Note, you will have 30 days after taking an exam to challenge your exam score for that exam.

Microsoft Exam 77-730: Preparatory Guide

Let us now begin the ideal preparation for Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills, the following presents a few of the analytical steps that you should consider for developing an ideal schedule for your Exam 77-730 preparation.

Microsoft Learning Platform

Microsoft offers various learning paths, the candidate should visit the official website of Microsoft. The candidate can find every possible information on the official site. For this exam, the candidate will find many learning paths and documentations. Finding relatable content on the Microsoft website is quite an easy task. Also, you can find the study guide for Exam 77-730: Access 2016 on the official website of Microsoft.

Microsoft Documentation

Microsoft Documentations are an important learning resource while preparing for Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills. The candidate will find documentation on every topic relating to the particular exam. This step is very valuable in preparing for becoming a certified functional consultant. You can refer to the following documentation for Exam Exam 77-730:

Instructor-Led Training

The training programs that Microsoft provides itself are available on their website. The instructor-led training is an essential resource in order to prepare for the exam like Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills. The candidate can find the instructor-led training on the page of the particular exam on the Microsoft website. There are various training courses available prior to one exam.

Books and Guides

The next step in the preparatory guide should be books and study guides. The candidate needs to find those books which are enriched with information. Candidates should study some books and guides which will definitely help them to gather knowledge about the particular exam. We at Testprep training recommends the following:

MOS 2016 Study Guide for Microsoft Access (MOS Study Guide) Part of MOS Study Guide (21 Books) | by John Pierce
Microsoft Access 2016 Programming By Example: with VBA, XML, and ASP by Julitta Korol
Introductory Relational Database Design for Business, with Microsoft Access by Jonathan Eckstein and Bonnie R. Schultz

Join a Study Group

For passing the Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills, the candidate needs to get and share knowledge. So, we are suggesting you join some study where you can discuss the concepts with the people who have the same goal. This will lead the candidate throughout their preparation.

Practice Test

The most important step is to try your hands on the practice test. Practice tests are the one which ensures the candidate about their preparation. There are many practice tests available on the internet nowadays, the candidate can choose whichever they want. The practice test is very beneficial in preparing for the Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills. So, Start Preparing Now!