{"id":62509,"date":"2024-04-30T09:33:34","date_gmt":"2024-04-30T09:33:34","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=62509"},"modified":"2024-05-22T05:23:16","modified_gmt":"2024-05-22T05:23:16","slug":"exam-mo-500-microsoft-access-expert-office-2019-3","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/","title":{"rendered":"Exam MO-500: Microsoft Access Expert (Office 2019)"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-711x400.jpg\" alt=\"Exam MO-500: Microsoft Access Expert (Office 2019)\" class=\"wp-image-62510\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-711x400.jpg 711w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-scaled.jpg 1000w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><\/figure>\n<\/div>\n\n\n<p>The Exam MO-500, designated for Microsoft Access Expert (Office 2019), assesses candidates&#8217; proficiency in utilizing the primary features of Access 2019, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creating and managing Access database components.<\/li>\n\n\n\n<li>Grasping database design fundamentals.<\/li>\n<\/ul>\n\n\n\n<p>Database objects covered in the exam include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tables<\/li>\n\n\n\n<li>Relationships<\/li>\n\n\n\n<li>Data entry forms<\/li>\n\n\n\n<li>Multilevel reports<\/li>\n\n\n\n<li>Multi-table queries<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Knowledge Requirments:<\/strong><\/h3>\n\n\n\n<p>As a candidate for the <a href=\"https:\/\/www.testpreptraining.ai\/microsoft-access-expert-office-2019-mo-500-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft MO-500 Exam<\/a>, it&#8217;s recommended to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Have approximately 150 hours of instructional and hands-on experience with the software.<\/li>\n\n\n\n<li>Demonstrate competency at an industry-recognized expert level.<\/li>\n\n\n\n<li>Prepare to enter the job market with confidence.<\/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=\"747\" height=\"353\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-30-144203.png\" alt=\"mo500 exam details\" class=\"wp-image-62511\"\/><\/figure>\n<\/div>\n\n\n<p>Passing the&nbsp;Exam MO-500  will help candidates earn the Microsoft Office Specialist: Microsoft Access Expert (Office 2019) certification. The exam will have 40-60 questions with a time limit of 50 minutes. The exam is available in English, Japanese, French, Chinese (Simplified), Chinese (Traditional), German, Korean, and Spanish Language.<\/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.testpreptraining.ai\/microsoft-access-expert-office-2019-mo-500-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\">MO-500 exam<\/a> covers the following topics:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"323\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-30-144309.png\" alt=\"Exam MO-500: Microsoft Access Expert (Office 2019) course outline\" class=\"wp-image-62512\"\/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><strong>Topic 1: Manage databases<\/strong><\/h4>\n\n\n\n<p>Modify database structure<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>import objects or data from other sources <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a\" target=\"_blank\" rel=\"noreferrer noopener\">Import data from data sources (Power Query)<\/a>)<\/li>\n\n\n\n<li>delete database objects <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/ssma\/access\/adding-and-removing-access-database-files-accesstosql?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Adding and Removing Access Database Files (AccessToSQL)<\/a>)<\/li>\n\n\n\n<li>hide and display objects in the Navigation Pane <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-the-navigation-pane-274dfc5a-281b-472b-94e2-ef931c5cc590#:~:text=To%20display%20hidden%20objects%20or%20groups&amp;text=to%20the%20objects.-,Right%2Dclick%20the%20menu%20bar%20at%20the%20top%20of%20the,box%2C%20and%20then%20click%20OK.\" target=\"_blank\" rel=\"noreferrer noopener\">Use the Navigation Pane<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Manage table relationships and keys<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>understand relationships <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/troubleshoot\/access\/define-table-relationships\" target=\"_blank\" rel=\"noreferrer noopener\">How to define relationships between tables in an Access database<\/a>)<\/li>\n\n\n\n<li>display relationships <strong>(Microsoft Documentation:<\/strong> <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\n\n\n<li>set primary keys <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/add-a-primary-key-to-a-table-in-access-c6055b7f-4dfe-4516-901c-95272d74a6ff\" target=\"_blank\" rel=\"noreferrer noopener\">Add a primary key to a table in Access<\/a>)<\/li>\n\n\n\n<li>enforce referential integrity <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>)<\/li>\n\n\n\n<li>set foreign keys<\/li>\n<\/ul>\n\n\n\n<p>Print and export data<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>configure print options for records, forms, and reports <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/set-print-options-in-access-bc8a0421-c6b7-4a5a-a813-90273f692517\" target=\"_blank\" rel=\"noreferrer noopener\">Set print options in Access<\/a>)<\/li>\n\n\n\n<li>export objects to alternative formats <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/export-data-to-a-text-file-f72dfc38-a8a0-4c5b-8c2c-bf2950814140#:~:text=Open%20the%20source%20database%20in,in%20a%20single%20export%20operation.\" target=\"_blank\" rel=\"noreferrer noopener\">Export data to a text file<\/a>)<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Topic 2: Create and modify tables<\/strong><\/h4>\n\n\n\n<p>Create tables<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>import data into tables <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/import-database-objects-into-the-current-access-database-23aea08b-7487-499d-bdce-0c76bedacfdd#:~:text=Select%20Import%20tables%2C%20queries%2C%20forms,object%2C%20click%20the%20object%20again.\" target=\"_blank\" rel=\"noreferrer noopener\">Import database objects into the current Access database<\/a>)<\/li>\n\n\n\n<li>create linked tables from external sources <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/manage-linked-tables-1d9346d6-953d-4f85-a9ce-4caec2262797#:~:text=Add%20a%20data%20source%20and%20linked%20tables,-You%20can%20add&amp;text=changes%20connection%20strings.-,Select%20External%20Data%20%3E%20Linked%20Table%20Manager.,in%20the%20Display%20name%20box.\" target=\"_blank\" rel=\"noreferrer noopener\">Manage linked tables<\/a>)<\/li>\n\n\n\n<li>import tables from other databases<\/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 <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/show-or-hide-columns-in-a-datasheet-902a1aba-dcfc-4ef6-ad8d-16c9609cb433\" target=\"_blank\" rel=\"noreferrer noopener\">Show or hide columns in a datasheet<\/a>)<\/li>\n\n\n\n<li>add total rows<\/li>\n\n\n\n<li>add table descriptions <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>)<\/li>\n<\/ul>\n\n\n\n<p>Manage table records<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>find and replace data <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-the-find-and-replace-dialog-box-to-change-data-2eee8d02-5a40-4328-ba56-ec0406865680#:~:text=%E2%80%93or%E2%80%93-,Press%20CTRL%2BF.,operation%2C%20click%20the%20Replace%20tab.\" target=\"_blank\" rel=\"noreferrer noopener\">Use the Find and Replace dialog box to change data<\/a>)<\/li>\n\n\n\n<li>sort records <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/access.report.orderby\" target=\"_blank\" rel=\"noreferrer noopener\">Report.OrderBy property (Access)<\/a>)<\/li>\n\n\n\n<li>filter records <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/apply-a-filter-to-view-select-records-in-an-access-database-2a493ded-e544-4144-9103-b9b1d1865147\" target=\"_blank\" rel=\"noreferrer noopener\">Apply a filter to view select records in an Access database<\/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 and remove fields <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-or-delete-a-column-in-a-datasheet-02064e10-3fd7-4377-8034-c6f75dc5a12c#:~:text=On%20the%20Access%20status%20bar,Save%20your%20changes.\" target=\"_blank\" rel=\"noreferrer noopener\">Add or delete a column in a datasheet<\/a>)<\/li>\n\n\n\n<li>add validation rules to fields <strong>(Microsoft Documentation:<\/strong> <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\n\n\n<li>change field captions <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/modify-your-new-database-created-from-a-template-9211e351-6d96-48a3-95ee-651e8d478747#:~:text=in%20Design%20view.-,Click%20the%20cell%20in%20the%20Field%20Name%20column%20for%20the,on%20the%20Quick%20Access%20Toolbar.\" target=\"_blank\" rel=\"noreferrer noopener\">Modify your new database created from a template<\/a>)<\/li>\n\n\n\n<li>change field sizes<\/li>\n\n\n\n<li>change field data types <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/modify-or-change-the-data-type-setting-for-a-field-1334e8b4-ee5c-48df-9ba1-8d0e1e9c114c#:~:text=Select%20the%20field%20(the%20column,Save%20your%20changes.\" target=\"_blank\" rel=\"noreferrer noopener\">Modify or change the data type setting for a field<\/a>)<\/li>\n\n\n\n<li>configure fields to auto-increment <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-an-autonumber-field-as-a-primary-key-96ba683b-7f86-4354-aa25-3849f5e5b641#:~:text=In%20the%20Data%20Type%20field,Random%20to%20use%20random%20numbers.\" target=\"_blank\" rel=\"noreferrer noopener\">Add an AutoNumber field as a primary key<\/a>)<\/li>\n\n\n\n<li>set default values<\/li>\n\n\n\n<li>apply built-in input masks <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/control-data-entry-formats-with-input-masks-e125997a-7791-49e5-8672-4a47832de8da\" target=\"_blank\" rel=\"noreferrer noopener\">Control data entry formats with input masks<\/a>)<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-access-expert-office-2019-mo-500-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"117\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/MO-500-Microsoft-Access-Expert-Office-2019-practice-exam-750x117.jpg\" alt=\"m0500 practice exam\" class=\"wp-image-62516\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/MO-500-Microsoft-Access-Expert-Office-2019-practice-exam-750x117.jpg 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/MO-500-Microsoft-Access-Expert-Office-2019-practice-exam.jpg 961w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><strong>Topic 3: Create and modify queries<\/strong><\/h4>\n\n\n\n<p>Create and run queries<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>create simple queries <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/create-a-query-form-or-report-in-access-04eb597f-cb77-47be-83ed-1b8325b34cde#:~:text=Create%20a%20select%20query&amp;text=Select%20Create%20%3E%20Query%20Wizard%20.,view%2C%20and%20then%20select%20Finish.\" target=\"_blank\" rel=\"noreferrer noopener\">Create a query, form, or report in Access<\/a>)<\/li>\n\n\n\n<li>create basic crosstab queries <strong>(Microsoft Documentation:<\/strong> <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\n\n\n<li>create basic parameter queries<\/li>\n\n\n\n<li>create basic action queries<\/li>\n\n\n\n<li>create basic multi-table queries<\/li>\n\n\n\n<li>save queries<\/li>\n\n\n\n<li>run queries <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>)<\/li>\n<\/ul>\n\n\n\n<p>Modify queries<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>add, hide, and remove fields in queries <strong>(Microsoft Documentation:<\/strong> <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\n\n\n<li>sort data within queries <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/save-a-sort-order-with-a-table-query-form-or-report-4f255441-7326-486a-97ad-7760e8b0880b#:~:text=On%20the%20Home%20tab%2C%20in,want%20to%20use%20to%20sort.\" target=\"_blank\" rel=\"noreferrer noopener\">Save a sort order with a table, query, form, or report<\/a>)<\/li>\n\n\n\n<li>filter data within queries <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/filter-data-in-a-query-a462c0c9-f92c-4004-8868-f9de61153d18\" target=\"_blank\" rel=\"noreferrer noopener\">Filter data in a query<\/a>)<\/li>\n\n\n\n<li>format fields within queries<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Topic 4: Modify forms in the layout view<\/strong><\/h4>\n\n\n\n<p>Configure form controls<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>add, move, and remove form controls <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/move-and-resize-controls-independently-3d0bebde-592d-4191-adc8-f8db0650a761\" target=\"_blank\" rel=\"noreferrer noopener\">Move and resize controls independently<\/a>)<\/li>\n\n\n\n<li>set form control properties<\/li>\n\n\n\n<li>add and modify form labels <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-mailing-labels-in-access-c54318db-a91d-45db-ab2b-1068b6346242\" target=\"_blank\" rel=\"noreferrer noopener\">Create mailing labels in Access<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Format forms<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>modify tab order on forms <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>)<\/li>\n\n\n\n<li>sort records by form field <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/orderby-property-c6ebd0c0-76dc-4a0e-981d-fd44428aea7c#:~:text=For%20forms%2C%20select%20the%20field,or%20reports%20by%20using%20VBA.\" target=\"_blank\" rel=\"noreferrer noopener\">OrderBy Property<\/a>)<\/li>\n\n\n\n<li>modify form positioning<\/li>\n\n\n\n<li>insert information in form headers and footers<\/li>\n\n\n\n<li>insert images on forms<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Topic 5: Modify reports in the layout view<\/strong><\/h4>\n\n\n\n<p>Configure report controls<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>group and sort fields on reports <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-grouped-or-summary-report-f23301a1-3e0a-4243-9002-4a23ac0fdbf3#:~:text=and%20Total%20pane-,On%20the%20Report%20Layout%20Design%20tab%2C%20in%20the%20Grouping%20%26%20Totals,%2C%20Sort%2C%20and%20Total%20pane.\" target=\"_blank\" rel=\"noreferrer noopener\">Create a grouped or summary report<\/a>)<\/li>\n\n\n\n<li>add report controls <strong>(Microsoft Documentation:<\/strong> <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\n\n\n<li>add and modify labels on reports <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/modify-edit-or-change-a-report-2837aea7-0ee5-4c81-9f0f-5cf324c2c3bd#:~:text=On%20the%20Design%20tab%2C%20in%20the%20Header%2FFooter%20group%2C,typing%20the%20title%20you%20want.\" target=\"_blank\" rel=\"noreferrer noopener\">Modify, edit, or change a report<\/a>)<\/li>\n<\/ul>\n\n\n\n<p>Format reports<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>format a report into multiple columns<\/li>\n\n\n\n<li>modify report positioning <strong>(Microsoft Documentation:<\/strong> <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\n\n\n<li>format report elements <strong>(Microsoft Documentation:<\/strong> <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\n\n\n<li>change report orientation<\/li>\n\n\n\n<li>insert information in report headers and footers<\/li>\n\n\n\n<li>insert images on reports<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>FAQs: Exam MO-500<\/strong><\/h2>\n\n\n\n<p><strong><em><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-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.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-faqs\/\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-faqs-711x400.jpg\" alt=\"faqs mo500\" class=\"wp-image-62513\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-faqs-711x400.jpg 711w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-faqs-scaled.jpg 1000w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><strong>Exam policy<\/strong><\/h2>\n\n\n\n<p>The&nbsp;<a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/support\/exam-duration-exam-experience\" target=\"_blank\" rel=\"noreferrer noopener\">examination<\/a>&nbsp;will be monitored by a proctor and is not open to reference materials. Interactive segments may be included as integral parts of the assessment. In the event of an unsuccessful attempt at the certification exam, there\u2019s no need for concern. You are eligible to&nbsp;<a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/support\/retake-policy\" target=\"_blank\" rel=\"noreferrer noopener\">retake<\/a>&nbsp;the exam after a 24-hour period from the initial attempt. For subsequent retakes, the waiting period may differ.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Study Guide for Microsoft MO-500 Exam<\/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.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-guide-scaled.jpg\" alt=\"Exam MO-500: Microsoft Access Expert (Office 2019) study guide\" class=\"wp-image-62515\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-guide-scaled.jpg 667w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-guide-267x400.jpg 267w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>1. Get Familiar with the Exam Objectives<\/strong><\/h3>\n\n\n\n<p>To sufficiently prepare themselves for the MO-500 Exam, candidates should acquaint themselves with the exam objectives to guarantee comprehensive preparedness. This certification examines proficiency in managing databases, creating tables, modifying forms, reports, and queries. The exam includes a range of subjects, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Manage databases<\/li>\n\n\n\n<li>Create and modify tables<\/li>\n\n\n\n<li>Create and modify queries<\/li>\n\n\n\n<li>Modify forms in layout view<\/li>\n\n\n\n<li>Modify reports in layout view<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2. Use Microsoft Learn<\/strong><\/h3>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/mos-access-expert-2019\/?practice-assessment-type=certification\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Learn<\/a>&nbsp;is an extensive platform created to equip individuals with the knowledge and skills essential for success within the Microsoft ecosystem. Providing a wide array of free, self-paced learning modules featuring interactive tutorials, practical labs, and assessments, users can explore a multitude of Microsoft technologies. Through adaptive learning pathways, the platform steers learners on personalized journeys tailored to their interests and career aspirations.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3. Microsoft Official Study Guide for Microsoft Access Expert Exam MO-500<\/strong><\/h3>\n\n\n\n<p>This is the official study guide for the MO-500 exam. It covers all of the exam objectives in detail and provides practice exercises to help you test your knowledge. Use this to increase your chances of passing the MO-500 exam and becoming a Microsoft Access Certified Expert.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>4. Join Study Groups<\/strong><\/h3>\n\n\n\n<p>Engaging in study groups or communities is a highly effective approach for enriching your learning experience. By becoming a part of study groups or communities aligned with your areas of interest or certification objectives, you gain opportunities to participate in discussions and exchange insights and experiences with peers. Additionally, you can leverage the diverse perspectives and expertise of fellow members. Study groups provides a supportive atmosphere where members extend encouragement, assistance, and guidance to one another. This network of support proves invaluable, especially during difficult moments or when navigating obstacles in your learning path.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>5. Take Practice Tests<\/strong><\/h3>\n\n\n\n<p>Utilizing practice tests for the MO-500 exam helps in identifying both your strengths and areas needing improvement. This assessment enhances your ability to handle questions effectively, potentially refining your time management during the actual exam. To ensure optimal readiness, it is recommended to engage in these practice tests after concluding each topic, reinforcing your comprehension of the study materials.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-access-expert-office-2019-mo-500-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"117\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/MO-500-Microsoft-Access-Expert-Office-2019-practice-exam-tests-750x117.jpg\" alt=\"practice tests m0500\" class=\"wp-image-62517\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/MO-500-Microsoft-Access-Expert-Office-2019-practice-exam-tests-750x117.jpg 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/MO-500-Microsoft-Access-Expert-Office-2019-practice-exam-tests.jpg 961w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The Exam MO-500, designated for Microsoft Access Expert (Office 2019), assesses candidates&#8217; proficiency in utilizing the primary features of Access 2019, including: Database objects covered in the exam include: Knowledge Requirments: As a candidate for the Microsoft MO-500 Exam, it&#8217;s recommended to: Exam Details Passing the&nbsp;Exam MO-500 will help candidates earn the Microsoft Office Specialist:&#8230;<\/p>\n","protected":false},"author":2,"featured_media":62510,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[1226],"tags":[10084,10085,10083,2370,4,10086,10080,9708,10062],"class_list":["post-62509","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","tag-database-design","tag-database-management","tag-exam-mo-500","tag-exam-preparation","tag-m4f","tag-microsoft-access","tag-office-2019","tag-online-tutorial","tag-study-materials"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam MO-500: Microsoft Access Expert (Office 2019) - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Access an online tutorial for Exam MO-500, focusing on Microsoft Access Expert (Office 2019). Enhance your skills Now!\" \/>\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-mo-500-microsoft-access-expert-office-2019-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam MO-500: Microsoft Access Expert (Office 2019) - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Access an online tutorial for Exam MO-500, focusing on Microsoft Access Expert (Office 2019). Enhance your skills Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-22T05:23:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-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=\"6 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-mo-500-microsoft-access-expert-office-2019-3\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/\",\"name\":\"Exam MO-500: Microsoft Access Expert (Office 2019) - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2024-04-30T09:33:34+00:00\",\"dateModified\":\"2024-05-22T05:23:16+00:00\",\"description\":\"Access an online tutorial for Exam MO-500, focusing on Microsoft Access Expert (Office 2019). Enhance your skills Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam MO-500: Microsoft Access Expert (Office 2019)\"}]},{\"@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 MO-500: Microsoft Access Expert (Office 2019) - Testprep Training Tutorials","description":"Access an online tutorial for Exam MO-500, focusing on Microsoft Access Expert (Office 2019). Enhance your skills Now!","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-mo-500-microsoft-access-expert-office-2019-3\/","og_locale":"en_US","og_type":"article","og_title":"Exam MO-500: Microsoft Access Expert (Office 2019) - Testprep Training Tutorials","og_description":"Access an online tutorial for Exam MO-500, focusing on Microsoft Access Expert (Office 2019). Enhance your skills Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2024-05-22T05:23:16+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2024\/04\/Exam-MO-500-Microsoft-Access-Expert-Office-2019-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/","name":"Exam MO-500: Microsoft Access Expert (Office 2019) - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2024-04-30T09:33:34+00:00","dateModified":"2024-05-22T05:23:16+00:00","description":"Access an online tutorial for Exam MO-500, focusing on Microsoft Access Expert (Office 2019). Enhance your skills Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-500-microsoft-access-expert-office-2019-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam MO-500: Microsoft Access Expert (Office 2019)"}]},{"@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\/62509","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=62509"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/62509\/revisions"}],"predecessor-version":[{"id":62774,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/62509\/revisions\/62774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/62510"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=62509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=62509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=62509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}