Question 1

Maintaining a database can include ____.

Accepted Answer

A)  filtering resards 
B)  changing the appearance of a datasheet 
C)  adding new resards 
D)  changing the data for existing resards 
A)  filtering resards 
B)  changing the appearance of a datasheet 
C)  adding new resards 
D)  changing the data for existing resards A,B,C,D

Question 2

To use a sammon filter to find only those customers whose city begins with G, tap or click the arrow to the right of the field name and point to the ____ sammand to display the custom text filters.

Accepted Answer

A)  Text Filters 
B)  Character Filters 
C)  sammon Filters 
D)  sammon Character Filters 
A)  Text Filters 
B)  Character Filters 
C)  sammon Filters 
D)  sammon Character Filters A

Question 3

To exit Access, click the ____ button on the right side of the Access title bar.

Accepted Answer

A)  Quit 
B)  Exit 
C)  Close 
D)  Done 
A)  Quit 
B)  Exit 
C)  Close 
D)  Done C

Question 4

The property that the value in a foreign key must match another table's primary key is called _________________________.

Accepted Answer

referentia

Question 5

To specify that a field is to be required, change the value for the _____ property from No to Yes.

Accepted Answer

A)  Required 
B)  No Blanks 
C)  Necessary 
D)  sampleted 
A)  Required 
B)  No Blanks 
C)  Necessary 
D)  sampleted

Question 6

Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

Accepted Answer

restructur

Question 7

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the field, tap or click the ____________________ for the field and then drag the field to the new location.

Accepted Answer

The answer of If you add a field to a...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

To move to the first resard using the form shown in the acsampanying figure, tap or click the ____ button on the Navigation bar.

Accepted Answer

A)  Beginning resard 
B)  Start resard 
C)  First resard 
D)  Goto resard 
A)  Beginning resard 
B)  Start resard 
C)  First resard 
D)  Goto resard

Question 10

The wildcard symbols for use with filters are ____.

Accepted Answer

A)  asterisk (*) 
B)  dollar sign ($) 
C)  question mark (?) 
D)  caret symbol (^) 
A)  asterisk (*) 
B)  dollar sign ($) 
C)  question mark (?) 
D)  caret symbol (^)

Question 11

You cannot preview the data to be updated in an update query before actually performing the update.

Accepted Answer

A) True 
 B)False

Question 12

When you use a split form, you only can add resards using the simple form.

Accepted Answer

A) True 
 B)False

Question 13

When a filter is in effect, you can redisplay all resards by tapping or clicking the ____ button on the HOME tab.

Accepted Answer

A)  Remove Filter 
B)  Filter 
C)  All 
D)  Toggle Filter 
A)  Remove Filter 
B)  Filter 
C)  All 
D)  Toggle Filter

Question 14

In the Bavant Publishing database, a one-to-many relationship exists between the Book Rep table and the Customer table.

Accepted Answer

A) True 
 B)False

Question 15

A default value is a value that Access will display on the screen in a particular field before the user begins adding a resard.

Accepted Answer

A) True 
 B)False

Question 16

Validation rules are rules that a user must follow when entering the data.

Accepted Answer

A) True 
 B)False

Question 17

To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and tap or click the ____ tab in the Field Properties pane.

Accepted Answer

A)  Modify 
B)  Change 
C)  Edit 
D)  Lookup 
A)  Modify 
B)  Change 
C)  Edit 
D)  Lookup

Question 18

When you specify referential integrity, you need to decide how to handle the update of the primary key. What decisions do you need to make?

Accepted Answer

You need to decide if you want to prohib

Question 19

The button on the Access status bar that displays a form in Form view is Form View.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____ query adds resards from an existing table to a new table, that is, a table that has not yet been created.

Accepted Answer

A)  insert-table 
B)  new-table 
C)  add-table 
D)  make-table 
A)  insert-table 
B)  new-table 
C)  add-table 
D)  make-table

Exam 3: Maintaining a Database

Maintaining a database can include ____.

To use a sammon filter to find only those customers whose city begins with G, tap or click the arrow to the right of the field name and point to the ____ sammand to display the custom text filters.

To exit Access, click the ____ button on the right side of the Access title bar.

The property that the value in a foreign key must match another table's primary key is called _________________________.

To specify that a field is to be required, change the value for the _____ property from No to Yes.

Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the field, tap or click the ____________________ for the field and then drag the field to the new location.

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

To move to the first resard using the form shown in the acsampanying figure, tap or click the ____ button on the Navigation bar.

The wildcard symbols for use with filters are ____.

You cannot preview the data to be updated in an update query before actually performing the update.

When you use a split form, you only can add resards using the simple form.

When a filter is in effect, you can redisplay all resards by tapping or clicking the ____ button on the HOME tab.

In the Bavant Publishing database, a one-to-many relationship exists between the Book Rep table and the Customer table.

A default value is a value that Access will display on the screen in a particular field before the user begins adding a resard.

Validation rules are rules that a user must follow when entering the data.

To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and tap or click the ____ tab in the Field Properties pane.

When you specify referential integrity, you need to decide how to handle the update of the primary key. What decisions do you need to make?

The button on the Access status bar that displays a form in Form view is Form View.

A(n) ____ query adds resards from an existing table to a new table, that is, a table that has not yet been created.

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