Exam 1: Access-2019

When you copy data from an external file into an Access database, you are importing the data.

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

To set a startup form, click the File tab, and then click _____.

The purpose of a Delete query is to _____.

Each row in a table datasheet displays a _____.

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

The easiest way to filter the records for an exact match is to use the _____ feature.

Access provides a single database template for creating a blank database.

The_____ Lookup property determines whether a lookup field accepts new values or only those in the lookup list.

An advantage of emailing query results as a PDF file is that _____.

Use a Size option when you want to specify the exact height and width of two selected controls.

To change the color of the bars on a chart in a form, you must work in Form Format view.

The upper pane of _____ view shows field names and data types.

You can convert a form label to a hyperlink using the control's Web property.

You can create an Access report by selecting fields from one or more tables or _____.

Which of the following is a valid entry for the Tab Stop property of a form control?

What should you do if you want to make a copy of a database in a secure location?

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

If you often sort on a field, you should set its_____ property to Yes.

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.