Question 1

Filters do not delete data or records.

Accepted Answer

A) True 
 B)False

Question 2

How many records do most forms display?

Accepted Answer

A) 0 (Forms don't display records) 
B) 1 
C) 2 
D) All the records at the same time 
A) 0 (Forms don't display records) 
B) 1 
C) 2 
D) All the records at the same time

Question 3

A(n)________ allows you to poll the data in your database.

Accepted Answer

The answer of A(n)________ allows you to poll the data...

Question 4

What allows you to add components to an existing database,rather than creating an entire new database?

Accepted Answer

A) Objects 
B) Filters 
C) Application parts 
D) Templates 
A) Objects 
B) Filters 
C) Application parts 
D) Templates

Question 5

To assign a field size of 12 to a field in a table you would ________.

Accepted Answer

A) pick Short Text from the Data Type list 
B) pick Long Text from the Data Type list 
C) type 12 in the Description area of that field 
D) enter 12 in the Field Size property of that field 
A) pick Short Text from the Data Type list 
B) pick Long Text from the Data Type list 
C) type 12 in the Description area of that field 
D) enter 12 in the Field Size property of that field

Question 6

Which of the following is not a valid comparison operator?

Accepted Answer

A) B) = C) => D) <= A) B) = C) => D) <=

Question 7

Match between columns
                        Premises: Record
Primary Key
Table
Field
Query

Accepted Answer

The Answer of Uniquely identifies a record and Complete set is...

Question 8

What are the two ways you can view a table?

Accepted Answer

A) Design and Layout views 
B) Design and Datasheet views 
C) Datasheet and Form views 
D) Datasheet and Layout views 
A) Design and Layout views 
B) Design and Datasheet views 
C) Datasheet and Form views 
D) Datasheet and Layout views

Question 9

As long as your data is accurate there is no real need to print preview your reports.

Accepted Answer

A) True 
 B)False

Question 10

Creating a database from a template can help you get started more quickly.

Accepted Answer

A) True 
 B)False

Question 11

What view normally appears when you double-click a table?

Accepted Answer

A) Form view 
B) Layout view 
C) Design view 
D) Datasheet view 
A) Form view 
B) Layout view 
C) Design view 
D) Datasheet view

Question 12

Which of the following is not one of the three methods for creating a database?

Accepted Answer

A) Create a blank desktop database 
B) Create a blank cloud database 
C) Create a custom web app 
D) Create a database from a template 
A) Create a blank desktop database 
B) Create a blank cloud database 
C) Create a custom web app 
D) Create a database from a template

Question 13

When you close a table after using a selection filter and then reopen it,what happens to the filter?

Accepted Answer

A) The filter is still operating. 
B) The filter is not saved. 
C) The filter is removed,but Toggle Filter will bring it back. 
D) The filter is removed permanently. 
A) The filter is still operating. 
B) The filter is not saved. 
C) The filter is removed,but Toggle Filter will bring it back. 
D) The filter is removed permanently.

Question 14

When you double-click a query,the interface looks like a(n)________.

Accepted Answer

The answer of When you double-click a query,the interface looks...

Question 15

If you find yourself performing the same exact actions over and over,you might consider creating a (n)________.

Accepted Answer

The answer of If you find yourself performing the same...

Question 16

Match between columns
                        Premises: Object
Primary key
Record
Relationship
Navigation Pane

Accepted Answer

The Answer of An interface that lists the objects in is...

Question 17

What type of filter displays records based on a criterion you choose?

Accepted Answer

A) Selection filter 
B) Filter by Report 
C) Exact Match filter 
D) Toggle filter 
A) Selection filter 
B) Filter by Report 
C) Exact Match filter 
D) Toggle filter

Question 18

Which of the following produces a subset of your data?

Accepted Answer

A) Macro 
B) Field 
C) Table 
D) Query 
A) Macro 
B) Field 
C) Table 
D) Query

Question 19

The ________ filter operator will give you the smallest number hits.

Accepted Answer

The answer of The ________ filter operator will give you...

Question 20

You always know when you are using a database.

Accepted Answer

A) True 
 B)False

Filters do not delete data or records.

How many records do most forms display?

A(n)________ allows you to poll the data in your database.

What allows you to add components to an existing database,rather than creating an entire new database?

To assign a field size of 12 to a field in a table you would ________.

Which of the following is not a valid comparison operator?

What are the two ways you can view a table?

As long as your data is accurate there is no real need to print preview your reports.

Creating a database from a template can help you get started more quickly.

What view normally appears when you double-click a table?

Which of the following is not one of the three methods for creating a database?

When you close a table after using a selection filter and then reopen it,what happens to the filter?

When you double-click a query,the interface looks like a(n)________.

If you find yourself performing the same exact actions over and over,you might consider creating a (n)________.

What type of filter displays records based on a criterion you choose?

Which of the following produces a subset of your data?

The ________ filter operator will give you the smallest number hits.

You always know when you are using a database.

Office 365 Common Features

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 2: Introduction to Access

Filters do not delete data or records.

How many records do most forms display?

A(n)________ allows you to poll the data in your database.

What allows you to add components to an existing database,rather than creating an entire new database?

To assign a field size of 12 to a field in a table you would ________.

Which of the following is not a valid comparison operator?

What are the two ways you can view a table?

As long as your data is accurate there is no real need to print preview your reports.

Creating a database from a template can help you get started more quickly.

What view normally appears when you double-click a table?

Which of the following is not one of the three methods for creating a database?

When you close a table after using a selection filter and then reopen it,what happens to the filter?

When you double-click a query,the interface looks like a(n)________.

If you find yourself performing the same exact actions over and over,you might consider creating a (n)________.

What type of filter displays records based on a criterion you choose?

Which of the following produces a subset of your data?

The ________ filter operator will give you the smallest number hits.

You always know when you are using a database.

Office 365 Common Features

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters