Exam 1: Access 2019

Access adds # signs around text criteria in Date/Time fields.

In Report Layout view, you can select the control containing the report title and then change the font color.

To create an Update query in Query Design view, you use the Add to row in the query design grid.

When you export an Access object such as a table or query to XML, you can include structure information to create a(n) _____ file.

A field with the Currency data type contains values such as quantities, measurements, and scores.

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

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

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

How do you enter a value in a lookup field in Table Datasheet view?

Which control would you most likely use to add a title to the Page Header section of a report in Report Design view?

Visual Basic for Applications (VBA) is only available for Microsoft Access.

Which data type works best to store dollar amounts?

What determines the tab order when you first create a form?

A Make-Table query is a type of _____.

To use data from an Access form on a webpage, you can _____.

Which of the following is NOT an example of an object dependency?

After viewing a report in Print Preview, you must return to Report Design view to close the report.

To remove retired employees from an Employee table, create a(n) _____ query.

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

You start creating a(n) _____ join in Query Design view by adding two copies of the same table to the Query window.