Deck 12: Managing and Securing a Database

Question 1

Values designated for a multivalue field cannot be changed after the field is created and the table is saved.

Answer 1

False

Question 2

Performance Analyzer can only run on one Access database object at a time.

Answer 2

False

Question 3

After splitting a database using the Database Splitter,if the back-end database is moved to a different drive location,the Linked Table Manager must be used to change the physical drive locations of the tables located in the back-end database for the front-end database to be able to use them.____________________

Answer 3

True

Question 4

The AutoNumber data type allows the option to specify either sequential numbering or random numbering for a field.____________________

Question 5

The Advanced button in the Sort & Filter group on the Home tab allows the user to verify that a filter is working properly.

Question 6

Which type of filter filters records containing a selection displayed in a menu of values and context-sensitive choices for the selected field?

A)AutoFilter
B)Filter By Selection
C)Filter by Form
D)Advanced Filter/Sort

Question 7

A filter may be saved as a query from the Advanced button in the Sort & Filter group on the Home tab.

Question 8

The data in the tables of a split database is modified by the back-end database.

Question 9

Attachments associated with a field whose data type is Attachment may be exported using the Remove button from the Attachments dialog box.____________________

Question 10

An outer query may also be referred to as a subquery.____________________

Question 11

Only one file attachment is allowed for a field with the Attachment data type selected.

Question 12

A filter may be saved as a query for a specific form or datasheet.

Question 13

Which type of field is a lookup field that allows more than one value to be stored in a field in each record?

A)long text
B)multivalued
C)date/time
D)calculated

Question 14

In order to isolate a subset of records from an open form or datasheet that will be needed only temporarily,a set of criteria may be placed on the records using a(n)____.

A)filter
B)ascending sort
C)macro
D)module

Question 15

When using a Filter By Form to filter records,all criteria on one line must be met by a record for the record to appear in the filtered data datasheet.____________________

Question 16

An Access database created using Access 2007 or later may only be saved with the *.accdb filename extension and cannot be opened with versions of Access prior to 2007.____________________

Question 17

Filters applied to query datasheets are saved when the table is saved and may be applied anytime the table datasheet is open.____________________

Question 18

Table design for tables in a split database may only be modified in the front-end database.____________________

Question 19

The contents of an encrypted database cannot be recovered if the password for the database is not available.

Question 20

It is good practice to make a backup copy of a database before using the Database Splitter to split the database into two files.

Question 21

The process of linking an outside data source to an Access database begins by clicking on the Access button in the Import & Link group on the ____ tab.

A)External Data
B)Database Tools
C)Create
D)Home

Question 22

The objects in a front-end database use tables in the ____.

A)modules list
B)ODBC database
C)back-end database
D)relationships window

Question 23

Which type of filter selects records that equal or contain (or do not equal or do not contain)a selected value in a field?

A)AutoFilter
B)Filter By Selection
C)Filter By Form
D)Advanced Filter/Sort

Question 24

The New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.

A)Sequential
B)Next
C)Random
D)Increment

Question 25

A database may be split by using the Access Database button in the ____ group on the Database Tools tab.

A)Tools
B)Macro
C)Relationships
D)Move Data

Question 26

Which Access feature is used to divide an Access database into two files: one file contains the tables of the database and the other file contains the queries,forms,reports,and other database objects.

A)Linked Table Manager
B)Relationships
C)Database Splitter
D)ODBC database

Question 27

The ____ method is used to copy a table and copies both the design of the table and the data from the table.

A)Structure Only
B)Append Data to Existing Table
C)Append Design to Existing Table
D)Structure and Data

Question 28

Which Access feature is used to change the filename or drive location for linked tables in an Access database?

A)Data Services
B)ODBC Database
C)Linked Table Manager
D)Link Tables dialog box

Question 29

The primary purpose of the ____ is to optimize the performance of an Access database.

A)Table Analyzer
B)SQL Server
C)Relationships Analyzer
D)Performance Analyzer

Question 30

Access versions prior to 2007 do not have the capability to open Access 2016 databases even if saved as a previous version file if the database contains a(n)____ field type for a field.

