Exam 8: Access

You use a subdatasheet to modify a field's properties.

You can display numbers on a report in Currency, Percent, or Standard formats.

To import data from Excel to Access, you would begin by clicking the ____.

Press ESC to remove editing changes you made to the previous record.

To set the Validation Text property for a table in Table Design view, you use the _____.

_____ view is a spreadsheet-like view of the data in a table.

To display the data in a table, you open the table in Table Design view.

Which of the following statements describe Query Design view? Select all the options that apply.

You can use the arrow keys to move a selected control in Report Design view.

Which of the following are ways to improve database performance? Select all the options that apply.

When you remove a control layout from a report, Access _____.

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

To select more than one control in Form Design view, you _____ and then click each control.

To run the code in the Visual Basic window, you click the Run button on the Standard toolbar.

When you split an Access database, what do you call the database stored on your computer?

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

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

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

Number fields store values that represent quantities, measurements, and scores, for example.

The programming language used in Access modules is called Visual Basic for _____.