Question 1

Match between columns
                        Premises: 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.

Accepted Answer

The Answer of inner query and front-end database and Use is...

Question 2

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

Accepted Answer

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

Question 3

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.

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Question 13

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 14

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 15

Match between columns
                        Premises: A query that contains a subquery.

Accepted Answer

The Answer of Display Form option and Filter by Selection is...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: A second query included in a SQL SELECT statement beginning with a second SELECT statement.

Accepted Answer

The Answer of front-end database and Display Form option and is...

Question 19

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)____.

Accepted Answer

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

Question 20

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

Accepted Answer

The Answer of front-end database and outer query and Filter is...

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

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

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

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

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

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

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

The protection of a database against intentional or accidental unauthorized access is known as 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.

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?

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 AutoNumber data type allows the option to specify either sequential numbering or random numbering for a field.____________________

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

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)____.

Access-Module 1: 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

Relational Databases and Database Design

Filters

Exam 12: Managing and Securing a Database

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

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

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

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

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

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

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

The protection of a database against intentional or accidental unauthorized access is known as 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.

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?

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 AutoNumber data type allows the option to specify either sequential numbering or random numbering for a field.____________________

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

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)____.

Access-Module 1: 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

Relational Databases and Database Design

Filters