Question 1

When a form includes a subform, the subform is a separate object in the database.

Accepted Answer

A) True 
 B)False

Question 2

To display a field list in Design view, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

Accepted Answer

A)  Show Table 
B)  Display Fields 
C)  Field List 
D)  Add Existing Fields 
A)  Show Table 
B)  Display Fields 
C)  Field List 
D)  Add Existing Fields

Question 3

To insert data into a Hyperlink field, use the ____________________ command on the Hyperlink field's shortcut menu.

Accepted Answer

The answer of To insert data into a Hyperlink field,...

Question 4

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

1.Clip - Displays only the portion of th

Question 5

Match between columns
                        Premises: Button on the DATABASE TOOLS tab that will display dependencies between database objects.

Accepted Answer

The Answer of Property Sheet and INSERT and Add Existing is...

Question 6

The ____ data type can store up to a gigabyte of text.

Accepted Answer

A)  Variable 
B)  Attachment 
C)  VarChar 
D)  Long Text 
A)  Variable 
B)  Attachment 
C)  VarChar 
D)  Long Text

Question 7

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

Question 8

When you add an input mask to a field, the data type for the field changes to Input Mask.

Accepted Answer

A) True 
 B)False

Question 9

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 
A)  Wizard 
B)  Build 
C)  Input Mask 
D)  Expression

Question 10

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 
A)  Insert Hyperlink 
B)  Insert Object 
C)  Edit Hyperlink 
D)  Attach Hyperlink

Question 11

To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.

Accepted Answer

A)  View 
B)  Form 
C)  Mode 
D)  Open 
A)  View 
B)  Form 
C)  Mode 
D)  Open

Question 12

To create a form in Design view, select the table for the form, tap or click CREATE on the ribbon, and then tap or click ____ on the CREATE tab.

Accepted Answer

A)  Design View 
B)  Form Design 
C)  Blank Form 
D)  New Form 
A)  Design View 
B)  Form Design 
C)  Blank Form 
D)  New Form

Question 13

To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment buttons on the ALIGN tab.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

1.Viewing a list of objects that use a s

Question 15

A form that is contained within another form is called a(n) ____.

Accepted Answer

A)  subform 
B)  inner form 
C)  dependent form 
D)  hyperform 
A)  subform 
B)  inner form 
C)  dependent form 
D)  hyperform

Question 16

To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys.

Accepted Answer

A) True 
 B)False

Question 17

What is the difference between the Tab Stop property and Tab Order?

Accepted Answer

The Tab Stop property determines whether

Question 18

To modify the design of a table, press and hold or right-click the table in the Navigation Pane, and click ____ on the shortcut menu.

Accepted Answer

A)  Modify Table 
B)  Change Table 
C)  Design View 
D)  Modify View 
A)  Modify Table 
B)  Change Table 
C)  Design View 
D)  Modify View

Question 19

You can use the OLE Object data type or the Attachment data type to store a picture.

Accepted Answer

A) True 
 B)False

Question 20

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 
A)  web pages 
B)  Office documents 
C)  email addresses 
D)  fields in a table

When a form includes a subform, the subform is a separate object in the database.

To display a field list in Design view, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

To insert data into a Hyperlink field, use the ____________________ command on the Hyperlink field's shortcut menu.

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?

The ____ data type can store up to a gigabyte of text.

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.

When you add an input mask to a field, the data type for the field changes to Input Mask.

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

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.

To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.

To create a form in Design view, select the table for the form, tap or click CREATE on the ribbon, and then tap or click ____ on the CREATE tab.

To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment buttons on the ALIGN tab.

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

A form that is contained within another form is called a(n) ____.

To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys.

What is the difference between the Tab Stop property and Tab Order?

To modify the design of a table, press and hold or right-click the table in the Navigation Pane, and click ____ on the shortcut menu.

You can use the OLE Object data type or the Attachment data type to store a picture.

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

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Advanced Report Techniques

Filters

Exam 7: Multiple-Table Forms

When a form includes a subform, the subform is a separate object in the database.

To display a field list in Design view, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

To insert data into a Hyperlink field, use the ____________________ command on the Hyperlink field's shortcut menu.

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?

The ____ data type can store up to a gigabyte of text.

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.

When you add an input mask to a field, the data type for the field changes to Input Mask.

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

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.

To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.

To create a form in Design view, select the table for the form, tap or click CREATE on the ribbon, and then tap or click ____ on the CREATE tab.

To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment buttons on the ALIGN tab.

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

A form that is contained within another form is called a(n) ____.

To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys.

What is the difference between the Tab Stop property and Tab Order?

To modify the design of a table, press and hold or right-click the table in the Navigation Pane, and click ____ on the shortcut menu.

You can use the OLE Object data type or the Attachment data type to store a picture.

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

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Advanced Report Techniques

Filters