Deck 15: Administering the Database

Question 1

In the figure above, the Compact on Close option is checked. This helps you ____.

A) set a startup switchboard
B) make sure the windows are tabbed
C) keep the database as small and efficient as possible
D) secure the database with a password

Answer 1

C

Question 2

External hard drives typically have more storage capacity than USB drives.

Answer 2

True

Question 3

The Performance Analyzer makes a variety of recommendations on how you can improve database performance.

Answer 3

True

Question 4

The form in the figure displays the frmEmployees form on the first tab.

Question 5

Which of the following is NOT a way to display the objects in the Navigation Pane?

A) by Ownership
B) by Object Type
C) by Created Date
D) by Custom Groups

Question 6

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Question 7

One of the reasons to split a database is to improve performance.

Question 8

More than one person can work with the data in an Access database at the same time.

Question 9

Default database options are stored in the Access Options dialog box.

Question 10

The figure shows a form with Horizontal Tabs.

Question 11

The Workgroup Administrator tool is used to recover forgotten passwords.

Question 12

3.5-inch disks with roughly 1 MB of storage capacity are a common portable storage device today.

Question 13

The dialog box in the figure is accessed from which tab on the Ribbon?

A) VIEW
B) BACKSTAGE
C) FILE
D) TOOLS

Question 14

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

Question 15

Access to queries, forms, and reports may all be added to a navigation form.

Question 16

Navigation forms can be used with any Access 2013 database, even if you don't publish it to a SharePoint server.

Question 17

The .laccdb file is a temporary file.

Question 18

You can recover a forgotten database password by opening the database in exclusive mode.

Question 19

Which of the following Access options provides a way to modify the buttons and tabs on the Ribbon?

A) Trust Center
B) Quick Access Toolbar
C) Customize Ribbon
D) Client Settings

Question 20

Database passwords are case sensitive which means that IOWA and iowa are different passwords.

Question 21

This startup command-line option starts Access and runs the specified macro.

A) /x macro
B) /run macro
C) /start macro
D) /execute macro

Question 22

Which of the following Access options sets defaults for cursor action, margins, and date formatting?

A) Object Designers
B) Quick Access Toolbar
C) Customize Ribbon
D) Client Settings

Question 23

Once a database is open, ____ is generally the single most important determinant of overall performance.

A) Memory
B) Modem speed
C) Network connection
D) Java version

Question 24

Use a(n) ____ to maintain constant power to a file server in the event of a power problem.

A) UPS
B) surge protector
C) power strip
D) encryption program

Question 25

Encryption is primarily a(n) ____ issue.

A) performance
B) data accuracy
C) security
D) ease-of-use

Question 26

A(n) ____ can cause a vast number of damaging actions ranging from profane messages to destruction of files.

A) spike
B) brown-out
C) UPS
D) virus

Question 27

____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

A) Split
B) Encrypted
C) Combination
D) Strong

Question 28

Command-line options follow which character in the path to the file?

A) Forward slash (/)
B) Backslash (\)
C) Pound sign (#)
D) Exclamation point (!)

Question 29

Which of the following is NOT a tip for optimizing database performance?

A) Close any other open applications not needed.
B) Convert the database to the Access 2002-2003 format.
C) Use Compact on Close to regularly compact the database.
D) Add more memory.

Question 30

A power surge is often referred to as a ____.

A) brown-out
B) black-out
C) dim
D) spike

Question 31

Which of the following Access options provides a way to set security, macro, and other privacy settings?

A) Trust Center
B) Add-ins
C) Customize Ribbon
D) Client Settings

Question 32

This startup command-line option repairs the database.

A) /repair
B) /compact
C) /fix
D) /rep

Question 33

Which of the following is a startup command-line option?

A) \excl
B) /repair
C) \x macro
D) /wrkgrp workgroup

Question 34

Which of the following is NOT a method to help secure an Access database?

A) Password
B) Encryption
C) Show/hide objects
D) Attachment fields

Question 35

This startup command-line option opens the database with the specified password.

A) /excl password
B) /pwd password
C) /pass password
D) x password

Question 36

This startup command-line option opens the database for exclusive access.

A) /excl
B) /ro
C) /exclusive
D) /read only

Question 37

Which of the following is NOT a level of advice regarding performance as analyzed by the Performance Analyzer?

A) Issue
B) Recommendation
C) Suggestion
D) Idea

Question 38

____ means that you are the only person who has the database open and others will not be able to open the file during this time.

A) Private mode
B) Exclusive mode
C) Encrypted
D) Splitting

Question 39

Which of the following Access options sets AutoCorrect and Spelling options?

