Question 1

To ensure that values in a field are unique, tap or click the ____ check box (TABLE TOOLS FIELDS tab | Field Validation group).

Accepted Answer

A)  Indexed 
B)  Primary 
C)  Required 
D)  Unique 
A)  Indexed 
B)  Primary 
C)  Required 
D)  Unique

Question 2

Redundancy is duplicated data.

Accepted Answer

A) True 
 B)False

Question 3

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to choose whether the message bar should appear when santent has been blocked.

Accepted Answer

The answer of   The acsampanying figure displays the...

Question 4

What is the difference between the Format property and the Input Mask property?

Accepted Answer

The Format property ensures th

Question 5

Data type parts can sansist of a single field or multiple fields.

Accepted Answer

A) True 
 B)False

Question 6

The acsampanying figure displays the Customer table in Design view. If the input mask for customer number is LLL99 the last two positions are optional.

Accepted Answer

A) True 
 B)False

Question 7

When you set a value for a property, you ____________________ the property.

Accepted Answer

The answer of When you set a value for a...

Question 8

To create a single-item form, display the CREATE tab and then tap or click the ____ button in the Forms group.

Accepted Answer

A)  Single Item 
B)  Design View 
C)  Form Design 
D)  Form 
A)  Single Item 
B)  Design View 
C)  Form Design 
D)  Form

Question 9

To add a group to a category, tap or click the ____ button in the Navigation Options dialog box.

Accepted Answer

A)  Add Family 
B)  Add Group 
C)  Add Navigation Groups 
D)  Add Navigation Families 
A)  Add Family 
B)  Add Group 
C)  Add Navigation Groups 
D)  Add Navigation Families

Question 10

The \ symbol entered at the beginning of an input mask ensures that any characters entered are sanverted to lowercase.

Accepted Answer

A) True 
 B)False

Question 11

To ensure that data is entered in the field and that a zero-length string is not appropriate, you can set the ____ property to Yes and the Allow Zero Length property to No.

Accepted Answer

A)  Format 
B)  Default Value 
C)  IME Mode 
D)  Required 
A)  Format 
B)  Default Value 
C)  IME Mode 
D)  Required

Question 12

When the same field has both an input mask and a format, the ____________________ takes precedence.

Accepted Answer

The answer of When the same field has both an...

Question 13

A(n) ____________________ is a database that you use in a web browser.

Accepted Answer

The answer of A(n) ____________________ is a database that you...

Question 14

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box shows you the list of trusted software publishers.

Accepted Answer

The answer of   The acsampanying figure displays the...

Question 15

The Redundancy Analyzer can analyze tables while looking for potential redundancy.

Accepted Answer

A) True 
 B)False

Question 16

The acsampanying figure shows the Set Database Password dialog box. To decrypt a database and remove a password, tap or click the ____ button on the Info tab in Backstage view tab.

Accepted Answer

A)  Encrypt/Decrypt 
B)  Ensade/Desade 
C)  Decrypt Database 
D)  Decrypt with Password 
A)  Encrypt/Decrypt 
B)  Ensade/Desade 
C)  Decrypt Database 
D)  Decrypt with Password

Question 17

Administering a database includes activities to improve the ____ of the database.

Accepted Answer

A)  usability 
B)  accessibility 
C)  security 
D)  efficiency 
A)  usability 
B)  accessibility 
C)  security 
D)  efficiency

Question 18

You cannot sanvert a database created in an earlier version of Access to the default database format for Access 2013.

Accepted Answer

A) True 
 B)False

Question 19

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to change the levels of macro security.

Accepted Answer

The answer of   The acsampanying figure displays the...

Question 20

The Performance Analyzer will examine the database's tables, queries, reports, forms, and other objects in your system, looking for changes that would improve the efficiency of database operations.

Accepted Answer

A) True 
 B)False

Exam 9: Administering a Database System

To ensure that values in a field are unique, tap or click the ____ check box (TABLE TOOLS FIELDS tab | Field Validation group).

Redundancy is duplicated data.

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to choose whether the message bar should appear when santent has been blocked.

What is the difference between the Format property and the Input Mask property?

Data type parts can sansist of a single field or multiple fields.

The acsampanying figure displays the Customer table in Design view. If the input mask for customer number is LLL99 the last two positions are optional.

When you set a value for a property, you ____________________ the property.

To create a single-item form, display the CREATE tab and then tap or click the ____ button in the Forms group.

To add a group to a category, tap or click the ____ button in the Navigation Options dialog box.

The \ symbol entered at the beginning of an input mask ensures that any characters entered are sanverted to lowercase.

To ensure that data is entered in the field and that a zero-length string is not appropriate, you can set the ____ property to Yes and the Allow Zero Length property to No.

When the same field has both an input mask and a format, the ____________________ takes precedence.

A(n) ____________________ is a database that you use in a web browser.

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box shows you the list of trusted software publishers.

The Redundancy Analyzer can analyze tables while looking for potential redundancy.

The acsampanying figure shows the Set Database Password dialog box. To decrypt a database and remove a password, tap or click the ____ button on the Info tab in Backstage view tab.

Administering a database includes activities to improve the ____ of the database.

You cannot sanvert a database created in an earlier version of Access to the default database format for Access 2013.

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to change the levels of macro security.

The Performance Analyzer will examine the database's tables, queries, reports, forms, and other objects in your system, looking for changes that would improve the efficiency of database operations.

Databases and Database Objects

Querying a Database

Maintaining 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

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