Exam 1: Access 2019

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

Which of the following views provides the most options for creating and modifying a report?

When you create an option group on a form, you enter the Option Value property for each option button.

A(n) _____ relates a record of a table to another record in the same table.

_____ connects an Access database to data in an external file, such as an Excel spreadsheet or Outlook folder, but does not copy the data into the database.

The _____ New Page property helps you start printing a section at the top of a new page.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

You can add one or more _____ to a tab control.

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

What can you do to hide the actions in a macro?

You can set the Decimal Places property for fields with a Currency data type.

What do you use to open a database in Exclusive mode?

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

When building a conditional expression that refers to a value in a form control, use the syntax called _____.

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

When you change a select query to an Update query, Access displays the _____ row in the query design grid.

One way to _____ a macro is to single step through the macro.

Use Query Design view to display the results of a query.

What criterion would you use in the LastName field to find records that do not contain a last name?

Which built-in Access function returns today's date?