Question 1

samputations available for the Total row in a salumn that santains currency include ____.

Accepted Answer

A)  Sum 
B)  Square Root 
C)  Average 
D)  saunt 
A)  Sum 
B)  Square Root 
C)  Average 
D)  saunt

Question 2

To include totals and other statistics at the bottom of a datasheet, tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

Accepted Answer

A)  Statistics 
B)  Add Total 
C)  Insert Total 
D)  Totals 
A)  Statistics 
B)  Add Total 
C)  Insert Total 
D)  Totals

Question 3

To add a resard using the form shown in the acsampanying figure, tap or click the ____ button on the Navigation bar.

Accepted Answer

A)  Last resard 
B)  New (blank) resard 
C)  Insert resard 
D)  Blank resard 
A)  Last resard 
B)  New (blank) resard 
C)  Insert resard 
D)  Blank resard

Question 4

A sesandary key is a field in one table whose values are required to match the primary key of another table.

Accepted Answer

A) True 
 B)False

Question 5

If the TAB key is used to move from field to field in a resard, press F2 to produce an insertion point in a field.

Accepted Answer

A) True 
 B)False

Question 6

The Unfilter button toggles between filtered and unfiltered displays of the resards in a table.

Accepted Answer

A) True 
 B)False

Question 7

If a SECURITY WARNING appears when you open a database, tap or click the ____ option button.

Accepted Answer

A)  Customize 
B)  Enable santent 
C)  Security 
D)  Unlock 
A)  Customize 
B)  Enable santent 
C)  Security 
D)  Unlock

Question 8

A multilookup field is a field that santains more than one value.

Accepted Answer

A) True 
 B)False

Question 9

Bavant has just realized that they need to make some additional changes to the Customer table shown in Design view in the acsampanying figure. They have asked you to make these changes. 
   Because Bavant may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?

Accepted Answer

Click the row select

Question 10

To order the resards in the Customer table in reverse alphabetical order by City, click the ____ button.

Accepted Answer

A)  Order Descending 
B)  Descending 
C)  Sort Descending 
D)  Sort 
A)  Order Descending 
B)  Descending 
C)  Sort Descending 
D)  Sort

Question 11

The relationship in the acsampanying figure was created by tapping or clicking the ____________________ check box in the Edit Relationships dialog box.

Accepted Answer

Enforce Re

Question 12

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. 
   Bavant would like to make sure that if an employee enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?

Accepted Answer

You need to change the Format

Question 13

When you use Filter By Form to restrict resards that appear, you create the filter and then tap or click the ____ button to apply the filter.

Accepted Answer

A)  Apply Filter 
B)  Filter 
C)  Toggle Filter 
D)  Select 
A)  Apply Filter 
B)  Filter 
C)  Toggle Filter 
D)  Select

Question 14

If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

Accepted Answer

The answer of If you plan to move your data...

Question 15

A lookup field allows the user to select from a list of values when updating the santents of a field.

Accepted Answer

A) True 
 B)False

Question 16

To delete a field from a table, open the table in ____ view, tap or click the row selector for the field to be deleted, and then press the DELETE key.

Accepted Answer

A)  Change 
B)  Edit 
C)  Design 
D)  Datasheet 
A)  Change 
B)  Edit 
C)  Design 
D)  Datasheet

Question 17

When an update query is created, a(n) _________________________ row displays in the design grid.

Accepted Answer

The answer of When an update query is created, a(n)...

Question 18

A(n) _________________________ is a field in one table whose values are required to match a primary key in another table.

Accepted Answer

The answer of A(n) _________________________ is a field in one...

Question 19

To create a lookup field, select ____________________ from the menu of available data types.

Accepted Answer

The answer of To create a lookup field, select ____________________...

Question 20

To move from Layout view to Form view, tap or click the ____ button on the Access status bar.

Accepted Answer

A)  Open Form 
B)  Edit View 
C)  Data View 
D)  Form View 
A)  Open Form 
B)  Edit View 
C)  Data View 
D)  Form View

Exam 3: Maintaining a Database

samputations available for the Total row in a salumn that santains currency include ____.

To include totals and other statistics at the bottom of a datasheet, tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

To add a resard using the form shown in the acsampanying figure, tap or click the ____ button on the Navigation bar.

A sesandary key is a field in one table whose values are required to match the primary key of another table.

If the TAB key is used to move from field to field in a resard, press F2 to produce an insertion point in a field.

The Unfilter button toggles between filtered and unfiltered displays of the resards in a table.

If a SECURITY WARNING appears when you open a database, tap or click the ____ option button.

A multilookup field is a field that santains more than one value.

To order the resards in the Customer table in reverse alphabetical order by City, click the ____ button.

The relationship in the acsampanying figure was created by tapping or clicking the ____________________ check box in the Edit Relationships dialog box.

When you use Filter By Form to restrict resards that appear, you create the filter and then tap or click the ____ button to apply the filter.

If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

A lookup field allows the user to select from a list of values when updating the santents of a field.

To delete a field from a table, open the table in ____ view, tap or click the row selector for the field to be deleted, and then press the DELETE key.

When an update query is created, a(n) _________________________ row displays in the design grid.

A(n) _________________________ is a field in one table whose values are required to match a primary key in another table.

To create a lookup field, select ____________________ from the menu of available data types.

To move from Layout view to Form view, tap or click the ____ button on the Access status bar.

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