Exam 12: Developing an Excel Application

Before deleting a query,you can view its _____ to determine if any other queries,forms,or reports depend on that query.

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

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.

The Performance Analyzer recommends how you can improve database performance.

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

Number fields store values that represent quantities,measurements,and scores,for example.

What must you do before setting a password for a database?

Before you can change the Hidden property for a hidden object in the Navigation Pane,you must _____.

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

Which of the following statements accurately describe null field values? Select all the options that apply.

You can select a particular form,such as a Navigation form,to display when Access starts.

How can you identify a linked table in a database?

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

The text you specify for the Application Title property appears in the title bar instead of the database filename.

Why might you want to hide an action query in the Navigation Pane?

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

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

Which of the following are ways to help secure an Access database? Select all the options that apply.

Database passwords are case sensitive,which means that IOWA and iowa are different passwords.