Question 1

In Datasheet view, ________ represent columns.

Accepted Answer

fields

Question 2

One of the reasons someone may choose to start a database with a template is to save time by not having to ________.

Accepted Answer

A)  enter so much data 
B)  know anything about Access 
C)  create as many objects 
D)  create the table relationships 
A)  enter so much data 
B)  know anything about Access 
C)  create as many objects 
D)  create the table relationships C

Question 3

By default, Access uses a(n) ________ Documents interface.

Accepted Answer

Tabbed

Question 4

Which of the following is not a valid criteria in a filter?

Accepted Answer

A)  ="Fred" 
B)  =>14 
C)  125 
D)  Is Null 
A)  ="Fred" 
B)  =>14 
C)  125 
D)  Is Null

Question 5

Be careful before you delete a record from a table.

Accepted Answer

A) True 
 B)False

Question 6

Every time you open a database you will receive a security warning.

Accepted Answer

A) True 
 B)False

Question 7

Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

Accepted Answer

A) True 
 B)False

Question 8

You always know when you are using a database.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following operators will give you the fewest number of hits?

Accepted Answer

A)  AND 
B)  OR 
C)  NOT 
D)  NOR 
A)  AND 
B)  OR 
C)  NOT 
D)  NOR

Question 10

Filters do not delete data or records.

Accepted Answer

A) True 
 B)False

Question 11

Which method of creating a database demands the least amount of expertise in Access?

Accepted Answer

A)  Creating a blank desktop database 
B)  Creating a custom web app 
C)  Importing an Excel spreadsheet 
D)  Using a template 
A)  Creating a blank desktop database 
B)  Creating a custom web app 
C)  Importing an Excel spreadsheet 
D)  Using a template

Question 12

Which of the following is not a valid comparison operator?

Accepted Answer

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

Question 13

What database object is an electronic version of the paperwork you fill out at the doctor's office?

Accepted Answer

A)  Form 
B)  Report 
C)  Table 
D)  Field 
A)  Form 
B)  Report 
C)  Table 
D)  Field

Question 14

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 15

Match the following terms with their description:
I. Form
II. Report
III. Macro
IV. Sort
V. Filter
A. A way of displaying data in which the data cannot be changed
B. Changes the order of how records are displayed
C. Using this is the one way of entering data
D. Limits the amount of data displayed
E. A stored set of commands

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 16

Match the following with their description:
I. LastName, FirstName, CellPhone
II. AutoNumber, Short Text, Number
III. Social Security Number, Student ID, AutoNumber
IV. 4, >2000, ="Fred"
V. Validation Rule, Field Size, Caption
A. Examples of filter criterion
B. Examples of field properties
C. Examples of field names
D. Examples of Primary keys
E. Examples of Data Types

Accepted Answer

The answer of Match the following with their description:
I. LastName,...

Question 17

A primary key can be a combination of several fields.

Accepted Answer

A) True 
 B)False

Question 18

Match the following terms with their description:
I. Table
II. Record
III. Form
IV. Report
V. Query
A. A collection of records
B. A collection of fields
C. Selecting, organizing, sorting and filtering fields from one or more tables
D. Displaying data in a way that the data can't be edited
E. Used to enter data

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 19

Which of the following views would you use to view or modify a table's structure?

Accepted Answer

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

Question 20

How can you toggle viewing the Navigation Pane?

Accepted Answer

A)  Shutter Bar View/Hide button 
B)  Navigation Pane View/Hide button 
C)  Shutter Bar Open/Close button 
D)  Navigation Pane Open/Close button 
A)  Shutter Bar View/Hide button 
B)  Navigation Pane View/Hide button 
C)  Shutter Bar Open/Close button 
D)  Navigation Pane Open/Close button

In Datasheet view, ________ represent columns.

One of the reasons someone may choose to start a database with a template is to save time by not having to ________.

By default, Access uses a(n) ________ Documents interface.

Which of the following is not a valid criteria in a filter?

Be careful before you delete a record from a table.

Every time you open a database you will receive a security warning.

Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

You always know when you are using a database.

Which of the following operators will give you the fewest number of hits?

Filters do not delete data or records.

Which method of creating a database demands the least amount of expertise in Access?

Which of the following is not a valid comparison operator?

What database object is an electronic version of the paperwork you fill out at the doctor's office?

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

A primary key can be a combination of several fields.

Which of the following views would you use to view or modify a table's structure?

How can you toggle viewing the Navigation Pane?

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

In Datasheet view, ________ represent columns.

One of the reasons someone may choose to start a database with a template is to save time by not having to ________.

By default, Access uses a(n) ________ Documents interface.

Which of the following is not a valid criteria in a filter?

Be careful before you delete a record from a table.

Every time you open a database you will receive a security warning.

Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

You always know when you are using a database.

Which of the following operators will give you the fewest number of hits?

Filters do not delete data or records.

Which method of creating a database demands the least amount of expertise in Access?

Which of the following is not a valid comparison operator?

What database object is an electronic version of the paperwork you fill out at the doctor's office?

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

A primary key can be a combination of several fields.

Which of the following views would you use to view or modify a table's structure?

How can you toggle viewing the Navigation Pane?

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