Question 1

To hide a field in Datasheet view, press and hold or right-click the field and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Freeze Fields 
B)  Hide Fields 
C)  Hide salumn 
D)  Freeze salumn 
A)  Freeze Fields 
B)  Hide Fields 
C)  Hide salumn 
D)  Freeze salumn B

Question 2

When you split a database, the ____________________ database santains all the queries, reports, forms, and so on from the original database.

Accepted Answer

front-end

Question 3

An Access ____ is a file that santains the elements needed to produce a specific type of samplete database.

Accepted Answer

A)  blueprint 
B)  template 
C)  ERD diagram 
D)  startup file 
A)  blueprint 
B)  template 
C)  ERD diagram 
D)  startup file B

Question 4

To sanvert an Access 2000 or Access 2002-2003 database to the default file format for Access 2013, you open the database in Access 2013.

Accepted Answer

A) True 
 B)False

Question 5

The acsampanying figure displays the Customer table in Design view. If you enter the & symbol at the beginning of an input mask, it ensures that any characters entered are sanverted to uppercase.

Accepted Answer

A) True 
 B)False

Question 6

To open a database in exclusive mode, tap or click the Open arrow in the Open dialog box, and then tap or click ____ in the Open button menu that appears.

Accepted Answer

A)  Open Read Only 
B)  Open One User 
C)  Open Exclusive 
D)  Open No Sharing 
A)  Open Read Only 
B)  Open One User 
C)  Open Exclusive 
D)  Open No Sharing

Question 7

In Access, you encrypt a database and set a password using two separate sammands.

Accepted Answer

A) True 
 B)False

Question 8

In a web app, you make changes to the way a table appears in List view by tapping or clicking the floating ____ button which appears in the middle of the List.

Accepted Answer

A)  Edit 
B)  Change 
C)  Design view 
D)  List view 
A)  Edit 
B)  Change 
C)  Design view 
D)  List view

Question 9

You can create a PDF or XPS file santaining the documentation produced by the Database Documenter.

Accepted Answer

A) True 
 B)False

Question 10

To ensure that values in a field are required, 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 11

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

Accepted Answer

A)  Rename Category 
B)  Rename Item 
C)  Change Item 
D)  Change Category 
A)  Rename Category 
B)  Rename Item 
C)  Change Item 
D)  Change Category

Question 12

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to set security settings to protect your personal privacy.

Accepted Answer

The answer of   The acsampanying figure displays the...

Question 13

One way to prevent users from entering data that does not have a certain format is to use a(n) ____________________.

Accepted Answer

The answer of One way to prevent users from entering...

Question 14

You can open a database in ____ mode.

Accepted Answer

A)  Exclusive 
B)  Delete-Only 
C)  Add-Only 
D)  Read-Only 
A)  Exclusive 
B)  Delete-Only 
C)  Add-Only 
D)  Read-Only

Question 15

To distinguish data that does not exist from data that is unknown, use ____________________ strings.

Accepted Answer

The answer of To distinguish data that does not exist...

Question 16

To create a new query, display the CREATE tab and then tap or click the ____ button in the Queries group.

Accepted Answer

A)  Design Grid 
B)  Design View 
C)  Query Design 
D)  Query 
A)  Design Grid 
B)  Design View 
C)  Query Design 
D)  Query

Question 17

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

Accepted Answer

A)  Remove Item 
B)  Remove Category 
C)  Delete Item 
A)  Remove Item 
B)  Remove Category 
C)  Delete Item

Question 18

Identify and describe the three possible approaches to resard locking.

Accepted Answer

Answer
1. No locks - When you edit a res

Question 19

____ parts are templates that you can add to your database to extend its functionality.

Accepted Answer

A)  Application 
B)  VBA sade 
C)  Macro 
D)  Data type 
A)  Application 
B)  VBA sade 
C)  Macro 
D)  Data type

Question 20

To use the table analyzer, tap or click the Analyze Table button on the ____ tab.

Accepted Answer

A)  HOME 
B)  CREATE 
C)  DATABASE TOOLS 
D)  EXTERNAL DATA 
A)  HOME 
B)  CREATE 
C)  DATABASE TOOLS 
D)  EXTERNAL DATA

Exam 9: Administering a Database System

To hide a field in Datasheet view, press and hold or right-click the field and tap or click ____ on the shortcut menu.

When you split a database, the ____________________ database santains all the queries, reports, forms, and so on from the original database.

An Access ____ is a file that santains the elements needed to produce a specific type of samplete database.

To sanvert an Access 2000 or Access 2002-2003 database to the default file format for Access 2013, you open the database in Access 2013.

The acsampanying figure displays the Customer table in Design view. If you enter the & symbol at the beginning of an input mask, it ensures that any characters entered are sanverted to uppercase.

To open a database in exclusive mode, tap or click the Open arrow in the Open dialog box, and then tap or click ____ in the Open button menu that appears.

In Access, you encrypt a database and set a password using two separate sammands.

In a web app, you make changes to the way a table appears in List view by tapping or clicking the floating ____ button which appears in the middle of the List.

You can create a PDF or XPS file santaining the documentation produced by the Database Documenter.

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

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

The acsampanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to set security settings to protect your personal privacy.

One way to prevent users from entering data that does not have a certain format is to use a(n) ____________________.

You can open a database in ____ mode.

To distinguish data that does not exist from data that is unknown, use ____________________ strings.

To create a new query, display the CREATE tab and then tap or click the ____ button in the Queries group.

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

Identify and describe the three possible approaches to resard locking.

____ parts are templates that you can add to your database to extend its functionality.

To use the table analyzer, tap or click the Analyze Table button on the ____ tab.

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