FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Microsoft Access Basics

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 171

True/False

Review LaterAdd Note

Review Later

Basing a report on a parameter query is useful if you need to run multiple reports that display unique information.

A) True
B) False

Correct Answer

verified

Show Answer

Question 172

True/False

Review LaterAdd Note

Review Later

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

A) True
B) False

Correct Answer

verified

Show Answer

Question 173

True/False

Review LaterAdd Note

Validation text is entered in the Field Properties pane.

You assign specific functions to the parts of a control in the Control Sheet.

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

You can select all of the records in a table by clicking the ____________________, which is the box in the upper-left corner of a datasheet.

FIGURE AC 2-1 Figure AC 2-1 above, you would access this Field Properties screen in ____ view.

Typically when you open a database, you use the Open mode.

Describe the various security and documentation features Microsoft Access offers to protect a database from losing important information.

Identify the letter of the choice that best matches the phrase or definition.

To display the Query Design window, click the ____ tab and then click the Query Design button in the Queries group.

The Query window is divided into three parts. The middle part of the window contains a navigation pane that allows you to specify the fields to include in the query datasheet.

Access performs startup options when the splash screen is opened.

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. Monica wants to insert a space between the first and last name. What should she do before double-clicking the Last Name in the Available fields box?

The default setting for a mail merge is to print one record in the data source.

What does the Field Size property do? What is the default field value for Text fields, and why would you want to change it? What is the default field value for Number fields, and why would you want to change it?

The database object called query stores all the data in the database in a format called a datasheet.

Identify the letter of the choice that best matches the phrase or definition.

When a database is password protected, users cannot open the database unless they provide the correct login ID.

By selecting an option from the combo box list, instead of typing lengthy text, you ____.