Question 1

Match between columns
                        Premises: Key or key combination that will insert a blank row in a table in Design view.

Accepted Answer

The Answer of CTRL+TAB and Add Existing Fields and Form is...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Button on the CREATE tab that creates a simple form with a datasheet.

Accepted Answer

The Answer of Property Sheet and Form and INSERT and is...

Question 4

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 
A)  Form Title 
B)  Name 
C)  Title 
D)  Text Box

Question 5

To insert data into an OLE Object field, you use the ____________________ command on the OLE Object field's shortcut menu.

Accepted Answer

The answer of To insert data into an OLE Object...

Question 6

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 7

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 8

Modified Multiple Choice The portion of a picture that appears, as well as the way it appears, is determined by the size mode. The possible size modes are ____.

Accepted Answer

A)  Default 
B)  Clip 
C)  Stretch 
D)  Zoom 
A)  Default 
B)  Clip 
C)  Stretch 
D)  Zoom

Question 9

To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click ____.

Accepted Answer

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

Question 10

To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.

Accepted Answer

A)  Background 
B)  Format 
C)  Back Color 
D)  Fill/Back Color 
A)  Background 
B)  Format 
C)  Back Color 
D)  Fill/Back Color

Question 11

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 12

You can enter data in a long text field using the ____________________ dialog box.

Accepted Answer

The answer of You can enter data in a long...

Question 13

You can use the ruler to select multiple controls.

Accepted Answer

A) True 
 B)False

Question 14

If one book rep can represent many customers, the relationship between book rep and customers is called a(n) ____________________ relationship.

Accepted Answer

The answer of If one book rep can represent many...

Question 15

To create a simple form with a datasheet, select the table that is the "one" part of a one-to-many relationship in the Navigation Pane, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.

Accepted Answer

A)  Simple Form 
B)  Datasheet Form 
C)  Form Design 
D)  Form 
A)  Simple Form 
B)  Datasheet Form 
C)  Form Design 
D)  Form

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

Match between columns
                        Premises: Key or key combination that will move from the subform back to the last field in the main form.

Accepted Answer

The Answer of CTRL+SHIFT+TAB and SHIFT and CTRL+TAB and Add is...

Question 19

To create a multiple-table form based on the "many" table, tap or click the ____ button on the CREATE tab to create a form in Layout view.

Accepted Answer

A)  Multitable Form 
B)  Blank Form 
C)  Many Form 
D)  Layout Form 
A)  Multitable Form 
B)  Blank Form 
C)  Many Form 
D)  Layout Form

Question 20

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

Accepted Answer

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

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

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

To insert data into an OLE Object field, you use the ____________________ command on the OLE Object field's shortcut menu.

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 .

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?

Modified Multiple Choice The portion of a picture that appears, as well as the way it appears, is determined by the size mode. The possible size modes are ____.

To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click ____.

To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.

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

You can enter data in a long text field using the ____________________ dialog box.

You can use the ruler to select multiple controls.

If one book rep can represent many customers, the relationship between book rep and customers is called a(n) ____________________ relationship.

To create a simple form with a datasheet, select the table that is the "one" part of a one-to-many relationship in the Navigation Pane, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.

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

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

To create a multiple-table form based on the "many" table, tap or click the ____ button on the CREATE tab to create a form in Layout view.

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

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

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

To insert data into an OLE Object field, you use the ____________________ command on the OLE Object field's shortcut menu.

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 .

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?

Modified Multiple Choice The portion of a picture that appears, as well as the way it appears, is determined by the size mode. The possible size modes are ____.

To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click ____.

To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.

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

You can enter data in a long text field using the ____________________ dialog box.

You can use the ruler to select multiple controls.

If one book rep can represent many customers, the relationship between book rep and customers is called a(n) ____________________ relationship.

To create a simple form with a datasheet, select the table that is the "one" part of a one-to-many relationship in the Navigation Pane, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.

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

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

To create a multiple-table form based on the "many" table, tap or click the ____ button on the CREATE tab to create a form in Layout view.

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