• Home
  • Microsoft
  • 77-730 (Access 2016: Core Database Management, Manipulation, and Query Skills)

Pass Your Microsoft 77-730 Exam Without Effort

100% Authentic Exam Questions, Answers Validated by IT Professionals

Regular Updates, Fast Download!

Add Comment

77-730 Exam Facts

The Microsoft 77-730 exam checks the skills of the applicants in using Access 2016. In this qualification test, the professionals need to demonstrate their expertise in creating and managing databases. Besides that, they should possess competence in building tables. In addition, the individuals need to have proficiency in creating reports, forms, and queries. Those students who ace this exam will obtain the Microsoft Office Specialist: Microsoft Access 2016 certification.

Requirements

Those learners who plan to take this certification exam need to be conversant with the Access 2016 environment. Furthermore, they should have a comprehension of the basic database design principles. In addition, the candidates need to possess the relevant skills in the correct application of the main features of Access 2016 as well as creation and maintenance of the basic Access database objects (these include relationships, tables, multi-level reports, multi-table queries, and data entry forms).

Exam Overview

The Microsoft 77-730 exam contains around 40-60 questions and has the duration of 50 minutes. The test can be passed in Dutch, French, Spanish, English, Korean, Japanese, and Chinese (Traditional and Simplified). The registration fee is $100. The 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills exam consists of several topics that are enumerated below:

Creating and Managing Databases: The first section measures the proficiency of the specialists in:

  • Creating and modifying databases: It focuses on creating blank desktop databases, creating databases from templates, and creating databases by utilizing Import objects or data from other sources.
  • Managing keys and relationships: It covers creating and changing relationships, setting the primary key, viewing relationships, setting foreign keys, and enforcing referential integrity.
  • Navigating through databases: It takes a look at navigating specific records, creating and modifying a navigation form, configuring a form as the startup option, displaying the objects in Navigation Pane, and changing the views of objects.
  • Protecting and maintaining databases: It is centered on compacting, backing up, splitting, and repairing databases, encrypting databases with passwords, and recovering data from backup.
  • Printing and exporting data: It gives attention to printing records, printing reports, saving a database as a template, and exporting the objects to alternative formats.

Building Tables: This module evaluates the expertise of the candidates in:

  • Creating tables: It includes creating tables, importing data into tables, importing tables from other databases, creating linked tables from external sources, creating a table from a template with application parts.
  • Managing tables: It is built around hiding fields in tables, adding table descriptions, adding total rows, and renaming tables.
  • Managing records in tables: It focuses on adding, updating, filtering, sorting, and deleting records as well as searching for and replacing data and appending records from external data.
  • Creating and modifying fields: It gives attention to adding fields to tables, adding validation rules to fields, changing field sizes, changing field captions, changing field data types, setting default values, configuring fields to auto-increment, utilizing input masks, and deleting fields.

Creating Queries: Within the next domain, the examinees need to show their skills in:

  • Creating queries: It takes a look at running queries, creating parameter queries, creating crosstab queries, creating multi-table queries, creating action queries, and saving queries.
  • Modifying queries: It concentrates on renaming queries, adding fields, hiding fields, removing fields, sorting data within queries, and formatting fields within queries.
  • Creating calculated fields and grouping within queries: It covers adding calculated fields, setting filtering criteria, grouping and summarizing data, grouping data by utilizing comparison operators, and grouping data by utilizing logical and arithmetic operators.

Creating Forms: This subject area assesses the competence of the learners in:

  • Creating forms: It gives attention to creating forms, creating forms from templates with application parts, and saving forms.
  • Configuring form controls: It is centered on moving form controls, modifying data sources, adding form controls, setting form control properties, removing form controls, managing labels, and adding sub-forms.
  • Formatting forms: It focuses on modifying tab order, configuring Print settings, sorting records by form field, applying themes, controlling form positioning, inserting backgrounds, inserting images, and inserting headers and footers.

Creating Reports: The last part of the exam checks the expertise of the test takers in:

  • Creating reports: It covers creating reports based on queries or tables, creating reports in Design view, and creating reports by utilizing a wizard.
  • Configuring report controls: It takes a look at grouping and sorting fields, adding report controls, modifying data sources, and adding and modifying labels.
  • Formatting reports: It includes formatting a report into multiple columns, controlling report positioning, adding calculated fields, formatting report elements, changing report orientation, applying themes, inserting images, and inserting header and footer information.

Preparation Options

The applicants who want to prepare for the Microsoft 77-730 test can consider utilizing various learning tools. Some of them are exam dumps, practice tests, books, and articles. For example, you can check MOS 2016 Study Guide for Microsoft Access by John Pierce. This tutorial covers the subject areas that are important for this certification exam. Furthermore, it comes with practice tasks and sample solutions. At the same time, you may think about using braindumps. This is a compilation of questions and answers from the previous tests. This resource is created to get familiar with the question patterns as well as polish the skills that are necessary for the exam. Besides that, this material can be used to check your level of readiness. Explore different tools to find a preparation option that will fit your preferences.

Career Opportunities

Those individuals who nail the Microsoft 77-730 exam will obtain the Microsoft Office Specialist: Microsoft Access 2016 certificate. This certification validates the competence of the specialists in working with Access 2016. It can be useful for various job titles. Some of them are a Financial Analyst, an IT Manager, a Data Analyst, a Business Analyst, a Business Systems Analyst, and a Pricing Analyst. At the same time, it can be a Project Manager, a Programmer Analyst, a Reporting Analyst, a Database Analyst, a Database Administrator, and a Logistics Analyst, among others. As per PayScale, the median compensation outlook for the Data Analysts is $55,000 per year. The average annual remuneration for the Database Administrators is $63,000, while the Logistics Analysts can earn $56,000.

SPECIAL OFFER: GET 25% OFF

Exam-collection.com Premium

Exam-collection.com Premium Files

Get Unlimited Access to all Exam-collection.com PREMIUM files!

  • Exam-collection.com Certified Safe Files
  • Guaranteed to have ACTUAL Exam Questions
  • Up-to-Date Exam Study Material - Verified by Experts
  • Instant Downloads
Enter Your Email Address to Receive Your 25% Off Discount Code
A Confirmation Link will be sent to this email address to verify your login
We value your privacy. We will not rent or sell your email address

SPECIAL OFFER: GET 25% OFF

Use Discount Code:

EXAM25

A confirmation link was sent to your e-mail.
Please check your mailbox for a message from support@exam-collection.com and follow the directions.

Next

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.