Exam 8: Access

A parameter query displays a dialog box that prompts you for field criteria.

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

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

Compacting a database rearranges the data and objects in a database to decrease its file size.

To view a list of the database objects that depend on the selected object, open the Object Dependencies pane.

_____ are properties of an action that provide additional information on how the action should execute.

You can manage default startup options using features in the _____ category of the Access Options dialog box.

For a Comments field that contains many words, set a Long data type.

Which of the following options are available as you filter a datasheet? Select all the options that apply.

What Field Size should you set for a State field that stores two-character state abbreviations?

When you use the Find Unmatched Query Wizard, what information must you provide to the wizard? Select all the options that apply.

Which control works best to display three choices-1, 2, or 3-for a Rating field?

Which of the following are advantages of using Microsoft Access to manage data? Select all the options that apply.

In Form Layout view, you can edit the text in a _____ without changing any data.

To display the Visual Basic window, you click the Create tab on the ribbon, and then click Visual Basic.

What Access tool helps you import a CSV file as a new Access table?

When you click the first value in a column in Report Layout view, what are you actually selecting?

What must you use to create a custom function in Access?

Before closing a form in Form view, you must save changes you made to the data.

If you move a text box in Form Design view, you _____.