Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Modified Multiple Choice A field with the Attachment data type can contain ____.

Accepted Answer

A)  Word documents 
B)  Excel spreadsheets 
C)  Pictures 
D)  Boolean operators 
A)  Word documents 
B)  Excel spreadsheets 
C)  Pictures 
D)  Boolean operators

Question 6

To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

Accepted Answer

A)  Property Sheet 
B)  Special Effect 
C)  Properties 
D)  Labels 
A)  Property Sheet 
B)  Special Effect 
C)  Properties 
D)  Labels

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

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 9

To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.

Accepted Answer

A)  Picture 
B)  Size Mode 
C)  Cropping 
D)  Alignment 
A)  Picture 
B)  Size Mode 
C)  Cropping 
D)  Alignment

Question 10

To view a picture in Datasheet view, press and hold or right-click the picture field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click View .

Accepted Answer

A) True 
 B)False

Question 11

You cannot change the size of the property sheet.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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 14

Rows in a datasheet may be different sizes.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

Accepted Answer

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

Question 18

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 Form and SHIFT and TAB and Form is...

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

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

Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

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

Modified Multiple Choice A field with the Attachment data type can contain ____.

To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

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

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.

To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.

To view a picture in Datasheet view, press and hold or right-click the picture field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click View .

You cannot change the size of the property sheet.

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

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

Rows in a datasheet may be different sizes.

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

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

To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

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

Access: Creating Reports and Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters

Exam 2: Access: Multiple-Table Forms

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

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

Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

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

Modified Multiple Choice A field with the Attachment data type can contain ____.

To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

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

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.

To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.

To view a picture in Datasheet view, press and hold or right-click the picture field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click View .

You cannot change the size of the property sheet.

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

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

Rows in a datasheet may be different sizes.

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

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

To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

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

Access: Creating Reports and Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters