Question 1

To change the Tab Stop property for a control, select the control, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.

Accepted Answer

A)  Tab 
B)  Order 
C)  Arrangement 
D)  Property Sheet

Question 2

What would the employee enter in the Criteria row for the Comment field to find all book reps who understand or speak the Spanish language?

Accepted Answer

The answer of What would the employee enter in the...

Question 3

To undo changes to the row height, press and hold or right-click the row selector, click Row Height on the shortcut menu, and then tap or click the ____ check box in the Row Height dialog box.

Accepted Answer

A)  Default 
B)  Undo 
C)  Standard Height 
D)  Reverse

Question 4

The form in which the subform is contained is called the ____________________.

Accepted Answer

The answer of The form in which the subform is...

Question 5

To test for the current date in a query, type ____ in the Criteria row of the appropriate column.

Accepted Answer

A)  Current() 
B)  CurrentDate() 
C)  Today() 
D)  Date()

Question 6

To go to a specific record in the main form, enter the record number in the ____ box for the main form.

Accepted Answer

A)  Go to Record 
B)  Current Record 
C)  Next Record 
D)  Find Record

Question 7

Modified Multiple Choice A field with the Hyperlink data type can contain links to ____.

Accepted Answer

A)  web pages 
B)  Office documents 
C)  email addresses 
D)  fields in a table

Question 8

Critical Thinking Questions Case 5-2 An employee at Bavant Publishing would like to query the Book Rep table. She has created a query and entered the fields she wants to display in the result in the design grid. Now, she enters the criteria. What would the employee enter in the Criteria row of the Start Date field to find all book reps who started before January 1, 2013?

Accepted Answer

The answer of Critical Thinking Questions Case 5-2 An employee...

Question 9

To view attachments in a field, press and hold or right-click the field, and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  View Attachments 
B)  Open 
C)  Manage Attachments 
D)  View

Question 10

An input mask specifies how data is to be entered and how it will appear.

Accepted Answer

A) True 
 B)False

Question 11

To switch from Design view to Form view to display the form, tap or click the ____ button.

Accepted Answer

A)  Display 
B)  Open 
C)  Window 
D)  View

Question 12

To use the Input Mask Wizard, select the Input Mask property in the field's property sheet and then select the ____ button.

Accepted Answer

A)  Wizard 
B)  Build 
C)  Input Mask 
D)  Expression

Question 13

To change the tab order in which fields are encountered on a form, tap or click the Tab Order button on the ____ tab.

Accepted Answer

A)  HOME 
B)  FORM DESIGN TOOLS ARRANGE 
C)  CREATE 
D)  FORM DESIGN TOOLS DESIGN

Question 14

The accompanying figure shows the Book Rep table. The Phone Number field in this table uses a(n) ____________________, which specifies how data is to be entered and how it will appear.

Accepted Answer

The answer of  The accompanying figure shows the Book...

Question 15

The portion of a picture that appears as well as the way it appears is determined by the size mode. What are the three possible size modes and how do they affect a picture?

Accepted Answer

The answer of The portion of a picture that appears...

Question 16

To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____________________ on the shortcut menu.

Accepted Answer

The answer of To add a Form Header section to...

Question 17

In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, drag the lower edge of the ____ to the desired size.

Accepted Answer

A)  horizontal scroll bar 
B)  vertical scroll bar 
C)  datasheet 
D)  record selector

Question 18

If you create a form with the Form button for a table that is the "one" table in a one-to-many relationship, Access automatically includes the "many" table in a subform .

Accepted Answer