Question 1

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.
A) Default
B) Undo
C) Standard Height
D) Reverse

Accepted Answer

C

Question 2

To use the Input Mask Wizard, select the Input Mask property in the field's property sheet and then select the ____ button.
A) Wizard
B) Build
C) Input Mask
D) Expression

Accepted Answer

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

Question 3

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 button on the ____ tab.
A) CREATE
B) FORM DESIGN TOOLS DESIGN
C) HOME
D) FORM DESIGN TOOLS ARRANGE

Accepted Answer

The "FORM DESIGN TOOLS ARRANGE" tab contains alignment options for arranging controls in a form design.

Question 4

To display a field list in Design view, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.
A) Show Table
B) Display Fields
C) Field List
D) Add Existing Fields

Accepted Answer

The answer of To display a field list in Design...

Question 5

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.
A) Modify Table
B) Change Table
C) Design View
D) Modify View

Accepted Answer

Clicking Design View will allow the user to modify the design of the table. The other options listed do not necessarily lead to modifying the table design.

Question 6

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) Height
B) Row Spacing
C) Row Height
D) Size

Accepted Answer

The answer of  In the accompanying figure, the rows...

Question 7

To view attachments in a field, press and hold or right-click the field, and then tap or click ____ on the shortcut menu.
A) View Attachments
B) Open
C) Manage Attachments
D) View

Accepted Answer

The correct option to access attachments in a field is to manage attachments. This option will allow you to view, add or remove attachments associated with that field. Pressing view or open may not necessarily give you the option to manage the attachments.

Question 8

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.
A) Design View
B) Form Design
C) Blank Form
D) New Form

Accepted Answer

To create a form in Design view, we need to select the Form Design option on the CREATE tab, not Design View or Blank Form. There is no option called New Form on the ribbon.

Question 9

In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, drag the right edge of the ____ to the desired size.
A) field selector
B) horizontal scroll bar
C) vertical scroll bar
D) datasheet

Accepted Answer

The answer of  In the accompanying figure, the Comment...

Question 10

To save a form and assign it a name, tap or click the Save button on the ____.
A) FORM DESIGN TOOLS DESIGN tab
B) Quick Access Toolbar
C) HOME tab
D) CREATE tab

Accepted Answer

The Save button is typically located on the Quick Access Toolbar, which is a customizable toolbar located at the top of the screen. It provides quick access to commonly used commands, such as Save. The other tab options (A, C, and D) may have different buttons and options, but they do not typically include a Save button.

Question 11

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.
A) horizontal scroll bar
B) vertical scroll bar
C) datasheet
D) record selector

Accepted Answer

The answer of  In the accompanying figure, the rows...

Question 12

To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), press and hold or right-click the field, tap or click ____, tap or click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.
A) Object
B) Picture Object
C) Convert Object
D) Bitmap Image Object

Accepted Answer

The correct option is "Bitmap Image Object" because you need to right-click the specific object type you want to convert, which in this case is a Bitmap Image Object.

Question 13

In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, press and hold or right-click the field selector, and tap or click ____ to change the column size.
A) Field Width
B) Field Size
C) Width
D) Size

Accepted Answer

The answer of  In the accompanying figure, the Comment...

Question 14

The ____ data type can store up to a gigabyte of text.
A) Variable
B) Attachment
C) VarChar
D) Long Text

Accepted Answer

The Long Text data type can store large amounts of text, up to 1 gigabyte, making it the best option for storing lengthy text fields. Variables are used to store single values, attachments are used for storing files, and VarChar has a limitation on the maximum length of text that can be stored.

Question 15

A form that is contained within another form is called a(n) ____.
A) subform
B) inner form
C) dependent form
D) hyperform

Accepted Answer

A form that is contained within another form is called a subform. It is a way to organize information and create a hierarchy of forms within a larger form structure.

Question 16

To undo changes to the column width, press and hold or right-click the field selector, tap or click Field Width on the shortcut menu, and then tap or click the ____ check box in the dialog box.
A) Default
B) Standard Width
C) Reverse
D) Undo

Accepted Answer

The answer of To undo changes to the column width,...

Question 17

To insert data into an OLE Object field, use ____ command on the OLE's shortcut menu.
A) Insert Object
B) Create
C) Create my Picture
D) Insert Picture

Accepted Answer

The "Insert Object" command is used to insert data into an OLE Object field, allowing you to embed or link objects like documents, spreadsheets, or images.

Question 18

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 ____.
A) View
B) Picture
C) Display
D) Open

Accepted Answer

The best choice is to tap or click Open, as this will allow you to view the full image outside of the OLE field. Choosing View may simply resize the image within the field, while Picture and Display are not options on the shortcut menu.

Question 19

To insert data into an Attachment field, use the ____ command on the Attachment field's shortcut menu.
A) Insert Attachments
B) Insert Objects
C) Manage Objects
D) Manage Attachments

Accepted Answer

The "Manage Attachments" command is used to insert data into an Attachment field in databases like Microsoft Access.

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

Accepted Answer

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

Quiz 7: Multiple-Table Forms

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.

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

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 button on the ____ tab.

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

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.

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.

To view attachments in a field, press and hold or right-click the field, and then tap or 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.

In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, drag the right edge of the ____ to the desired size.

To save a form and assign it a name, tap or click the Save button on the ____.

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.

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

In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, press and hold or right-click the field selector, and tap or click ____ to change the column size.

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

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

To undo changes to the column width, press and hold or right-click the field selector, tap or click Field Width on the shortcut menu, and then tap or click the ____ check box in the dialog box.

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

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 insert data into an Attachment field, use the ____ command on the Attachment field's shortcut menu.

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.