Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The Answer of linked table and Performance Analyzer and inner is...

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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.

Accepted Answer

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

Question 8

After changing the location where a linked object is stored (such as a table), it is necessary to ____________________ from the Linked Table Manager.

Accepted Answer

The answer of After changing the location where a linked...

Question 9

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

Accepted Answer

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

Question 10

Match between columns
                        Premises: The database created when using the Database Splitter that includes the tables of the database.

Accepted Answer

The Answer of front-end database and back-end database and parent is...

Question 11

Which type of filter selects records that equal or contain (or do not equal or do not contain) a selected value in a 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 12

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

Accepted Answer

The answer of An outer query that contains a subquery...

Question 13

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

Accepted Answer

A)  after the database is updated 
B)  when the database is closed 
C)  before the database is updated 
D)  when the database is opened 
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 14

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

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

Accepted Answer

A) True 
 B)False

Question 16

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.

Accepted Answer

A)  EXTERNAL DATA 
B)  DATABASE TOOLS 
C)  CREATE 
D)  HOME 
A)  EXTERNAL DATA 
B)  DATABASE TOOLS 
C)  CREATE 
D)  HOME

Question 17

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 18

List five types of data sources that may be linked to an Access database.

Accepted Answer

1. Excel worksheet 
2. HTML do

Question 19

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

Accepted Answer

The answer of The Filter By Form feature may be...

Question 20

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

Accepted Answer

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

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

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

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

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

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.

After changing the location where a linked object is stored (such as a table), it is necessary to ____________________ from the Linked Table Manager.

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

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

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

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

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

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.

List five types of data sources that may be linked to an Access database.

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

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

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 filter may be saved as a query for a specific form or datasheet.

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

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

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

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.

After changing the location where a linked object is stored (such as a table), it is necessary to ____________________ from the Linked Table Manager.

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

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

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

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

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

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.

List five types of data sources that may be linked to an Access database.

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

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

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