Question 1

To add a Form Header section to a form, right-click anywhere on the form background and click _____ on the shortcut menu.

Accepted Answer

A)  Add Section 
B)  Form Header/Footer 
C)  Insert Header 
D)  Arrange 
A)  Add Section 
B)  Form Header/Footer 
C)  Insert Header 
D)  Arrange

Question 2

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

Accepted Answer

The answer of A(n) ____________________ is a form that is...

Question 3

Match between columns
                        Premises: Key or key combination that will move from the last field in the subform to the first field in the next record's main form.

Accepted Answer

The Answer of INSERT and Add Existing Fields and SHIFT is...

Question 4

Figure 5-3 In the accompanying figure, the Comment field has been resized. You can change the size of a column by using the ___________________ which is the bar containing the field name.

Accepted Answer

The answer of   
 Figure 5-3 In the...

Question 5

To add a title to a form, click the ____________________ button on the Design tab.

Accepted Answer

The answer of To add a title to a form,...

Question 6

Match between columns
                        Premises: Button on the Create tab that creates a new form in Design view.

Accepted Answer

The Answer of Form Design and Add Existing Fields and is...

Question 7

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

Accepted Answer

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

Question 8

To display an attachment, right-click the Attachments field, and click the _____ command on the shortcut menu.

Accepted Answer

A)  Open Attachments 
B)  Manage Attachments 
C)  Display Attachments 
D)  Edit Attachments 
A)  Open Attachments 
B)  Manage Attachments 
C)  Display Attachments 
D)  Edit Attachments

Question 9

A form that contains a subform includes navigation buttons for both the form and subform.

Accepted Answer

A) True 
 B)False

Question 10

What would the employee enter in the Criteria row for the Comment field to find all business analysts who have database experience ?

Accepted Answer

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

Question 11

Modified Multiple Choice A Yes/No data type is appropriate if the only possible values are _____.

Accepted Answer

A)  Yes or No 
B)  True or False 
C)  Right or Left 
D)  On or Off 
A)  Yes or No 
B)  True or False 
C)  Right or Left 
D)  On or Off

Question 12

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 13

To view object dependencies, click the object of interest in the Navigation Pane, click the _____ tab on the Ribbon, and then click the Object Dependencies button.

Accepted Answer

A)  Home 
B)  Create 
C)  Database Tools 
D)  Design 
A)  Home 
B)  Create 
C)  Database Tools 
D)  Design

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), right-click the field, click _____, click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

Accepted Answer

A)  Object 
B)  Picture Object 
C)  Convert Object 
D)  Bitmap Image Object 
A)  Object 
B)  Picture Object 
C)  Convert Object 
D)  Bitmap Image Object

Question 16

Changing the value of the Tab Order property for a control to No will bypass the control when the TAB key is pressed.

Accepted Answer

A) True 
 B)False

Question 17

When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

Accepted Answer

A) True 
 B)False

Question 18

Figure 5-3 The accompanying figure shows the Business Analyst 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   
 Figure 5-3 The accompanying...

Question 19

When you enter data in a memo field, Access automatically expands the row and column to display all the data in the field.

Accepted Answer

A) True 
 B)False

Question 20

To view data, such as a picture, in an OLE field, right-click the field, click ____________________ on the shortcut menu, and then click Open.

Accepted Answer

The answer of To view data, such as a picture,...

To add a Form Header section to a form, right-click anywhere on the form background and click _____ on the shortcut menu.

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

Figure 5-3 In the accompanying figure, the Comment field has been resized. You can change the size of a column by using the ___________________ which is the bar containing the field name.

To add a title to a form, click the ____________________ button on the Design tab.

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

To display an attachment, right-click the Attachments field, and click the _____ command on the shortcut menu.

A form that contains a subform includes navigation buttons for both the form and subform.

What would the employee enter in the Criteria row for the Comment field to find all business analysts who have database experience ?

Modified Multiple Choice A Yes/No data type is appropriate if the only possible values are _____.

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

To view object dependencies, click the object of interest in the Navigation Pane, click the _____ tab on the Ribbon, and then click the Object Dependencies button.

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

To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), right-click the field, click _____, click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

Changing the value of the Tab Order property for a control to No will bypass the control when the TAB key is pressed.

When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

Figure 5-3 The accompanying figure shows the Business Analyst 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 enter data in a memo field, Access automatically expands the row and column to display all the data in the field.

To view data, such as a picture, in an OLE field, right-click the field, click ____________________ on the shortcut menu, and then click Open.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters

Exam 6: Multitable Forms

To add a Form Header section to a form, right-click anywhere on the form background and click _____ on the shortcut menu.

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

Figure 5-3 In the accompanying figure, the Comment field has been resized. You can change the size of a column by using the ___________________ which is the bar containing the field name.

To add a title to a form, click the ____________________ button on the Design tab.

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

To display an attachment, right-click the Attachments field, and click the _____ command on the shortcut menu.

A form that contains a subform includes navigation buttons for both the form and subform.

What would the employee enter in the Criteria row for the Comment field to find all business analysts who have database experience ?

Modified Multiple Choice A Yes/No data type is appropriate if the only possible values are _____.

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

To view object dependencies, click the object of interest in the Navigation Pane, click the _____ tab on the Ribbon, and then click the Object Dependencies button.

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

To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), right-click the field, click _____, click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

Changing the value of the Tab Order property for a control to No will bypass the control when the TAB key is pressed.

When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

Figure 5-3 The accompanying figure shows the Business Analyst 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 enter data in a memo field, Access automatically expands the row and column to display all the data in the field.

To view data, such as a picture, in an OLE field, right-click the field, click ____________________ on the shortcut menu, and then click Open.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters