Deck 16: Administering the Database

Question 1

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

Answer 1

A

Question 2

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

Answer 2

C

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

The figure shows a form with Horizontal Tabs.

Question 7

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

Question 8

The .laccdb file is a temporary file.

Question 9

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

Question 10

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

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

The Workgroup Administrator tool is used to recover forgotten passwords.

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

A power surge is often referred to as a ____.

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

Question 24

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 25

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 26

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

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

Question 27

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 28

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 29

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

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

Question 30

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 31

____ 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 32

Encryption is primarily a(n) ____ issue.

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

Question 33

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 34

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 35

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

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

Question 36

____ 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 37

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

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

Question 38

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 39

This startup command-line option repairs the database.

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

Question 40

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

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

Question 41

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 42

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

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

Question 43

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 44

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

Question 45

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 46

Which Access database file format supports the Attachment data type?

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

Question 47

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 48

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 49

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 50

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

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

Question 51

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 52

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 53

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 54

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

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

Question 55

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

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

Question 56

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 57

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

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

Question 58

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 59

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 60

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

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

Use the Split Table Manager to manage a split database.

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

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

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

Question 77

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 78

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

Question 79

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

Question 80

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