Exam 1: Access 2019

The Patients table and the Visits table have a one-to-many relationship, with the Patients table being the parent table. Which of the following would you use the Find Unmatched Records Wizard to find?

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?

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

How can you highlight report records that include values greater than $500 in the OrderAmt field?

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

To close a query from SQL view, you can _____.

Which of the following tasks is a good candidate for a macro?

Tables contain and execute class modules.

Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?

As you write a VBA statement, visual aids that are part of _____ help you complete it.

A line chart uses horizontal bars to compare values, such as annual sales for a company's sales representatives.

Conditional formatting can change the appearance of a report control based on criteria you specify.

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

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

To close a macro, you click the Run button.

To run macro actions based on the result of a conditional expression, you could add an If program flow to the macro.

A(n) _____ file contains field values separated by a common character such as a comma or tab.

To close a form in Form Design view and keep Access running, you _____.

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

When you add a field with an Attachment data type to a form, it appears as a(n) Photo control.