Exam 9: Access

Besides reducing file size, what other benefit does compacting an Access database provide?

Which of the following are ways to run a query? Select all the options that apply.

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply. ​

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

Which of the following types of tables can you create from an Application Part? Select all the options that apply.

When you convert a macro, you break it down, step by step, to observe the effect of each action. ​

Where do you specify the number of columns for a report?

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

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

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

Which of the following are examples of correct criteria syntax? Select all the options that apply.

_____ is the default name for a new table in an Access database.

Which of the following statements are true about field properties? Select all the options that apply.

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

A self join relates a record of a table to _____.

A(n) _____ is an individual step that a macro performs.

To change the background color of a form control in Form Design view, you use the _____ button.

How do you display the results of a query listed in the Navigation Pane?

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