MOS Access Expert study guide
MOS Access Expert · Work through your exam, one topic at a time.
MO-500: Microsoft Access Expert (Office 2019) is a Microsoft Office Specialist exam that measures competency in database design principles. According to Microsoft's exam page, it covers the ability to create and maintain Access database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries, and candidates are expected to demonstrate the correct application of the principal features of Access and complete tasks independently. The MOS Access Expert study guide has 5 sections and about 1,949 words.
01Manage Databases: Compact, Split, Encrypt, and Configure Access
The Manage databases domain of the MOS Access Expert exam tests maintenance and configuration commands rather than object design: compacting and repairing, splitting, encryption, startup options, and Trust Center policy. Run it from Database Tools Compact and Repair Database .
381 words, about 2 min02Create and Modify Tables: Types, Properties, Validation, and Relationships
The Create and modify tables domain tests whether you can design a table that enforces data integrity: choosing the right data type, setting field properties, writing validation rules, and wiring relationships. Short Text defaults to 255 characters; Long Text holds memo data; Number exposes Field Size, Format, and Decimal Places; Currency avoids rounding; AutoNumber, Yes/No, Date/Time, Attachment, and Calculated are also available.
407 words, about 2 min03Create and Modify Queries: Criteria, Calculations, Totals, and Action Queries
The Create and modify queries domain covers the query design grid: joins, criteria placement, calculated fields, aggregate and crosstab queries, and the four action queries. Conditions typed in the same Criteria row are ANDed; conditions on separate rows are ORed.
385 words, about 2 min04Modify Forms in Layout View: Live Editing Without Breaking the Layout
The Modify forms in Layout view domain checks whether you know what Layout view can do - edit a bound form while seeing real data - and, just as importantly, what it cannot do. You can drag fields from the Field List onto the form, move and resize controls, switch a control group between stacked and tabular layouts, remove a layout to position controls freely, apply themes and Quick Styles, set fonts and colors, add a title or logo, insert header and footer content, and open the Group, Sort, and Total pane.
391 words, about 2 min05Modify Reports in Layout View: Grouping, Totals, and Print-Safe Formatting
The Modify reports in Layout view domain tests your ability to refine a report's structure and appearance while previewing the actual data, without opening Design view. The Group, Sort, and Total pane is the control center in Layout view.
385 words, about 2 min