Question 1

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.

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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?

Accepted Answer

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

Question 4

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.

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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?

Accepted Answer

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

Question 9

The accompanying figure illustrates which of the following?

Accepted Answer

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

Question 10

Match between columns
                        Premises: Another name for a parent query.

Accepted Answer

The Answer of Filter by Selection and outer query and is...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

Student answers will vary. Access treats

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of A new table created in Access will...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: A query that is run first within another query before the parent query is run.

Accepted Answer

The Answer of inner query and outer query and Filter is...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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.

Accepted Answer

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

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 database may be split by using the Access Database button in the ____ group on the DATABASE TOOLS tab.

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.

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

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

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

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?

The accompanying figure illustrates which of the following?

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

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

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

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

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

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

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

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

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.

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Filters

Exam 13: Managing and Sharing a Database

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 database may be split by using the Access Database button in the ____ group on the DATABASE TOOLS tab.

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.

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

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

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

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?

The accompanying figure illustrates which of the following?

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

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

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

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

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

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

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

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

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.

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Filters