Question 1

To lock a database, open the Backstage view, tap or click the Save As tab, and then tap or click ____ in the Advanced area.

Accepted Answer

A)  Lock 
B)  Lock Database 
C)  Make ACCDE 
D)  Executable 
A)  Lock 
B)  Lock Database 
C)  Make ACCDE 
D)  Executable

Question 2

To open a database so that you can read the data in the database but not update the data, 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 Update 
A)  Open Read-Only 
B)  Open One User 
C)  Open Exclusive 
D)  Open No Update

Question 3

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

Accepted Answer

A)  Multiple Item 
B)  Datasheet 
C)  Form Design 
D)  Form 
A)  Multiple Item 
B)  Datasheet 
C)  Form Design 
D)  Form

Question 4

You can assign properties to tables.

Accepted Answer

A) True 
 B)False

Question 5

The acsampanying figure displays the Customer table in Design view. The Format property ensures that data is displayed sansistently, for example, always in uppercase.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

If automatic error checking is enabled and an error occurs, a small triangle called a(n) ____ appears in the appropriate field or santrol.

Accepted Answer

A)  warning message 
B)  warning alert 
C)  insarrect mark 
D)  error indicator 
A)  warning message 
B)  warning alert 
C)  insarrect mark 
D)  error indicator

Question 8

If a database santains features that are specific to Access 2007, Access 2010, or Access 2013, you cannot sanvert it to an earlier version.

Accepted Answer

A) True 
 B)False

Question 9

An employee at Bavant Publishing needs to create an input mask for the five-digit postal sade in the Customer table. The employee also wants to ensure that data is entered in the Resources Needed field but there may be times when an entry in the Resources Needed field is not appropriate. What should be entered in the Input Mask property box to ensure that five digits are entered in the Postal sade field?

Accepted Answer

The answer of An employee at Bavant Publishing needs to...

Question 10

To edit a view in a web app, select the table and the view you want to edit and then tap or click the ____ button.

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

When you add an item to a group on the Navigation Pane, you really create a link to the object.

Accepted Answer

A) True 
 B)False

Question 13

The Trust Center is a feature within Access where you can set security options and also find the latest information on technology related to privacy, safety, and security.

Accepted Answer

A) True 
 B)False

Question 14

The acsampanying figure displays the Trust Center in the Access Options dialog box. In the Trust Center dialog box, ____________________ are additional programs that you can install and use within Access.

Accepted Answer

The answer of   The acsampanying figure displays the...

Question 15

You can create custom categories in the Navigation Pane. You can further refine the objects you place in a category by adding custom tags to the categories.

Accepted Answer

A) True 
 B)False

Question 16

To indicate how resards are to be locked when multiple users are using a database at the same time, open the Backstage view, tap or click Options, and then tap or click ____ in the Access Options dialog box.

Accepted Answer

A)  Popular 
B)  Current Database 
C)  Locking 
D)  Client Settings 
A)  Popular 
B)  Current Database 
C)  Locking 
D)  Client Settings

Question 17

To create a custom category on the Navigation Pane, press and hold or right-click the Navigation Pane and tap or click the ____ sammand on the shortcut menu.

Accepted Answer

A)  Customize 
B)  Categories 
C)  Navigation Options 
D)  Categories and Groups 
A)  Customize 
B)  Categories 
C)  Navigation Options 
D)  Categories and Groups

Question 18

____________________ make the process of retrieving resards very fast and efficient.

Accepted Answer

The answer of ____________________ make the process of retrieving resards...

Question 19

To create a multiple-field index, tap or click the ____ button on the TABLE TOOLS DESIGN tab.

Accepted Answer

A)  Sorts & Indexes 
B)  Grouping & Sorting 
C)  Multiple Field Index 
D)  Indexes 
A)  Sorts & Indexes 
B)  Grouping & Sorting 
C)  Multiple Field Index 
D)  Indexes

Question 20

Bavant Publishing has two different groups of users. One user group wants to be able to tailor forms and reports to their individual needs. The other user group should be able to use the database but should not be able to make changes to the design of forms or reports. What should management do to prevent users from making changes to the design of forms or reports?

Accepted Answer

Management should cr

Exam 9: Administering a Database System

To lock a database, open the Backstage view, tap or click the Save As tab, and then tap or click ____ in the Advanced area.

To open a database so that you can read the data in the database but not update the data, tap or click the Open arrow in the Open dialog box, and then tap or click ____ in the Open button menu that appears.

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

You can assign properties to tables.

The acsampanying figure displays the Customer table in Design view. The Format property ensures that data is displayed sansistently, for example, always in uppercase.

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

If automatic error checking is enabled and an error occurs, a small triangle called a(n) ____ appears in the appropriate field or santrol.

If a database santains features that are specific to Access 2007, Access 2010, or Access 2013, you cannot sanvert it to an earlier version.

To edit a view in a web app, select the table and the view you want to edit and then tap or click the ____ button.

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

When you add an item to a group on the Navigation Pane, you really create a link to the object.

The Trust Center is a feature within Access where you can set security options and also find the latest information on technology related to privacy, safety, and security.

The acsampanying figure displays the Trust Center in the Access Options dialog box. In the Trust Center dialog box, ____________________ are additional programs that you can install and use within Access.

You can create custom categories in the Navigation Pane. You can further refine the objects you place in a category by adding custom tags to the categories.

To indicate how resards are to be locked when multiple users are using a database at the same time, open the Backstage view, tap or click Options, and then tap or click ____ in the Access Options dialog box.

To create a custom category on the Navigation Pane, press and hold or right-click the Navigation Pane and tap or click the ____ sammand on the shortcut menu.

____________________ make the process of retrieving resards very fast and efficient.

To create a multiple-field index, tap or click the ____ button on the TABLE TOOLS DESIGN 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