MO-500 Microsoft Access Expert Free Practice Test - 20 Questions

Question 1

You are designing a table to store customer comments that may contain up to 300 characters. Which data type should you use for the Comment field?

Accepted Answer

Short Text

Question 2

Which of the following best describes the purpose of a primary key in a Microsoft Access table?

Accepted Answer

To ensure that each record is unique and can be identified quickly

Question 3

In a database for a bookstore, you have a table 'Books' and a table 'Authors'. Each book can have multiple authors, and each author can write multiple books. What type of relationship must be implemented?

Accepted Answer

Many-to-many

Question 4

You need to create a query that shows customer orders only for customers from New York. The 'Customers' table has a 'State' field, and 'Orders' table has order details. Which type of join should you use between the two tables?

Accepted Answer

Inner join

Question 5

You design a parameter query to prompt users for a start date and an end date. The dates are stored in a field called OrderDate. Which criteria syntax correctly filters records between the two dates?

Accepted Answer

Both A and B are valid

Question 6

You need to increase the price of all products in the 'Electronics' category by 10%. Which type of query should you use?

Accepted Answer

Update query

Question 7

You want to create a crosstab query that sums sales per salesperson per quarter. The source has fields: Salesperson, SaleDate, Amount. Which field should be the row heading, column heading, and value?

Accepted Answer

Row: Salesperson, Column: Quarter, Value: Sum of Amount

Question 8

You need to find products that have been ordered more than 20 times. The 'Order Details' table has ProductID and Quantity. Which SQL statement correctly uses a subquery?

Accepted Answer

SELECT * FROM Products WHERE ProductID IN (SELECT ProductID FROM [Order Details] GROUP BY ProductID HAVING COUNT(*) > 20);

Question 9

You want a form that, when opened, shows only records from the 'Sales' table where the salesperson matches a value selected from a combo box on a different form. Which approach is best?

Accepted Answer

Use the WhereCondition parameter of the DoCmd.OpenForm method

Question 10

You have a form that should behave as a dialog, preventing interaction with other forms while it is open. Which form property should you set?

Accepted Answer

Both Modal and Popup

Question 11

You need to create a sales report grouped by region, and within each region, sorted by salesperson last name. In the report design, which is the correct order of grouping and sorting?

Accepted Answer

Both A and C are correct

Question 12

You need to calculate a discount of 15% on the Subtotal field in a report. Which expression should you use in a text box?

Accepted Answer

Both A and B are correct

Question 13

You want a macro that runs automatically when the database opens. What must the macro be named?

Accepted Answer

AutoExec

Question 14

You have written VBA code to loop through a recordset and update a field. Which of the following correctly opens a recordset based on a query named 'qryCustomers'?

Accepted Answer

Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("qryCustomers")

Question 15

You import an Excel file containing customer data. The import succeeds but many records have missing values in the 'Phone' column. What is the most likely cause?

Accepted Answer

The data type of the Phone field in Access is set to Number, so text entries were ignored

Question 16

You want to split a database so that each user has a separate front-end linked to a shared back-end. What is the primary benefit?

Accepted Answer

Easier distribution of user interface updates without affecting data

Question 17

You need to protect a database with a password. Which method should you use?

Accepted Answer

File > Info > Encrypt with Password

Question 18

You are designing a form for phone number entry. You want to automatically format input as (999) 999-9999. Which property should you set on the text box?

Accepted Answer

Input Mask property

Question 19

You have a query that runs slowly because it joins three large tables. What is the most effective way to improve performance?

Accepted Answer

Add indexes on the join fields in all tables

Question 20

You have two tables: 'Orders' and 'OrderDetails' related by OrderID. You want that when an order is deleted from 'Orders', all its detail records are also deleted. Which setting must be configured in the relationship?

Accepted Answer

Both Enforce Referential Integrity and Cascade Delete Related Records

MO-500 Microsoft Access Expert Free Practice Test - 20 Questions

The free lane is only the front row