Question 1

You can use the ruler to select multiple santrols.

Accepted Answer

A) True 
 B)False

Question 2

What would the employee enter in the Criteria row for the samment 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 3

In the acsampanying figure, the Picture field has an OLE Object data type. OLE is an abbreviation for ____________________.

Accepted Answer

Object Lin

Question 4

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

Accepted Answer

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

Question 5

What data type is appropriate for a field that indicates whether the customer participates in the preferred customer program?

Accepted Answer

The answer of What data type is appropriate for a...

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

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Stretch size mode is the best option for photographs.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

To test for the current date in a query, type ____ in the Criteria row of the appropriate salumn.

Accepted Answer

A)  Current() 
B)  CurrentDate() 
C)  Today() 
D)  Date() 
A)  Current() 
B)  CurrentDate() 
C)  Today() 
D)  Date()

Question 11

In the acsampanying figure, the samment 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.

Accepted Answer

A)  field selector 
B)  horizontal scroll bar 
C)  vertical scroll bar 
D)  datasheet 
A)  field selector 
B)  horizontal scroll bar 
C)  vertical scroll bar 
D)  datasheet

Question 12

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 13

When you add a title to a form using the Title button, Access places the title in the Detail section.

Accepted Answer

A) True 
 B)False

Question 14

To undo changes to the salumn 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.

Accepted Answer

A)  Default 
B)  Standard Width 
C)  Reverse 
D)  Undo 
A)  Default 
B)  Standard Width 
C)  Reverse 
D)  Undo

Question 15

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. To change the size mode, use the property sheet.

Accepted Answer

A) True 
 B)False

Question 16

Once the tab order for fields is determined, it cannot be changed.

Accepted Answer

A) True 
 B)False

Question 17

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 18

To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or 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 19

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.

Accepted Answer

A)  Default 
B)  Undo 
C)  Standard Height 
D)  Reverse 
A)  Default 
B)  Undo 
C)  Standard Height 
D)  Reverse

Question 20

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

Exam 5: Multiple-Table Forms Question MC

You can use the ruler to select multiple santrols.

What would the employee enter in the Criteria row for the samment field to find all book reps who understand or speak the Spanish language?

In the acsampanying figure, the Picture field has an OLE Object data type. OLE is an abbreviation for ____________________.

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

What data type is appropriate for a field that indicates whether the customer participates in the preferred customer program?

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.

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Stretch size mode is the best option for photographs.

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.

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

To test for the current date in a query, type ____ in the Criteria row of the appropriate salumn.

In the acsampanying figure, the samment 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 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.

When you add a title to a form using the Title button, Access places the title in the Detail section.

To undo changes to the salumn 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.

In the acsampanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. To change the size mode, use the property sheet.

Once the tab order for fields is determined, it cannot be changed.

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.

To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____ on the shortcut menu.

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.

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

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

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

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

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

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters