{"id":40182,"date":"2021-05-10T09:12:40","date_gmt":"2021-05-10T09:12:40","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=40182"},"modified":"2024-05-08T10:40:38","modified_gmt":"2024-05-08T10:40:38","slug":"exam-77-730-access-2016-core-database-management-manipulation-and-query-skills","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/","title":{"rendered":"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/How-do-I-prepare-for-Salesforce-Identity-and-Access-Management-Designer-Exam-1.jpg\" alt=\"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills\" class=\"wp-image-40298\"\/><\/figure>\n<\/div>\n\n\n<p>Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills are offered by Microsoft. The candidate for <a href=\"https:\/\/www.testpreptraining.ai\/access-2016-core-database-management-manipulation-and-query-skills-77-730\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills<\/a> should have a fundamental understanding of the application\u2019s 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.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Learning Path<\/strong><\/h5>\n\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/77-730\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills<\/a> is a part of the requirement for the <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/mos-access-2016\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Office Specialist: Microsoft Access 2016<\/a>. 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. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"129\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/10.5.png\" alt=\"\" class=\"wp-image-40307\"\/><figcaption class=\"wp-element-caption\">Source: Microsoft<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate\u2019s knowledge, skills, and abilities using the MOS 2016 programs:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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.<\/li>\n\n\n\n<li>The MOS 2016 exam format incorporates multiple projects.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Format<\/strong><\/h4>\n\n\n\n<p>The next step is understanding the format of&nbsp;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).<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Registering and Scheduling! <\/strong><\/h5>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Pearson VUE<\/strong>&nbsp;<\/h5>\n\n\n\n<p>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&nbsp;<a href=\"https:\/\/home.pearsonvue.com\/Clients\/Microsoft.aspx\" target=\"_blank\" rel=\"noreferrer noopener\">Pearson VUE.<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Certiport&nbsp;<\/strong><\/h5>\n\n\n\n<p>The candidate also schedules Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Certiport.&nbsp;<a href=\"https:\/\/www.certiport.com\/locator\" target=\"_blank\" rel=\"noreferrer noopener\">Schedule Your Exam Now!<\/a><\/p>\n\n\n\n<p>Now, we have acquired all the information related to Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills. It\u2019s time for you to understand the specific domains. The Course Outline shows the most concern areas of the examination. <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-exam-77-730-access-2016-interview-questions\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Exam 77-730: Access 2016 Interview Questions<\/a><\/strong><\/h5>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-exam-77-730-access-2016-interview-questions\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/12\/Exam-77-730-Access-2016-Interview-Questions.jpg\" alt=\"Exam 77-730: Access 2016 Interview Questions\" class=\"wp-image-50408\"\/><\/a><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft Exam 77-730: Targeted Domains<\/strong><\/h3>\n\n\n\n<p>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.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create and manage a database (20-25%)<\/strong><\/h5>\n\n\n\n<p>Create and modify databases<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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 <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-database-in-access-f200d95b-e429-4acc-98c1-b883d4e9fc0a\" target=\"_blank\" rel=\"noreferrer noopener\">Create a database in Access<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-new-database-32a1ea1c-a155-43d6-aa00-f08cd1a8f01e\" target=\"_blank\" rel=\"noreferrer noopener\">Create a new database<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/import-database-objects-into-the-current-access-database-23aea08b-7487-499d-bdce-0c76bedacfdd\" target=\"_blank\" rel=\"noreferrer noopener\">Import database objects into the current Access database<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Manage relationships and keys<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create and modify relationships, set the primary key, enforce referential integrity, set foreign keys, view relationships <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-edit-or-delete-a-relationship-dfa453a7-0b6d-4c34-a128-fdebc7e686af\" target=\"_blank\" rel=\"noreferrer noopener\">Create, edit or delete a relationship<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/guide-to-table-relationships-30446197-4fbe-457b-b992-2f6fb812b58f\" target=\"_blank\" rel=\"noreferrer noopener\">Guide to table relationships<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Navigate through a database<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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 <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-the-navigation-pane-274dfc5a-281b-472b-94e2-ef931c5cc590\" target=\"_blank\" rel=\"noreferrer noopener\">Use the Navigation Pane<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-create-navigation-forms-67773fba-1ddb-4624-a07f-fc84e8c82de8\" target=\"_blank\" rel=\"noreferrer noopener\">Create navigation forms<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-form-in-access-5d550a3d-92e1-4f38-9772-7e7e21e80c6b\" target=\"_blank\" rel=\"noreferrer noopener\">Create a form in Access<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Protect and maintain databases<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Compact a database, repair a database, back up a database, split a database, encrypt a database with a password, recover data from backup <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2\" target=\"_blank\" rel=\"noreferrer noopener\">Compact and repair a database<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/encrypt-a-database-by-using-a-database-password-12aa0e5c-34c6-4957-af3b-b5f5cfa9a766\" target=\"_blank\" rel=\"noreferrer noopener\">Encrypt a database by using a database password<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Print and export data<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Print reports, print records, save a database as a template, export objects to alternative formats <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/document-and-print-your-database-design-8bb56649-dd17-4d2e-b8dc-17dddd1ac91a\" target=\"_blank\" rel=\"noreferrer noopener\">Document and print your database design<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/export-a-database-object-to-another-access-database-4e2cd6dd-e482-441e-88b5-aa5319a428a6\" target=\"_blank\" rel=\"noreferrer noopener\">Export a database object to another Access database<\/a>)<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Build tables (25-30%)<\/strong><\/h5>\n\n\n\n<p>Create tables<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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 <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-table-and-add-fields-8fdc65f9-8d40-4ff5-9212-80e6545e8d87\" target=\"_blank\" rel=\"noreferrer noopener\">Create a table and add fields<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-new-database-32a1ea1c-a155-43d6-aa00-f08cd1a8f01e\" target=\"_blank\" rel=\"noreferrer noopener\">Create a new database<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/import-or-link-to-data-in-another-access-database-095ab408-89c7-45b3-aac2-58036e45fcf6\" target=\"_blank\" rel=\"noreferrer noopener\">Import or link to data in another Access database<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Manage tables<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hide fields in tables, add total rows, add table descriptions, rename tables <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sum-data-by-using-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a\" target=\"_blank\" rel=\"noreferrer noopener\">Sum data by using a query<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Manage records in tables<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Update records, add records, delete records, append records from external data, find and replace data, sort records, filter records <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/ways-to-add-edit-and-delete-records-5e90a80c-106d-4c55-996e-07d7200980ce\" target=\"_blank\" rel=\"noreferrer noopener\">Ways to add, edit, and delete records<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-and-run-an-update-query-9dddc97c-f17d-43f4-a729-35e5ee1e0514\" target=\"_blank\" rel=\"noreferrer noopener\">Create and run an update query<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-records-to-a-table-by-using-an-append-query-98a5bd66-2190-4243-9638-8ef649cf3596\" target=\"_blank\" rel=\"noreferrer noopener\">Add records to a table by using an append query<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Create and modify fields<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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 <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/introduction-to-data-types-and-field-properties-30ad644f-946c-442e-8bd2-be067361987c\" target=\"_blank\" rel=\"noreferrer noopener\">Introduction to data types and field properties<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/restrict-data-input-by-using-validation-rules-b91c6b15-bcd3-42c1-90bf-e3a0272e988d\" target=\"_blank\" rel=\"noreferrer noopener\">Restrict data input by using validation rules<\/a>)<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create queries (20-25%)<\/strong><\/h5>\n\n\n\n<p>Create a query<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Run a query, create a crosstab query, create a parameter query, create an action query, create a multi-table query, save a query <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/run-a-query-eb6f9f79-28de-468f-a464-c6f7a7f09f18\" target=\"_blank\" rel=\"noreferrer noopener\">Run a query<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/introduction-to-queries-a9739a09-d3ff-4f36-8ac3-5760249fb65c\" target=\"_blank\" rel=\"noreferrer noopener\">Introduction to queries<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/use-a-screen-reader-to-create-a-query-in-access-desktop-databases-8d7fa799-06a4-43c7-9a05-9d56fde93921\" target=\"_blank\" rel=\"noreferrer noopener\">Use a screen reader to create a query in Access desktop databases<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Modify a query<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Rename a query, add fields, remove fields, hide fields, sort data within queries, format fields within queries <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-table-and-add-fields-8fdc65f9-8d40-4ff5-9212-80e6545e8d87\" target=\"_blank\" rel=\"noreferrer noopener\">Create a table and add fields<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/introduction-to-queries-a9739a09-d3ff-4f36-8ac3-5760249fb65c\" target=\"_blank\" rel=\"noreferrer noopener\">Introduction to queries<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Create calculated fields and grouping within queries<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add calculated fields, set filtering criteria, group and summarize data, group data by using comparison operators, group data by using arithmetic and logical operators <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-grouped-or-summary-report-f23301a1-3e0a-4243-9002-4a23ac0fdbf3\" target=\"_blank\" rel=\"noreferrer noopener\">Create a grouped or summary report<\/a>)<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create forms (15-20%)<\/strong><\/h5>\n\n\n\n<p>Create a form<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a form, create a form from a template with application parts, save a form <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-form-in-access-5d550a3d-92e1-4f38-9772-7e7e21e80c6b\" target=\"_blank\" rel=\"noreferrer noopener\">Create a form in Access<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Configure form controls<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Move form controls, add form controls, modify data sources, remove form controls, set form control properties, manage labels, add sub-forms <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-controls-to-customize-an-object-60378304-2969-4878-bbbb-f87ea3d9f76e\" target=\"_blank\" rel=\"noreferrer noopener\">Add controls to customize an object<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-a-field-to-a-form-or-report-0d5e2740-3b39-4341-8ec2-32c9f82cbfce\" target=\"_blank\" rel=\"noreferrer noopener\">Add a field to a form or report<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Format a form<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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 <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/set-the-tab-order-for-controls-2b37e49b-52d1-4f03-ae33-9e6d9c103c99\" target=\"_blank\" rel=\"noreferrer noopener\">Set the tab order for controls<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/modify-edit-or-change-a-report-2837aea7-0ee5-4c81-9f0f-5cf324c2c3bd\" target=\"_blank\" rel=\"noreferrer noopener\">Modify, edit, or change a report<\/a>)<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create reports (15-20%)<\/strong><\/h5>\n\n\n\n<p>Create a report<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a report based on the query or table, create a report in Design view, create a report by using a wizard <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-query-form-or-report-in-access-04eb597f-cb77-47be-83ed-1b8325b34cde#:~:text=Create%20a%20report,wizard%20screens%2C%20and%20select%20Finish.\" target=\"_blank\" rel=\"noreferrer noopener\">Create a query, form, or report in Access<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-simple-report-408e92a8-11a4-418d-a378-7f1d99c25304\" target=\"_blank\" rel=\"noreferrer noopener\">Create a simple report<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/guide-to-designing-reports-876a6d27-59aa-467a-8240-ee6e01597291\" target=\"_blank\" rel=\"noreferrer noopener\">Guide to designing reports<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Configure report controls<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Group and sort fields, modify data sources, add report controls, add and modify labels <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-grouped-or-summary-report-f23301a1-3e0a-4243-9002-4a23ac0fdbf3\" target=\"_blank\" rel=\"noreferrer noopener\">Create a grouped or summary report<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-a-field-to-a-form-or-report-0d5e2740-3b39-4341-8ec2-32c9f82cbfce\" target=\"_blank\" rel=\"noreferrer noopener\">Add a field to a form or report<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Format a report<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Exam Policies&nbsp;<\/strong><\/h5>\n\n\n\n<p>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&nbsp;<a href=\"https:\/\/docs.microsoft.com\/learn\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Certification exam policies<\/a>, together with the specified exam delivery provider\u2019s policies and procedures.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/University-of-the-Philippines-College-of-Human-Economics-Clothing-Textiles-ad-Interior-Design-Department-2-1.png\" alt=\"Microsoft Exam 77-730 FAQ\" class=\"wp-image-40299\"\/><\/figure>\n<\/div>\n\n\n<h5 class=\"wp-block-heading has-text-align-center\"><strong>Microsoft Exam 77-730 FAQ<\/strong><\/h5>\n\n\n\n<p>Also, you can go through the Exam Retake Policy together with other Microsoft exams available and&nbsp;<a href=\"https:\/\/docs.microsoft.com\/learn\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">exam testing procedures<\/a>. The exam policy page provides details of the exam provider\u2019s policies and procedures together with the exam provider\u2019s details. Note, you will have 30 days after taking an exam to challenge your exam score for that exam.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft Exam <strong>77-730<\/strong><\/strong>: <strong>Preparatory Guide<\/strong><\/h3>\n\n\n\n<p>Let us now begin the ideal preparation for&nbsp;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.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"2000\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Charity-Infographic-11-1.png\" alt=\"Exam 77-730: preparatory guide \" class=\"wp-image-40305\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Charity-Infographic-11-1.png 800w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Charity-Infographic-11-1-160x400.png 160w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Learning Platform&nbsp;<\/strong><\/h4>\n\n\n\n<p>Microsoft offers&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/\" target=\"_blank\" rel=\"noreferrer noopener\">various learning paths<\/a>, 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&nbsp;<a href=\"https:\/\/query.prod.cms.rt.microsoft.com\/cms\/api\/am\/binary\/RE3Y5Ax\" target=\"_blank\" rel=\"noreferrer noopener\">study guide for Exam 77-730: Access 2016<\/a> on the official website of Microsoft.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Documentation<\/strong><\/h4>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Documentations<\/a>&nbsp;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:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/visualstudio\/data-tools\/connect-to-data-in-an-access-database-windows-forms?view=vs-2019\" target=\"_blank\" rel=\"noreferrer noopener\">Connect to data in an Access database<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/client-developer\/access\/desktop-database-reference\/changes-in-access\" target=\"_blank\" rel=\"noreferrer noopener\">Changes in Access<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/access\/concepts\/structured-query-language\/create-and-delete-tables-and-indexes-using-access-sql\" target=\"_blank\" rel=\"noreferrer noopener\">Create and delete tables and indexes using Access SQL<\/a> <\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/access\/concepts\/structured-query-language\/insert-update-and-delete-records-from-a-table-using-access-sql\" target=\"_blank\" rel=\"noreferrer noopener\">Insert, update, and delete records from a table using Access SQL<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/troubleshoot\/access\/how-to-change-query-properties\" target=\"_blank\" rel=\"noreferrer noopener\">How to modify query properties in Microsoft Access<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/client-developer\/access\/format-function-access-custom-web-app\" target=\"_blank\" rel=\"noreferrer noopener\">Format Function (Access custom web app)<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/access.form.controls\" target=\"_blank\" rel=\"noreferrer noopener\">Form.Controls property (Access)<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/access.form\" target=\"_blank\" rel=\"noreferrer noopener\">Form object (Access)<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/access.report\" target=\"_blank\" rel=\"noreferrer noopener\">Report object (Access)<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/troubleshoot\/access\/programmatically-create-new-column\" target=\"_blank\" rel=\"noreferrer noopener\">How to programmatically create a new column in an Access report<\/a><\/strong><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Instructor-Led Training<\/strong><\/h4>\n\n\n\n<p>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.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Books and Guides&nbsp;<\/strong><\/h4>\n\n\n\n<p>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:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MOS 2016 Study Guide for Microsoft Access (MOS Study Guide) Part of MOS Study Guide (21 Books)&nbsp;&nbsp;|&nbsp;by&nbsp;John Pierce<\/li>\n\n\n\n<li>Microsoft Access 2016 Programming By Example: with VBA, XML, and ASP by&nbsp;Julitta Korol<\/li>\n\n\n\n<li>Introductory Relational Database Design for Business, with Microsoft Access by&nbsp;Jonathan Eckstein&nbsp;and&nbsp;Bonnie R. Schultz<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Join a Study Group&nbsp;<\/strong><\/h4>\n\n\n\n<p>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.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Practice Test<\/strong><\/h4>\n\n\n\n<p>The most important step is to try your hands on the practice test.&nbsp;<a href=\"https:\/\/www.testpreptraining.ai\/access-2016-core-database-management-manipulation-and-query-skills-77-730-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Practice tests<\/a>&nbsp;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! <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/access-2016-core-database-management-manipulation-and-query-skills-77-730-free-practice-test\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Try-Online-Tutorial-HERE-4-1.jpg\" alt=\"Exam 77-730: Access 2016 Free Practice Tests\" class=\"wp-image-40300\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Try-Online-Tutorial-HERE-4-1.jpg 961w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/Try-Online-Tutorial-HERE-4-1-750x117.jpg 750w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>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\u2019s environment. They should understand basic database design principles and are able to complete tasks independently. Also, they should&#8230;<\/p>\n","protected":false},"author":1,"featured_media":40298,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[1226],"tags":[5381,5385,5382,5386,5383,5384,4],"class_list":["post-40182","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","tag-exam-77-730-access-2016-core-database-management","tag-exam-77-730-access-2016-core-database-management-faq","tag-exam-77-730-access-2016-core-database-management-free-practice-test","tag-exam-77-730-access-2016-core-database-management-learning-resources","tag-exam-77-730-access-2016-core-database-management-online-tutorial","tag-exam-77-730-access-2016-core-database-management-preparatory-guide","tag-m4f"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Gather the knowledge about Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Testprep Training!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Gather the knowledge about Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Testprep Training!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-08T10:40:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/How-do-I-prepare-for-Salesforce-Identity-and-Access-Management-Designer-Exam-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/\",\"name\":\"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-05-10T09:12:40+00:00\",\"dateModified\":\"2024-05-08T10:40:38+00:00\",\"description\":\"Gather the knowledge about Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Testprep Training!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills - Testprep Training Tutorials","description":"Gather the knowledge about Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Testprep Training!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/","og_locale":"en_US","og_type":"article","og_title":"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills - Testprep Training Tutorials","og_description":"Gather the knowledge about Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Testprep Training!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2024-05-08T10:40:38+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/How-do-I-prepare-for-Salesforce-Identity-and-Access-Management-Designer-Exam-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/","name":"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-05-10T09:12:40+00:00","dateModified":"2024-05-08T10:40:38+00:00","description":"Gather the knowledge about Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills with Testprep Training!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-730-access-2016-core-database-management-manipulation-and-query-skills\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/40182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=40182"}],"version-history":[{"count":21,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/40182\/revisions"}],"predecessor-version":[{"id":62639,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/40182\/revisions\/62639"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/40298"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=40182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=40182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=40182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}