Exam 12: Developing an Excel Application

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

A front-end database contains _____ to the tables in the back-end database.

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

What do you use to open a database in Exclusive mode?

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

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

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

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

When you type a password in the Set Database Password dialog box,_____ appear instead of the characters you typed.

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

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

To copy a table,you right-click it in _____ and then click Copy on the shortcut menu.

If users must enter text in a LastName field,you can set the _____ property for the field in Table Datasheet view.

Where can you set a field's Default Value in Table Design view?