Deck 13: Managing and Sharing a Database

Question 1

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

Answer 1

False

Question 2

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 2

True

Question 3

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

Answer 3

True

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

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

Question 6

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 7

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

Question 8

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

Question 9

Detaching a file from a field with the Attachment data type does not delete the file being detached; it just removes the file from the database and its association to the field.

Question 10

Only one form or datasheet may be used when creating a filter .____________________

Question 11

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

Question 12

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

Question 13

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 14

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

Question 15

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

Question 16

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

Question 17

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 18

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

Question 19

Records in a linked database may be retrieved and updated.____________________

Question 20

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

Question 21

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 22

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 23

Using the accompanying figure for reference, which field property is set to Yes by default for Text and Memo field data types?

A) Indexed
B) Allow Zero Length
C) Unicode Compression
D) Default Value

Question 24

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 25

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 26

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 27

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 28

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 29

Using the accompanying figure, which field has been selected as a field that will contain multiple values?

A) Position
B) Supervisor
C) Degree
D) Lookup

Question 30

Using the accompanying figure, which field property is set to allow more than one value to be added to the field?

A) Row Source
B) Allow Multiple Values
C) Allow Value List Edits
D) Row Source Type

Question 31

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 32

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 33

Access versions prior to 2007 do not have the capability to open Access 2013 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 34

Using the accompanying figure for reference, which field property, when set to No, means that it is optional to enter a field value?

A) Indexed
B) Allow Zero Length
C) Required
D) Default Value

Question 35

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 36

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 37

In the accompanying figure, the selected field is the ____ field.

A) EmployeeID
B) Position
C) Required
D) Supervisor ID

Question 38

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

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 40

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 41

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 42

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 43

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 44

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 45

The accompanying figure illustrates which of the following?

A) a navigation form
B) a record in Datasheet View
C) the Navigation Pane
D) a read-only database

Question 46

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 47

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 48

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 49

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 50

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 51

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 52

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 53

In the accompanying figure, the user has been restricted to using only the ____ and ____ tabs on the Access Ribbon.

A) Forms and Queries
B) Queries and Reports
C) File and Home
D) Records and Find

Question 54

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 55

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 56

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 57

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

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

Question 58

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 59

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 60

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 61

In the accompanying figure, which numbered arrow indicates the Access feature that toggles an Access datasheet between filtered view and the full datasheet view?

A) 1
B) 2
C) 3
D) 4

Question 62

The three types of analysis results listed by the ____________________ are recommendation, suggestion, and idea.

Question 63

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 64

In the accompanying figure, which numbered arrow indicates that a filter has been applied to the current datasheet?

A) 1
B) 2
C) 3
D) 4

Question 65

The Performance Analyzer can automatically complete the recommendations and ____________________ listed after the analysis.

Question 66

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 67

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 68

The accompanying figure illustrates criteria selection(s) for the ____________________ type of filter.

Question 69

A new table created in Access will display the default primary key field ID in Datasheet view with the ____________________ data type.

Question 70

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 71

The Filter By Form feature may be accessed from the Sort & Filter group on the ____________________ tab.

Question 72

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 73

To display all fields from the record source without all fields being added to the design of a query, set the ____________________ property to Yes.

Question 74

The ____ data type does not allow the field type to be changed later; rather, the field must be deleted and re-created with a new data type.

Question 75

An outer query that contains a subquery is also referred to as a(n) ____________________ query.

Question 76

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 77

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 78

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 79

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 80

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