A)OLE object
B)Attachment
C)Memo
D)Hyperlink

Question 31

The Database Splitter splits an Access database into two separate files.One file contains queries,forms,reports,and other database objects and the other file contains the database ____.

A)tables
B)modules
C)macros
D)database tools

Question 32

The ____ filter allows multiple criteria to be selected and a sort order to be defined for the selected records.

A)AutoFilter
B)Filter by Selection
C)Filter B Form
D)Advanced Filter/Sort

Question 33

When a database is encrypted,data that is modified is encrypted ____.

A)after the database is updated
B)when the database is closed
C)before the database is updated
D)when the database is opened

Question 34

Where is an Access database password stored?

A)in an Access module
B)in an Access table named tblPW
C)it is not stored anywhere
D)in a separate database created by Access

Question 35

The ____ data type allows external files to be attached to a table record and stored as part of the database.

A)Attachment
B)OLE object
C)Text
D)Memo

Question 36

To display a multivalued field in expanded form so that each value is displayed on a separate row in a query,set the ____ property for the field.

A)Lookup
B)Value
C)Row Source
D)Validation Rule

Question 37

Which of the following is an example of a database containing the database tables created by the Database Splitter for the Sales database?

A)Sales_back-end
B)Sales_be
C)SalesBackEnd
D)SalesTables.accdb

Question 38

The protection of a database against intentional or accidental unauthorized access is known as database ____.

A)security
B)encryption
C)protection
D)oversight

Question 39

____ filters records that match multiple criteria using the same Access logical and comparison operators used in queries.

A)AutoFilter
B)Filter by Selection
C)Filter By Form
D)Advanced Filter/Sort

Question 40

Which filter type allows the use of comparison operators such as <,>=,<>,and Like?

A)AutoFilter
B)Filter By Form
C)Filter By Selection
D)Advanced Filter/Sort

Question 41

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
Sheng's regional manager may ask for the same information again at a later date so Sheng would like to save one of his filters for use later.What is the best option for saving the filter?

A)save the filter as a datasheet
B)save the filter with the form
C)save the filter as a query
D)save the filter as a separate file

Question 42

When shared access is allowed to a database,____ occurs when one user is updating a record (or row)in the database and another user is denied access to that table row.

A)reading
B)exclusive access
C)row-level locking
D)encryption

Question 43

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
Sheng needs to determine which vendors provide the most options for floor mats that are compatible with the specific car model.To do this,he will apply a filter that is based on multiple selection criteria and that sorts the records that are selected by vendor name alphabetically.Which type of filter will Sheng apply to the datasheet?

A)Advanced Filter/Sort
B)AutoFilter
C)Filter by Form
D)Filter by Selection

Question 44

Startup options for a database may be bypassed when opening a database by pressing the ____ key while clicking on the database name.

A)Ctrl
B)Shift
C)Alt
D)Tab

Question 45

The Access default is that databases allow ____ of the database meaning that two or more users can open and use the same database at the same time.

A)read/write access
B)exclusive access
C)password protected access
D)shared access

Question 46

Using Backstage View and Access Options,set the ____ property to change the title of the database that appears in the Access window title bar.

A)Display Status Bar
B)Application Title
C)Application Icon
D)Document Window Options

Question 47

Which of the following is an example of sensitive data that would warrant the database being encrypted and protected with a password?

A)health record information
B)course schedule
C)employee addresses
D)customer ID numbers

Question 48

Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors.
There are occasions when Marissa has orders from one customer for different monogram styles for the same product.Rather than creating separate orders for each item,she might use a(n)____ field to store the different monogram styles for the product in the Orders table.

A)Lookup
B)Linked
C)Multivalued
D)Relationship

Question 49

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
The first set of data Sheng needs to provide is the names of all floor mat manufacturers who provide floor mats that fit a specific car model.Which type of filter should Sheng apply to the FloorMatCapatibility field that will allow the display of context-sensitive values for this single field?

A)Advanced Filter/Sort
B)Filter by Form
C)Filter by Selection
D)AutoFilter

