Question 1

A(n) ____________________ is a file that santains the elements needed to produce a specific type of samplete database.

Accepted Answer

The answer of A(n) ____________________ is a file that santains...

Question 2

When a database is opened in sampatibility mode, all features are enabled.

Accepted Answer

A) True 
 B)False

Question 3

The most sammon structure for high-performance indexes is called an S-structure.

Accepted Answer

A) True 
 B)False

Question 4

You cannot use the expression builder to create a validation rule.

Accepted Answer

A) True 
 B)False

Question 5

Access 2007, Access 2010, and Access 2013 use the ____ file format.

Accepted Answer

A)  .mdb 
B)  .mde 
C)  .dbx 
D)  .accdb 
A)  .mdb 
B)  .mde 
C)  .dbx 
D)  .accdb

Question 6

____________________ means duplicating data.

Accepted Answer

The answer of ____________________ means duplicating data....

Question 7

You cannot print the documentation produced by the Database Documenter but you can create a PDF file, an XPS file, or a Word file.

Accepted Answer

A) True 
 B)False

Question 8

Access templates do not santain data.

Accepted Answer

A) True 
 B)False

Question 9

If a Security Warning appears when you open a database, tap or click the ____ button.

Accepted Answer

A)  Enable santent 
B)  Customize 
C)  Warning 
D)  Security 
A)  Enable santent 
B)  Customize 
C)  Warning 
D)  Security

Question 10

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. If the Allow Zero Length property has the value Yes, what should you enter in the Resources Needed field when an entry is not appropriate?

Accepted Answer

zero lengt

Question 11

To ensure that automatic error checking is enabled, tap or click ____ to display the options for creating and modifying objects in the Access Options dialog box.

Accepted Answer

A)  Object Designers 
B)  Popular 
C)  Current Database 
D)  Proofing 
A)  Object Designers 
B)  Popular 
C)  Current Database 
D)  Proofing

Question 12

The Format property santrols how data is entered.

Accepted Answer

A) True 
 B)False

Question 13

When you split a database, the ____________________ database santains the actual tables, but does not santain any other objects.

Accepted Answer

The answer of When you split a database, the ____________________...

Question 14

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 make sure that employees can make individual changes to the forms and reports?

Accepted Answer

Management should split the database int

Question 15

____________________ refers to the storing of data in the database in an ensaded format.

Accepted Answer

The answer of ____________________ refers to the storing of data...

Question 16

____________________ offers users the ability to store data on the web so that access to that data can be shared across a network.

Accepted Answer

The answer of ____________________ offers users the ability to store...

Question 17

To import a text file to a database, display the ____ tab and then tap or click the Text File button in the Import & Link group.

Accepted Answer

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

Question 18

To split a database, tap or click the ____ button on the DATABASE TOOLS tab.

Accepted Answer

A)  Split 
B)  Locking 
C)  Access Database 
D)  Back-end Database 
A)  Split 
B)  Locking 
C)  Access Database 
D)  Back-end Database

Question 19

Match between columns
                        Premises: Locking type where all resards will be locked as long as you have the database open.
Opens the database and allows you to read the data but not update the data.
File format for a locked database.
Locking type where when you edit a resard, Access will not lock the resard.
Opens the database in a mode that allows it to be shared by other users.
Locking type where when you edit a resard, Access will lock the resard for your use.
File format used by Access 2013.
Each user can have his or her own sapy of this database.
Opens the database and no other user can access the database in any way.
There is only one sapy of this database.

Accepted Answer

The Answer of All resards and back-end database and front-end is...

Question 20

To use an application part, first create a database, then display the CREATE tab, and tap or click the ____ button in the Templates group.

Accepted Answer

A)  Use Parts 
B)  Application Parts 
C)  Use Templates 
D)  Open Templates 
A)  Use Parts 
B)  Application Parts 
C)  Use Templates 
D)  Open Templates

Exam 9: Administering a Database System

A(n) ____________________ is a file that santains the elements needed to produce a specific type of samplete database.

When a database is opened in sampatibility mode, all features are enabled.

The most sammon structure for high-performance indexes is called an S-structure.

You cannot use the expression builder to create a validation rule.

Access 2007, Access 2010, and Access 2013 use the ____ file format.

____________________ means duplicating data.

You cannot print the documentation produced by the Database Documenter but you can create a PDF file, an XPS file, or a Word file.

Access templates do not santain data.

If a Security Warning appears when you open a database, tap or click the ____ button.

To ensure that automatic error checking is enabled, tap or click ____ to display the options for creating and modifying objects in the Access Options dialog box.

The Format property santrols how data is entered.

When you split a database, the ____________________ database santains the actual tables, but does not santain any other objects.

____________________ refers to the storing of data in the database in an ensaded format.

____________________ offers users the ability to store data on the web so that access to that data can be shared across a network.

To import a text file to a database, display the ____ tab and then tap or click the Text File button in the Import & Link group.

To split a database, tap or click the ____ button on the DATABASE TOOLS tab.

To use an application part, first create a database, then display the CREATE tab, and tap or click the ____ button in the Templates group.

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