Exam 12: Developing an Excel Application

_____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

You set the opening Display Form for a database using the Access Preferences dialog box.

You use the Performance Analyzer to analyze tables only.

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

_____ fields allow you to make more than one choice from a field's lookup list.

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

_____ are a series of commands that execute when the database opens.

When you add fields to a table in Table Design view, the _____ is optional.

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

To remove the Hidden property from an object, right-click the object, click _____, and uncheck the Hidden attribute check box.

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

You can _____ an Access database into a back-end database and front-end database.

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

How can you identify a linked table in a database?

The most important items in the Performance Analyzer results are the _____ and the suggestions.

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

Set the _____ Form startup option to specify which form opens when the database opens.

What property would you set for a field with a Yes/No data type that usually stores a Yes value?

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