Question 50

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
Using the Product Vendor form,Sheng would like to filter records that match multiple selection criteria;however,he does not need the filtered records to be sorted.Which type of filter should Sheng use for this task?

A)Filter by Form
B)Advanced Filter/Sort
C)AutoFilter
D)Filter by Selection

Question 51

Users may be prevented from viewing and editing VBA code by saving the database as a(n)____ file version.

A)*.accdb
B)*.mdbe
C)*.accde
D)*.accmdbe

Question 52

It is recommended that the user interface of a database be displayed using the ____ when a database opens with the Display Navigation Pane property disabled.

A)Layout View
B)navigation form
C)Datasheet view
D)edit form

Question 53

Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors.
Each number in the ItemNumber field for all catalog products were created manually by Marissa.Her new assistant pointed out that she could have the database create the ItemNumber automatically by changing the field's data type to ____.

A)AutoNumber
B)Number
C)Long Integer
D)Calculated

Question 54

Alicia wants a database to open using the frmNavigation object only.To do this,she must disable the ____ option from Backstage View using Options and the Current Database.

A)Allow Full Menus
B)Display Navigation Pane
C)Display Navigation Form
D)Enable error checking

Question 55

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
Sheng also considers creating a second SQL SELECT statement within the query used to create the datasheet containing the filter he plans to save.If Sheng does this,he is creating a(n)____.

A)outer query
B)subquery
C)parent query
D)filtered query

Question 56

Any database action that does not involve updating the database is known as ____ the database.

A)viewing
B)sharing access
C)reading
D)locking

Question 57

Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors.
Marissa's assistant suggested other changes be made to the database.After the changes were made,Marissa used the ____ Access tool to optimize the database by having the tool implement recommendations and suggestions.

A)ODBC Database
B)Object Dependencies
C)Performance Analyzer
D)Compact and Repair

Question 58

Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors.
Marissa would like to add a picture of each catalog product to each record in the catalog table.Which data type should she use for the ProductDescription field?

A)Lookup
B)Multivalued
C)Attachment
D)OLE Object

Question 59

Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors.
Finally,Marissa wants to secure the database because she does not want all of her new employees to access sensitive customer information such as credit card information.Her assistant suggests she ____ the database which translates the data to a scrambled format and requires a password to access the database.

A)decrypt
B)lock
C)encode
D)encrypt

Question 60

A database must be opened using ____ meaning that only one copy of the database is open in order to set a password for the database.

A)shared access
B)exclusive access
C)encrypted access
D)locked access

Question 61

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
An Access tool used to optimize the performance of an Access database.

Question 62

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
The database created when using the Database Splitter that includes the tables of the database.

Question 63

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
A query that contains a subquery.

Question 64

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
​A lookup eld that allows you to store more than one value in a field in each record

Question 65

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
​Enables or disables the F11 key (show/hide the Navigation Pane),Ctrl+G (show/hide the Immediate window in VB editor),and Alt+F1 (start VB Editor).

Question 66

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
The filter type that filters records containing one of the selections displayed in a menu of values and context-sensitive choices for the selected field.

Question 67

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
A table that is stored in a file outside of the open database that can be updated from the open database.

Question 68

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
The database created when using the Database Splitter that includes all database objects except the tables of the database.

Question 69

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
A query that is run first within another query before the parent query is run.

Question 70

When deciding whether or not to use a multivalued filed in an Access database,what limitations of using multivalued fields should be given careful thought?

Question 71

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
A second query included in a SQL SELECT statement beginning with a second SELECT statement.

Question 72

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
Specifies the form that opens automatically when you open the database

Question 73

Why is it a good idea to set the Allow Zero Length property to No for fields with the Text or Memo data types?

Question 74

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
Another name for a parent query.

Question 75

a.front-end database
b.AutoFilter
c.Performance Analyzer
d.inner query
e.linked table
f.back-end database
g.outer query
h.subquery
i.parent query
j.Filter by Selection
k.multivalued field
l.Use Access Special Keys option
m.Display Form option
The filter type used to filter records that equal or contain (or do not equal or do not contain)a selected value in a field.