Question 1

What database object organizes your data by rows and columns?

Accepted Answer

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

Question 2

Using the Compact and Repair Database utility on a regular basis is good practice.

Accepted Answer

A) True 
 B)False  True

Question 3

Searching a website to help you find just the right product involves database technology.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

Match between columns
                        Premises: Query
Report
Record
Table
Form

Accepted Answer

The Answer of Used to enter data and Displaying data is...

Question 6

What interface element shows you the various objects in your database?

Accepted Answer

A) The Database Tools menu 
B) The Database Properties pane 
C) The Home menu 
D) The Navigation Pane 
A) The Database Tools menu 
B) The Database Properties pane 
C) The Home menu 
D) The Navigation Pane

Question 7

What is not true about field properties?

Accepted Answer

A) They define a field's characteristics. 
B) They vary by field type. 
C) They can allow data entry to be required for a field. 
D) The categories are the same for all field types. 
A) They define a field's characteristics. 
B) They vary by field type. 
C) They can allow data entry to be required for a field. 
D) The categories are the same for all field types.

Question 8

To create a database from a template you would use which view?

Accepted Answer

A) Design 
B) Layout 
C) Create database 
D) Backstage 
A) Design 
B) Layout 
C) Create database 
D) Backstage

Question 9

A good practice is to make backups of your databases on different storage devices.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

Naming a table carefully is very important because it is the only way to describe what data that table contains.

Accepted Answer

A) True 
 B)False

Question 12

The ________ icon indicates that a field is the primary key.

Accepted Answer

The answer of The ________ icon indicates that a field...

Question 13

You cannot change ________ in a report; reports only display it.

Accepted Answer

The answer of You cannot change ________ in a report;...

Question 14

Most users enter information into a database through the use of a ________.

Accepted Answer

A) form 
B) table in datasheet view 
C) query 
D) macro 
A) form 
B) table in datasheet view 
C) query 
D) macro

Question 15

Using Filter by Form enables you to filter on multiple criteria.

Accepted Answer

A) True 
 B)False

Question 16

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 17

A(n)________ enables you to add a set of common Access components to an existing database.

Accepted Answer

The answer of A(n)________ enables you to add a set...

Question 18

Databases only work with data,not information.

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

Match between columns
                        Premises: Social Security Number,Student ID,AutoNumber
LastName,FirstName,CellPhone
AutoNumber,Short Text,Number
<>4,>2000,="Fred"
Validation Rule,Field Size,Caption

Accepted Answer

The Answer of Examples of field properties and Examples of is...

What database object organizes your data by rows and columns?

Using the Compact and Repair Database utility on a regular basis is good practice.

Searching a website to help you find just the right product involves database technology.

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.

What interface element shows you the various objects in your database?

What is not true about field properties?

To create a database from a template you would use which view?

A good practice is to make backups of your databases on different storage devices.

How can you toggle viewing the Navigation Pane?

Naming a table carefully is very important because it is the only way to describe what data that table contains.

The ________ icon indicates that a field is the primary key.

You cannot change ________ in a report; reports only display it.

Most users enter information into a database through the use of a ________.

Using Filter by Form enables you to filter on multiple criteria.

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

A(n)________ enables you to add a set of common Access components to an existing database.

Databases only work with data,not information.

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

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

What database object organizes your data by rows and columns?

Using the Compact and Repair Database utility on a regular basis is good practice.

Searching a website to help you find just the right product involves database technology.

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.

What interface element shows you the various objects in your database?

What is not true about field properties?

To create a database from a template you would use which view?

A good practice is to make backups of your databases on different storage devices.

How can you toggle viewing the Navigation Pane?

Naming a table carefully is very important because it is the only way to describe what data that table contains.

The ________ icon indicates that a field is the primary key.

You cannot change ________ in a report; reports only display it.

Most users enter information into a database through the use of a ________.

Using Filter by Form enables you to filter on multiple criteria.

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

A(n)________ enables you to add a set of common Access components to an existing database.

Databases only work with data,not information.

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

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