MOS Access Expert case studies
MOS Access Expert · Put your knowledge to work in context.
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 case studies are 5 cases and about 4,026 words.
1Split database slows to a crawl and loses backups
A 12-person operations team runs a split Access database. The front end was copied to C: .accdb on every workstation; the back end sits at \ 01 Data.accdb.
792 words, about 4 min2Nightly import keeps loading bad enrollment rows
Each night a CSV of course enrollments is appended to tblEnrollments in a training database. The table currently has EnrollmentID (AutoNumber, primary key), StudentEmail (Short Text, 255), CourseCode (Short Text, 10), StartDate (Short Text), Fee (Number, Double) and CompletionPct (Number, Double).
798 words, about 4 min3Crosstab, unmatched and parameter queries for a quarterly review
A regional distributor keeps tblCustomers, tblOrders (OrderID, CustomerID, OrderDate, EmployeeID), tblOrderDetails (OrderID, ProductID, Quantity, UnitPrice, Discount) and tblProducts (ProductID, CategoryID, CategoryName). Finance wants four outputs for the quarterly review.
775 words, about 4 min4Layout-view changes on the client intake form
The intake form frmClient is bound to tblClients and opens in Form view. The department has asked for a quick round of changes and wants you to stay in Layout view because Design view, in their words, breaks the layout.
817 words, about 4 min5Invoice report prints wrong totals and takes 40 seconds
rptInvoices groups by customer and prints a statement: a customer group header, the detail rows, and a customer subtotal. The page footer contains a text box with =Sum([Amount]) and a 'Page x of y' label.
844 words, about 4 min