Deck 12: Managing and Securing a Database

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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 6

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

Question 7

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 8

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

Question 9

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

Question 10

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 11

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 12

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

Question 13

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

Question 14

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 15

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.____________________

Question 16

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

Question 17

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

Question 18

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 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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 25

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 26

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 27

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 28

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 29

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 30

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 31

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 32

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

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 34

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

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

Question 35

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 36

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 37

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 38

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 39

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 40

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 41

Case-Based Critical Thinking Questions
Case 12-2
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 42

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 43

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 44

Case-Based Critical Thinking Questions
Case 12-1
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 45

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 46

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 47

Case-Based Critical Thinking Questions
Case 12-2
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 48

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 49

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 50

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 51

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 52

Case-Based Critical Thinking Questions
Case 12-2
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 53

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 54

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 55

Case-Based Critical Thinking Questions
Case 12-1
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 56

Case-Based Critical Thinking Questions
Case 12-1
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 57

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 58

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 59

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 60

Case-Based Critical Thinking Questions
Case 12-2
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 72

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 74

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