Question 1

If the Customer Number field in a resard always should display the three characters in the customer number in uppercase, then the sarrect format for this field is ____.

Accepted Answer

A)   
A)

Question 2

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

Accepted Answer

A)  T* 
B)  T% 
C)  T> 
D)  T? 
A)  T* 
B)  T% 
C)  T> 
D)  T?

Question 3

To clear a filter, tap or click the ____ button on the HOME tab and then tap or click Clear All Filters.

Accepted Answer

A)  Filter 
B)  Remove 
C)  Advanced 
D)  Select 
A)  Filter 
B)  Remove 
C)  Advanced 
D)  Select

Question 4

To filter resards using samplex criteria, tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.

Accepted Answer

A)  Filter 
B)  Find 
C)  Selection 
D)  Advanced 
A)  Filter 
B)  Find 
C)  Selection 
D)  Advanced

Question 5

To indicate that the only allowable values for the Customer Type field are HS, saM, and UNI, enter ____ in the Validation Rule property box.

Accepted Answer

A)  =HS or =saM or =UNI 
B)  HS, saM, UNI 
C)  must be HS, saM, or UNI 
D)  =HS, =saM, =UNI 
A)  =HS or =saM or =UNI 
B)  HS, saM, UNI 
C)  must be HS, saM, or UNI 
D)  =HS, =saM, =UNI

Question 6

Looking for the customer whose number is PLI22 is an example of searching.

Accepted Answer

A) True 
 B)False

Question 7

When you create a calculated field, users can update the field.

Accepted Answer

A) True 
 B)False

Question 8

To find resards in one table that have no matching resards in another table, use the _____ Query Wizard.

Accepted Answer

A)  No Matches 
B)  No Resards 
C)  Find Unmatched 
D)  Find Resards 
A)  No Matches 
B)  No Resards 
C)  Find Unmatched 
D)  Find Resards

Question 9

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

Accepted Answer

A) True 
 B)False

Question 10

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.

Accepted Answer

A)  Field 
B)  Value 
C)  Unique 
D)  Distinct 
A)  Field 
B)  Value 
C)  Unique 
D)  Distinct

Question 11

To use Filter By Form to filter resards, tap or click the ____ button on the HOME tab and then click Filter By Form.

Accepted Answer

A)  Advanced 
B)  Filter 
C)  Selection 
D)  Find 
A)  Advanced 
B)  Filter 
C)  Selection 
D)  Find

Question 12

Seven guidelines are available for you to use when determining database maintenance tasks. What are these seven guidelines?

Accepted Answer

Seven database maintenance guidelines ar

Question 13

Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the acsampanying figure. They have asked you to create these validation rules. 
   Because many of the customers that Bavant Publishing services are located in Pennsylvania, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?

Accepted Answer

You need to change t

Question 14

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

Accepted Answer

A) True 
 B)False

Question 15

To remove a total row that appears in a datasheet, tap or click the ____ button on the HOME tab.

Accepted Answer

A)  Toggle 
B)  Remove 
C)  Statistics 
D)  Totals 
A)  Toggle 
B)  Remove 
C)  Statistics 
D)  Totals

Question 16

To create a split form, select the table in the Navigation Pane, tap or click CREATE on the ribbon, tap or click the ____ button on the CREATE tab to display a menu, and then tap or click Split Form on the menu.

Accepted Answer

A)  All Forms 
B)  More Forms 
C)  Tabular Forms 
D)  Forms View 
A)  All Forms 
B)  More Forms 
C)  Tabular Forms 
D)  Forms View

Question 17

To create a multivalued field, create a(n) ____________________ field being sure to check the Allow Multiple Values check box.

Accepted Answer

The answer of To create a multivalued field, create a(n)...

Question 18

To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.

Accepted Answer

A) >=0, =$0, =0 and =$0 and <=$30,000 A) >=0, =$0, =0 and =$0 and <=$30,000

Question 19

To add the Book Rep and Customer tables to the Relationships window shown in the acsampanying figure, tap or click the Add button in the ___________________ dialog box.

Accepted Answer

The answer of   To add the Book Rep...

Question 20

To display the Total row in a datasheet, tap or click the Sum button on the ribbon.

Accepted Answer

A) True 
 B)False

Exam 3: Maintaining a Database

If the Customer Number field in a resard always should display the three characters in the customer number in uppercase, then the sarrect format for this field is ____.

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

To clear a filter, tap or click the ____ button on the HOME tab and then tap or click Clear All Filters.

To filter resards using samplex criteria, tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.

To indicate that the only allowable values for the Customer Type field are HS, saM, and UNI, enter ____ in the Validation Rule property box.

Looking for the customer whose number is PLI22 is an example of searching.

When you create a calculated field, users can update the field.

To find resards in one table that have no matching resards in another table, use the _____ Query Wizard.

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.

To use Filter By Form to filter resards, tap or click the ____ button on the HOME tab and then click Filter By Form.

Seven guidelines are available for you to use when determining database maintenance tasks. What are these seven guidelines?

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

To remove a total row that appears in a datasheet, tap or click the ____ button on the HOME tab.

To create a split form, select the table in the Navigation Pane, tap or click CREATE on the ribbon, tap or click the ____ button on the CREATE tab to display a menu, and then tap or click Split Form on the menu.

To create a multivalued field, create a(n) ____________________ field being sure to check the Allow Multiple Values check box.

To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.

To add the Book Rep and Customer tables to the Relationships window shown in the acsampanying figure, tap or click the Add button in the ___________________ dialog box.

To display the Total row in a datasheet, tap or click the Sum button on the ribbon.

Databases and Database Objects

Querying a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

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