FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Access

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 91

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following options are available to you when you start Access? Select all the options that apply.

A) Import an existing database.
B) Open an existing database.
C) Create a new blank database.
D) Create a database from a template.

Correct Answer

verified

Show Answer

Question 92

Multiple Choice

Review LaterAdd Note

Review Later

What is the first step in creating a query with a self join in Query Design View?

A) Display two field lists for the same table.
B) Add the Join Type row to the query design grid.
C) Remove all field lists from the upper pane.
D) Establish a one-to-many relationship between two tables.

Correct Answer

verified

Show Answer

Question 93

Multiple Choice

Review LaterAdd Note

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

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

A _____ allows you to work with records related to the record in the main form.

Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.

If a blank column of controls appears next to a column of fields in a control layout, you can _____ the columns to create a single column.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

Suppose you rename a field in Table Design view.What must you do before you can view the data in the table?

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

OpenReport is an Access macro _____.

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

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

If you move a text box in Form Design view, you _____.

You use the Performance Analyzer to analyze tables only.

In Form Design view, you can align controls and their contents.

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

A(n) _____ form is a special Access form that provides an easy-to-use database interface.

A(n) _____ is a template for creating a table that contains fields and specifies their data types.

The tabs in a Navigation form must match the names of the objects they contain.