Exam 12: Developing an Excel Application

Where do you set the Allow Multiple Values property of a field in Table Design view?

After you split a database,what does the back-end database contain?

Where do you paste a copied query?

How do you start the Performance Analyzer?

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

Which of the following criteria selects records for customers except those who live in New York,even if the City field is blank?

You use an action query's the Invisible property to hide the query in the Navigation Pane.

Which of the following is a startup command-line option?

To keep the Navigation Pane hidden in the Access window,you set a(n)_____ option.

You can copy and paste any object in Access except for tables.

Which Short Text field property should you use to indicate users must enter a value in the field?

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

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

Because it can be dangerous to leave action queries in the Navigation Pane,you can _____ an action query you want to run again.

Use the _____ Table Manager to manage a split database.

When you split an Access database,what do you call the database containing all the tables?

You can set a startup option to show or hide the Navigation Pane itself.

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

What happens when you run a query with the Is Null criterion in the Product Type field?

One reason to split a database is to improve performance.