Deck 14: Administering the Database

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

A

Question 4

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

Question 5

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

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

Question 6

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

Question 7

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

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

Question 8

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

Question 9

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

Question 10

The .laccdb file is a temporary file.

Question 11

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

Question 12

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

Question 13

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

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

Question 14

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 15

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 16

The Workgroup Administrator tool is used to recover forgotten passwords.

Question 17

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

Question 18

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 19

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

Question 20

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

Question 21

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

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

Question 22

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 23

Which Access database file format supports multivalued fields?

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

Question 24

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 25

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

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

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

Question 27

Once a database is open, ____ is one way to improve overall performance.

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

Question 28

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 29

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

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

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

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

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

Question 32

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 33

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 34

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

A) Autoexec
B) Startup
C) Autodefault
D) Autocommand

Question 35

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

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

Question 36

A power surge is often referred to as a ____.

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

Question 37

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

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 39

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

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

Question 40

Encryption is primarily a(n) ____ issue.

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

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

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

Question 43

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

Question 44

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 45

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

Question 46

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 47

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

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

Question 48

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 49

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

Question 50

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 51

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 52

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

Question 53

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

Question 54

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 55

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 56

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

Question 57

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

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

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

Question 60

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

Question 62

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

Question 63

Use the Split Table Manager to manage a split database.

Question 64

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

Question 65

When you type a password in the Set Database Password dialog box, question marks (?) appear instead of the actual keystroke.

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde.  Explain the purpose of each.