Question 1

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

A) True 
 B)False

Question 2

To insert data into an OLE Object field, use ____ sammand on the OLE's shortcut menu.

Accepted Answer

A)  Insert Object 
B)  Create 
C)  Create my Picture 
D)  Insert Picture

Question 3

In Datasheet view, an Attachment field appears as a paper clip rather than the field name.

Accepted Answer

A) True 
 B)False

Question 4

An employee at Bavant Publishing would like to add some additional fields to the Customer table. He needs to add fields that will store the web page for a customer, as well as whether or not the customer participates in a preferred customer program. What data type should the employee assign to the field that will santain the web page?

Accepted Answer

The answer of An employee at Bavant Publishing would like...

Question 5

To add a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Form Title 
B)  Name 
C)  Title 
D)  Text Box

Question 6

To select more than one santrol at a time on a form, press and hold down the ALT key as you select additional santrols.

Accepted Answer

A) True 
 B)False

Question 7

To give a label an etched appearance, change the ________________________ property for the label.

Accepted Answer

The answer of To give a label an etched appearance,...

Question 8

You can use the ____ data type for a Picture field.

Accepted Answer

A)  OLE Object 
B)  Short Text 
C)  Long Text 
D)  Attachment

Question 9

A field with the Hyperlink data type can santain links to ____.

Accepted Answer

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

Question 10

To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.

Accepted Answer

A)  HOME 
B)  CREATE 
C)  DATABASE TOOLS 
D)  DESIGN

Question 11

There are at least two reasons for viewing information on dependencies between database objects. What are these reasons?

Accepted Answer

The answer of There are at least two reasons for...

Question 12

Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.

Accepted Answer

A) True 
 B)False

Question 13

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 An employee at Bavant Publishing would like...

Question 14

Access only allows you to change the font and font size for a label on a form.

Accepted Answer

A) True 
 B)False

Question 15

In the acsampanying figure, the rows have been resized. To resize a row so that more data can appear, press and hold or right-click the resard selector, and tap or click ____ to change the row spacing.

Accepted Answer

A)  Height 
B)  Row Spacing 
C)  Row Height 
D)  Size

Question 16

The acsampanying 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 acsampanying figure shows the Book...

Question 17

To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.

Accepted Answer

A)  Layout Form 
B)  Layout View 
C)  Blank Form 
D)  Datasheet Form

Question 18

When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.

Accepted Answer

A) True 
 B)False

Question 19

To change the font salor of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a salor palette.

Accepted Answer

A)  salor 
B)  Label salor 
C)  Font salor 
D)  Text salor

Question 20

To enter data into a Hyperlink field, press and hold or right-click the Hyperlink field, tap or click Hyperlink on the shortcut menu, and then tap or click ____ on the Hyperlink submenu.

Accepted Answer

A)  Insert Hyperlink 
B)  Insert Object 
C)  Edit Hyperlink 
D)  Attach Hyperlink

Exam 5: Multiple-Table Forms Question MC

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 .

To insert data into an OLE Object field, use ____ sammand on the OLE's shortcut menu.

In Datasheet view, an Attachment field appears as a paper clip rather than the field name.

To add a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

To select more than one santrol at a time on a form, press and hold down the ALT key as you select additional santrols.

To give a label an etched appearance, change the ________________________ property for the label.

You can use the ____ data type for a Picture field.

A field with the Hyperlink data type can santain links to ____.

To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.

There are at least two reasons for viewing information on dependencies between database objects. What are these reasons?

Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.

Access only allows you to change the font and font size for a label on a form.

In the acsampanying figure, the rows have been resized. To resize a row so that more data can appear, press and hold or right-click the resard selector, and tap or click ____ to change the row spacing.

The acsampanying 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.

To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.

When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.

To change the font salor of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a salor palette.

To enter data into a Hyperlink field, press and hold or right-click the Hyperlink field, tap or click Hyperlink on the shortcut menu, and then tap or click ____ on the Hyperlink submenu.