A) Proofing
B) Language
C) Datasheet
D) Client Settings

Question 40

This startup command-line option opens the database for read-only access.

A) /ro
B) /read only
C) /read only access
D) /exclusive

Question 41

If you split an Access database, what is the name of the database that is stored on the client's machine?

A) The object database
B) The front-end database
C) The back-end database
D) The client database

Question 42

Client/server computing is defined as ____.

A) Two or more computers communicating
B) Two or more information systems cooperatively processing to solve a problem
C) A database using OLE Object fields
D) A database using Web enabling technologies

Question 43

Being Web compatible means that a form can be opened and used with Internet Explorer when the database is published to a(n) _____ server.

Question 44

The Access 2007 database format works with Access 2007, 2010, and ____.

A) 2000
B) 2002
C) 2003
D) 2013

Question 45

Which file extension is associated with the file that coordinates the multiuser capabilities of Access 2010?

A) .mdb
B) .laccdb
C) .ddb
D) .mud

Question 46

What is the file extension for the Access 2007 file format?

A) .mddb
B) .accdb
C) .laccdb
D) .dbf

Question 47

What is the file extension for the Access 2000 file format?

A) .mdb
B) .acb
C) .ldb
D) .dbf

Question 48

If you split an Access database, what is the name of the database that is stored on the file server?

A) The server database
B) The back-end database
C) The client/server database
D) The front-end database

Question 49

The ____ file extension is for a temporary file that keeps track of record-locking information when an older Access database is open. This is useful when there are several users of a database.

A) .accdb
B) .mcb
C) .mdb
D) .ldb

Question 50

In a client/server environment, what would be the client?

A) The network itself
B) The database that is being shared
C) The user's PC
D) The file server where the database is stored

Question 51

In client/server computing, what is a typical task for the client?

A) Storing objects and files used by that particular user
B) Managing data storage
C) Managing security for the network
D) Handling connectivity to other networks

Question 52

Both Access 2002 and 2000 databases have the same file extension, ____.

A) .accdb
B) .mcb
C) .mdb
D) .ldb

Question 53

Use the Access ____ file format for databases you need to work with Access 2000, 2002, and 2003.

A) 97
B) 2000
C) 2002
D) 2003

Question 54

When you split an Access database, how many copies of the back-end database do you use?

A) 1
B) 2
C) One copy for each user
D) One copy for each PC that accesses the database

Question 55

A(n) ____ option is a special set of characters added to the end of the path name to a database which execute a command when the database file is opened.

Question 56

A(n) _____ form is a special Access form that provides an easy-to-use database interface that is also Web compatible.

Question 57

Which Access database file format supports the Attachment data type?

A) 2000
B) 2002-2003
C) 2007
D) 2012

Question 58

In a client/server environment, what would be the server?

A) The computer where the database is stored
B) The user's PC
C) The database itself
D) The network itself

Question 59

____ are installed to link multiple PCs together so they can share hardware and software resources.

A) WANs
B) LANs
C) Clients
D) Servers

Question 60

What is the file extension for the Access 2002-2003 file format?

A) .mdb
B) .acb
C) .ldb
D) .dbf

Question 61

Differentiate between the Save Database As and Save Object As commands on the FILE tab.

Question 62

What are three typical duties of the server in a client/server environment?

Question 63

Set the Initial Form startup option to specify which form opens when the database application opens.

Question 64

In the figure shown, one option to make a copy of the entire database is to use the Back Up Database option.

Question 65

Set the Program Title startup option to add a custom title to the title bar instead of the database name and path.

Question 66

If you set a database _____ all users must enter that combination of characters before they are allowed to open the database.

Question 67

In Access 2013, the default file extension for a relational database is  _____

Question 68

_____ means to make the data in the database unreadable by other software.

Question 69

Use the Split Table Manager to manage a split database.

Question 70

A front-end database will contain _____ to the tables in the back-end database.

Question 71

You manage default startup options using the features in the _____ Database category of the Access Options dialog box.

Question 72

Identify three benefits of the Access 2007 database file format over its predecessors.

Question 73

In the figure above, to save only the current object, use the Save Object As option.

Question 74

_____ options are a series of commands that execute when the database is opened.

Question 75

When you _____ a database, you change the database file into one that can be opened in a previous version of Access.

Question 76

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde referenced in the figure shown above.  Explain the purpose of each.

Question 77

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

Question 78

Identify four things that you can do to deter or minimize the impact of theft or intentional damage to your computer?

Question 79

_____ a database refers to making a copy of it in a secure location.

Question 80

You can _____ an Access database into a back-end database and front-end database.