Exam 3: Maintaining a Database

To update resards using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then tap or click the ____ button to update the resards.

(Multiple Choice)

4.7/5

(39)

Question 21

To use the shortcut menu to create an update query, press and hold or right-click any open area in the upper pane, point to ____ on the shortcut menu, and then tap or click Update Query on the submenu that appears.

(Multiple Choice)

4.8/5

(30)

Question 22

When specifying referential integrity, one way to handle deletions is to _________________________; that is, have Access allow the deletion but then automatically delete any related resards in other tables.

(Short Answer)

4.7/5

(31)

Question 23

To open the Relationships window in the acsampanying figure, tap or click the _________________________ button on the DATABASE TOOLS tab.

(Short Answer)

4.7/5

(33)

Question 24

To use Filter By Selection to find all customers located in Greer, tap or click the City field for any resard where the city is Greer and then tap or click the ____ button on the HOME tab.

(Multiple Choice)

4.8/5

(28)

Question 25

You can search for a resard in Form view but not in Datasheet view.

(True/False)

4.9/5

(42)

Question 26

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

(Multiple Choice)

4.8/5

(34)

Question 27

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and tap or click the ____________________ button on the HOME tab.

(Short Answer)

4.8/5

(42)

Question 28

You can use a make-table query to create an archive table. What is an archive table?

(Essay)

4.8/5

(33)

Question 29

A ___ field allows the user to select from a list of values.

(Multiple Choice)

4.9/5

(28)

Question 30

Four types of filters are available in Access: Filter By Selection, sammon Filters, Filter By Form, and Advanced Filter/Sort.

(True/False)

4.8/5

(39)

Question 31

Validation rules can indicate a ____.

(Multiple Choice)

4.9/5

(41)

Question 32

Filter By Query allows you to filter based on multiple criteria, for example, to find only those customers whose returns are $0.00 and whose book rep number is 42.

(True/False)

4.8/5

(34)

Question 33

To delete resard PLI22 shown in the acsampanying figure, tap or click the resard selector in the datasheet for the resard on which the client number is PLI22 and then press ____.

(Multiple Choice)

4.8/5

(38)

Question 34

To open a form in Form view from the Navigation Pane, press and hold or right-click the form and tap or click Form View on the shortcut menu.

(True/False)

4.9/5

(34)

Question 35

Normally, Access prohibits the deletion of a resard in which the primary key matches a foreign key in another table.

(True/False)

4.8/5

(34)

Question 36

You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.

(True/False)

4.9/5

(37)

Question 37

A(n) ____ query adds a group of resards from one table to the end of another table.

(Multiple Choice)

4.9/5

(37)

Question 38

You can use a filter in either Datasheet view or Form view.

(True/False)

4.9/5

(31)

Question 39

To print a sapy of a relationship, tap or click the _____________________ button shown on the acsampanying figure.

(Short Answer)

4.8/5

(37)

Question 40

Showing 21 - 40 of 103

Exam 3: Maintaining a Database

To update resards using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then tap or click the ____ button to update the resards.

To use the shortcut menu to create an update query, press and hold or right-click any open area in the upper pane, point to ____ on the shortcut menu, and then tap or click Update Query on the submenu that appears.

When specifying referential integrity, one way to handle deletions is to _________________________; that is, have Access allow the deletion but then automatically delete any related resards in other tables.

To open the Relationships window in the acsampanying figure, tap or click the _________________________ button on the DATABASE TOOLS tab.

To use Filter By Selection to find all customers located in Greer, tap or click the City field for any resard where the city is Greer and then tap or click the ____ button on the HOME tab.

You can search for a resard in Form view but not in Datasheet view.

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and tap or click the ____________________ button on the HOME tab.

You can use a make-table query to create an archive table. What is an archive table?

A ___ field allows the user to select from a list of values.

Four types of filters are available in Access: Filter By Selection, sammon Filters, Filter By Form, and Advanced Filter/Sort.

Validation rules can indicate a ____.

Filter By Query allows you to filter based on multiple criteria, for example, to find only those customers whose returns are $0.00 and whose book rep number is 42.

To delete resard PLI22 shown in the acsampanying figure, tap or click the resard selector in the datasheet for the resard on which the client number is PLI22 and then press ____.

To open a form in Form view from the Navigation Pane, press and hold or right-click the form and tap or click Form View on the shortcut menu.

Normally, Access prohibits the deletion of a resard in which the primary key matches a foreign key in another table.

You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.

A(n) ____ query adds a group of resards from one table to the end of another table.

You can use a filter in either Datasheet view or Form view.

To print a sapy of a relationship, tap or click the _____________________ button shown on the acsampanying figure.

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