Exam 17: Access: Maintaining a Database

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

(Multiple Choice)

4.8/5

(27)

Question 61

A(n)____ field is a field that can be computed from other fields.

(Multiple Choice)

4.8/5

(36)

Question 62

Identify the letter of the choice that best matches the phrase or definition. -Allows you to make the same change to all records.

(Multiple Choice)

4.9/5

(34)

Question 63

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

(Short Answer)

4.8/5

(29)

Question 64

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

(Short Answer)

4.9/5

(30)

Question 65

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

(True/False)

4.9/5

(33)

Question 66

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

(Short Answer)

4.9/5

(25)

Question 67

Validation rules ensure validity of the data in the database,while entity integrity ensures the validity of the relationships.

(True/False)

4.9/5

(35)

Question 68

To add a new record using Form view,tap or click the New (blank)record button on the Navigation bar.

(True/False)

4.9/5

(42)

Question 69

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

(True/False)

4.8/5

(41)

Question 70

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

(Multiple Choice)

4.7/5

(38)

Question 71

Identify the letter of the choice that best matches the phrase or definition. -The message that will appear if a user violates the validation rule.

(Multiple Choice)

4.9/5

(34)

Question 72

Identify the letter of the choice that best matches the phrase or definition. -A format symbol.

(Multiple Choice)

4.9/5

(31)

Question 73

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

(True/False)

5.0/5

(41)

Question 74

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

(Essay)

4.8/5

(36)

Question 75

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

(True/False)

4.9/5

(32)

Question 76

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.9/5

(30)

Question 77

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

(Short Answer)

4.9/5

(29)

Question 78

To save validation rules,default values,and formats,tap or click the Save button on the ____ to save the changes.

(Multiple Choice)

4.7/5

(37)

Question 79

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

(Short Answer)

4.9/5

(42)

Question 80

Showing 61 - 80 of 111

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

A(n)____ field is a field that can be computed from other fields.

Identify the letter of the choice that best matches the phrase or definition. -Allows you to make the same change to all records.

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

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

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

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

Validation rules ensure validity of the data in the database,while entity integrity ensures the validity of the relationships.

To add a new record using Form view,tap or click the New (blank)record button on the Navigation bar.

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

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

Identify the letter of the choice that best matches the phrase or definition. -The message that will appear if a user violates the validation rule.

Identify the letter of the choice that best matches the phrase or definition. -A format symbol.

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

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

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

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.

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

To save validation rules,default values,and formats,tap or click the Save button on the ____ to save the changes.

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

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Filters