Exam 1: Access-2019

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

In a datasheet, what do you click to select a record for deletion?

In Form Layout view of a navigation form, you can double-click the navigation button to _____.

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

You can assign most but not all data types to a field in Table Datasheet view.

The Import Spreadsheet Wizard helps you import Excel data into Access.

A database in a trusted folder enables all database content, including all macros and VBA.

You can use a function created in a standard module in any query in the database.

How can you identify a linked table in a database?

Besides reducing file size, what other benefit does compacting an Access database provide?

In SQL view, a select query starts with the SQL keyword _____.

In Report Layout view, you use the Format Painter to change the theme of a report.

If a combo box has two columns of 1.5" each, what should you set as the List Width property to display all of the data in the list?

As you create a report, when might you want to work in Report Layout view?

You modify the Default View property to change the form layout.

In _____ view, you can make some design changes to a report while you are displaying the data.

Before you close a database, you must save any changes you made to the data.

Which of the following form controls works as a text box that provides a list of possible values for a field?

A delimited text file such as a CSV file stores one _____ on each line.

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.