{"id":814,"date":"2025-05-20T07:01:17","date_gmt":"2025-05-20T07:01:17","guid":{"rendered":"https:\/\/www.skilr.com\/tutorial\/?page_id=814"},"modified":"2025-05-20T07:01:18","modified_gmt":"2025-05-20T07:01:18","slug":"exam-77-730-microsoft-access-office-2016","status":"publish","type":"page","link":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/","title":{"rendered":"Exam 77-730: Microsoft Access (Office 2016)"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-1024x576.jpg\" alt=\"Exam 77-730: Microsoft Access (Office 2016)\" class=\"wp-image-816\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-1024x576.jpg 1024w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-300x169.jpg 300w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg 1000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Exam 77-730 is intended for candidates who possess a foundational understanding of the Microsoft Access 2016 environment and seek to validate their proficiency in utilizing the application\u2019s core functionalities. The exam assesses the candidate\u2019s ability to efficiently create, manage, and manipulate essential database objects, applying fundamental database design principles to ensure data integrity and usability.<\/p>\n\n\n\n<p>This <a href=\"https:\/\/www.skilr.com\/access-2016-core-database-management-manipulation-and-query-skills-77-730-exam-skilr\" target=\"_blank\" rel=\"noreferrer noopener\">certification<\/a> is ideal for professionals seeking to demonstrate their capability to work proficiently with Microsoft Access 2016 in real-world scenarios, ensuring accurate data handling and reporting within business environments. This includes<strong>:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Development and Maintenance of Database Objects:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Candidates will demonstrate competence in creating and managing fundamental Access objects, including tables, forms, queries, and reports, to support robust data management solutions.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Application of Database Design Principles:<\/strong>\n<ul class=\"wp-block-list\">\n<li>The exam evaluates the candidate\u2019s understanding of basic database design concepts, such as table relationships and data normalization, critical to building efficient and scalable databases.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>&#8211; Key Database Components<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tables:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Creation and structuring of tables to organize data systematically.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Relationships:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Defining and managing relationships between tables to enforce referential integrity and support complex data interactions.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Forms:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Designing and implementing data entry forms to facilitate user-friendly input and data validation.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Reports:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Generating multi-level reports to summarize, analyze, and present data effectively.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Queries:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Constructing multi-table queries to extract and manipulate data across related tables.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Exam Details<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"344\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-20-120923.png\" alt=\"Microsoft Access (Office 2016)\" class=\"wp-image-817\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-20-120923.png 813w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-20-120923-300x127.png 300w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><\/figure>\n<\/div>\n\n\n<p>Exam 77-730: Microsoft Access (Office 2016) is designed for intermediate-level candidates, primarily targeting business users working with Access professionally. The assessment lasts 50 minutes and is administered under proctored conditions to ensure exam integrity. This is a closed-book exam that may include interactive components requiring hands-on demonstration of skills. The exam is available in multiple languages, including English, Simplified and Traditional Chinese, Dutch, Spanish, French, Japanese, and Korean, providing accessibility for a diverse range of candidates.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Course Outline<\/strong><\/h2>\n\n\n\n<p>The <a href=\"https:\/\/www.skilr.com\/access-2016-core-database-management-manipulation-and-query-skills-77-730-exam-skilr\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 77-730 exam<\/a> covers the following topics:<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>1. Creating and managing 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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>2. Understand how to 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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>3. Learn about creating 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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.skilr.com\/access-2016-core-database-management-manipulation-and-query-skills-77-730-exam-skilr\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-4.jpg\" alt=\"Exam 77-730: Microsoft Access (Office 2016)\" class=\"wp-image-818\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-4.jpg 961w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-4-300x47.jpg 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h5 class=\"wp-block-heading\"><strong>4. Creating 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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>5. Learn how to 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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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>,\u00a0<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\u00a0<strong>(Microsoft Documentation:<\/strong>\u00a0<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>,\u00a0<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<h2 class=\"wp-block-heading\" id=\"ftoc-heading-12-2\"><strong>Microsoft 77-730 Exam FAQs<\/strong><\/h2>\n\n\n\n<p><strong><em><a href=\"https:\/\/www.skilr.com\/tutorial\/microsoft-77-730-exam-faqs\/\" target=\"_blank\" rel=\"noreferrer noopener\">Click Here for FAQs!<\/a><\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.skilr.com\/tutorial\/microsoft-77-730-exam-faqs\/\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-1-1024x576.jpg\" alt=\"Microsoft Access (Office 2016)\" class=\"wp-image-819\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-1-1024x576.jpg 1024w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-1-300x169.jpg 300w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-1-scaled.jpg 1000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><strong>Microsoft Certification Exam Policies<\/strong><\/h2>\n\n\n\n<p>Microsoft upholds strict <a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">exam policies<\/a> to ensure the integrity, fairness, and global credibility of its certification program. These guidelines provide a consistent and secure testing environment for all candidates, whether exams are taken online or at authorized test centers, safeguarding the professional standards associated with Microsoft certifications.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Exam Retake Policy<\/strong>\n<ul class=\"wp-block-list\">\n<li>Candidates who do not pass an exam must wait 24 hours before retaking it. Subsequent attempts, from the second to the fifth, require a 14-day waiting period. A maximum of five attempts is allowed within 12 months from the first attempt, ensuring that certification reflects genuine proficiency.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Rescheduling and Cancellation Policy<\/strong>\n<ul class=\"wp-block-list\">\n<li>Candidates can reschedule or cancel exams without penalty if changes are made at least six business days prior. Rescheduling or canceling within five business days may incur fees, and no-shows or cancellations within 24 hours result in forfeiture of the exam fee. Exceptions for emergencies or accessibility issues may be granted upon submission of valid documentation and review by Microsoft.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Microsoft\u00a077-730\u00a0Exam Study Guide<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"1000\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-2-scaled.jpg\" alt=\"Exam 77-730 guide\" class=\"wp-image-820\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-2-scaled.jpg 667w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-2-200x300.jpg 200w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Understand the Exam Objectives Thoroughly<\/strong><\/h3>\n\n\n\n<p>The first and most essential step in preparing for <a href=\"https:\/\/www.skilr.com\/access-2016-core-database-management-manipulation-and-query-skills-77-730-exam-skilr\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 77-730<\/a> is to become familiar with the official exam objectives outlined by Microsoft. These objectives define the core skills that will be assessed, including creating and modifying tables, designing queries, building forms for data entry, and generating multi-level reports. Carefully review each objective and break it down into specific tasks you need to master. For example, \u201cCreate tables\u201d involves understanding data types, setting primary keys, and configuring field properties. By fully understanding what the exam expects, you can focus your study on the areas that matter most and avoid spending time on irrelevant topics. Keep a checklist to track your progress as you study each section.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Utilize Official Microsoft Training Resources<\/strong><\/h3>\n\n\n\n<p>Once you understand what\u2019s covered, the next step is to build your knowledge using high-quality training materials. Microsoft offers official <a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/mos-access-2016\/?practice-assessment-type=certification\" target=\"_blank\" rel=\"noreferrer noopener\">learning paths<\/a> and tutorials tailored to Access 2016, available through platforms such as Microsoft Learn or authorized training partners. These resources are specifically designed to align with the certification requirements and cover both theoretical concepts and hands-on exercises. <\/p>\n\n\n\n<p>Focus on modules that walk you through real-world tasks, such as creating relational databases, setting up relationships, creating queries, and automating tasks using macros. These official resources help you learn Access not just for the exam, but for real business applications as well. Take detailed notes, complete all interactive labs, and revisit modules that cover topics you find challenging.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Join Study Groups and Engage with Online Communities<\/strong><\/h3>\n\n\n\n<p>Studying alone can be effective, but learning within a group offers significant advantages. Consider joining dedicated Microsoft Access certification study groups on platforms like Reddit, LinkedIn, or specialized forums such as Tech Community or CertForum. These groups allow you to exchange ideas, clarify doubts, and get recommendations for supplemental resources. You\u2019ll also find shared experiences from those who have already taken the exam\u2014these insights can offer valuable tips on what to expect, how to manage your time, and common mistakes to avoid. Some communities also organize group discussions, mock exams, or live Q&amp;A sessions with experts. Active participation in such groups can provide support, motivation, and a deeper understanding of complex topics.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Take Practice Tests and Simulated Exams<\/strong><\/h3>\n\n\n\n<p>Practical application is key to mastering Microsoft Access, and nothing prepares you better than working through realistic practice tests. These 77-730 practice exams mirror the structure, difficulty, and timing of the actual test, helping you become comfortable with the format. Look for practice exams from reputable providers or Microsoft-approved practice tools. Aim to simulate the real test environment: sit in a quiet space, follow the time limit, and avoid external help. After each attempt, review your results thoroughly\u2014analyze both the correct and incorrect answers to understand the logic behind them. Repeating this process helps reinforce learning, improves speed and accuracy, and builds the confidence needed for the real exam.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Finalize Your Preparation<\/strong><\/h3>\n\n\n\n<p>As the exam date approaches, shift your focus to reviewing and reinforcing what you\u2019ve learned. Go over your notes, re-watch important training videos, and revisit modules where you felt less confident. Create summary sheets or flashcards to quickly recall key concepts, such as query types, form controls, or report formatting options. Practice tasks in Access 2016 itself\u2014repetition of real-life functions helps reinforce memory and muscle memory for the exam. If possible, schedule your exam at a time when you feel most alert and focused. The final days should be dedicated to revision and light review, not cramming new information.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.skilr.com\/access-2016-core-database-management-manipulation-and-query-skills-77-730-free-practice-test\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-3.jpg\" alt=\"Exam 77-730: Microsoft Access (Office 2016)\" class=\"wp-image-821\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-3.jpg 961w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-3-300x47.jpg 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Exam 77-730 is intended for candidates who possess a foundational understanding of the Microsoft Access 2016 environment and seek to validate their proficiency in utilizing the application\u2019s core functionalities. The exam assesses the candidate\u2019s ability to efficiently create, manage, and manipulate essential database objects, applying fundamental database design principles to ensure data integrity and usability&#8230;.<\/p>\n","protected":false},"author":2,"featured_media":816,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[95],"tags":[398,407,401,402,400,406,408,399,405,404,403,352,346],"class_list":["post-814","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","tag-access-2016","tag-access-basics","tag-access-exam-prep","tag-access-forms","tag-access-queries","tag-access-reports","tag-access-training","tag-access-tutorial","tag-database-tutorial","tag-exam-77-730","tag-microsoft-access","tag-microsoft-office-exam","tag-office-2016"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exam 77-730: Microsoft Access (Office 2016) - Skilr Tutorial<\/title>\n<meta name=\"description\" content=\"Microsoft Access 77-730 tutorial for Office 2016 exam preparation. Learn Access basics, database design, queries, forms, and reports.\" \/>\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.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 77-730: Microsoft Access (Office 2016) - Skilr Tutorial\" \/>\n<meta property=\"og:description\" content=\"Microsoft Access 77-730 tutorial for Office 2016 exam preparation. Learn Access basics, database design, queries, forms, and reports.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"Skilr Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-20T07:01:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\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=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/\",\"name\":\"Exam 77-730: Microsoft Access (Office 2016) - Skilr Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg\",\"datePublished\":\"2025-05-20T07:01:17+00:00\",\"dateModified\":\"2025-05-20T07:01:18+00:00\",\"description\":\"Microsoft Access 77-730 tutorial for Office 2016 exam preparation. Learn Access basics, database design, queries, forms, and reports.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#primaryimage\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg\",\"contentUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg\",\"width\":1000,\"height\":563,\"caption\":\"Exam 77-730: Microsoft Access (Office 2016)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.skilr.com\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 77-730: Microsoft Access (Office 2016)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#website\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/\",\"name\":\"Skilr Tutorial\",\"description\":\"An Initiative By CTI Jabalpur\",\"publisher\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.skilr.com\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#organization\",\"name\":\"Skilr\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg\",\"contentUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg\",\"width\":330,\"height\":134,\"caption\":\"Skilr\"},\"image\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam 77-730: Microsoft Access (Office 2016) - Skilr Tutorial","description":"Microsoft Access 77-730 tutorial for Office 2016 exam preparation. Learn Access basics, database design, queries, forms, and reports.","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.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/","og_locale":"en_US","og_type":"article","og_title":"Exam 77-730: Microsoft Access (Office 2016) - Skilr Tutorial","og_description":"Microsoft Access 77-730 tutorial for Office 2016 exam preparation. Learn Access basics, database design, queries, forms, and reports.","og_url":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/","og_site_name":"Skilr Tutorial","article_modified_time":"2025-05-20T07:01:18+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/","url":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/","name":"Exam 77-730: Microsoft Access (Office 2016) - Skilr Tutorial","isPartOf":{"@id":"https:\/\/www.skilr.com\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg","datePublished":"2025-05-20T07:01:17+00:00","dateModified":"2025-05-20T07:01:18+00:00","description":"Microsoft Access 77-730 tutorial for Office 2016 exam preparation. Learn Access basics, database design, queries, forms, and reports.","breadcrumb":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#primaryimage","url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg","contentUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-77-730-Microsoft-Access-Office-2016-scaled.jpg","width":1000,"height":563,"caption":"Exam 77-730: Microsoft Access (Office 2016)"},{"@type":"BreadcrumbList","@id":"https:\/\/www.skilr.com\/tutorial\/exam-77-730-microsoft-access-office-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skilr.com\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 77-730: Microsoft Access (Office 2016)"}]},{"@type":"WebSite","@id":"https:\/\/www.skilr.com\/tutorial\/#website","url":"https:\/\/www.skilr.com\/tutorial\/","name":"Skilr Tutorial","description":"An Initiative By CTI Jabalpur","publisher":{"@id":"https:\/\/www.skilr.com\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skilr.com\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skilr.com\/tutorial\/#organization","name":"Skilr","url":"https:\/\/www.skilr.com\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg","contentUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg","width":330,"height":134,"caption":"Skilr"},"image":{"@id":"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/"}}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/comments?post=814"}],"version-history":[{"count":4,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/814\/revisions"}],"predecessor-version":[{"id":826,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/814\/revisions\/826"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/media\/816"}],"wp:attachment":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/media?parent=814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/categories?post=814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/tags?post=814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}