Exam 12: Developing an Excel Application

Which Access tool studies the structure and size of a database and recommends how to improve its speed?

If users must enter data in a LastName field, what property should you set for the field?

To query for null values, use Is Null as the criterion.

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

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

One reason to split a database is to improve performance.

_____ means to make the data in a database unreadable by other software.

To create a filter using the _____ feature, you work in a view similar to Query Design view.

Set the Database Title property of a database to change the text displayed in the title bar.

To find employee records that do not contain an entry in the Email field, use the _____ criterion in the Email field.

In Table Design view, you create a lookup list of values you enter using the _____ Lookup property of a field.

A field's Required property determines whether users must enter a value in the field.

To unhide a hidden object, right-click the Property Sheet title bar, click Navigation Options, then click the Show Hidden Objects check box.

In the Relationships window, a _____ represents each table.

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

The Performance Analyzer recommends how you can improve database performance.

Set the _____ startup option to add a custom title to the title bar instead of the database name and path.

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply.

To remove filter criteria from the Filter by Form grid, you _____.