Question 1

When you enter a field into a database, you are entering ________.

Accepted Answer

The answer of When you enter a field into a...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

How would you sort records in a field so that the oldest birthday is listed first?

Accepted Answer

A)  Sort by form 
B)  Selection sort 
C)  Sort descending 
D)  Sort ascending 
A)  Sort by form 
B)  Selection sort 
C)  Sort descending 
D)  Sort ascending

Question 4

Match the following terms with their description:
i. Navigation Pane
II. Object
III. Primary key
IV. Record
v. Relationship

Accepted Answer

A)  A component which makes the database function 
B)  A complete collection of all fields about one entity 
C)  A connection between tables using a common field 
D)  That which uniquely identifies records in a table 
E)  An interface that lists the objects in an Access database 
A)  A component which makes the database function 
B)  A complete collection of all fields about one entity 
C)  A connection between tables using a common field 
D)  That which uniquely identifies records in a table 
E)  An interface that lists the objects in an Access database

Question 5

Which of the following is not a valid comparison operator?

Accepted Answer

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

Question 6

The ________ command helps you locate specific records.

Accepted Answer

The answer of The ________ command helps you locate specific...

Question 7

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

Accepted Answer

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

Question 8

When you split a database, what object type is put in the back end?

Accepted Answer

A)  Tables 
B)  Forms 
C)  Reports 
D)  Macros and Modules 
A)  Tables 
B)  Forms 
C)  Reports 
D)  Macros and Modules

Question 9

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 10

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 11

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 12

Using the Back Up Database utility only saves the structure of the database, not the content.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

Filters do not delete data or records.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

Accepted Answer

A)  It depends on how many of the fields are blank. 
B)  53 
C)  106 
D)  It depends on how many of the fields contain exactly the same information. 
A)  It depends on how many of the fields are blank. 
B)  53 
C)  106 
D)  It depends on how many of the fields contain exactly the same information.

Question 19

Match the following terms with their description:
i. Table
II. Record
III. Form
IV. Report
v. Query

Accepted Answer

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

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

When you enter a field into a database, you are entering ________.

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

How would you sort records in a field so that the oldest birthday is listed first?

Match the following terms with their description: i. Navigation Pane II. Object III. Primary key IV. Record v. Relationship

Which of the following is not a valid comparison operator?

The ________ command helps you locate specific records.

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

When you split a database, what object type is put in the back end?

What is not true about field properties?

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

How many records do most forms display?

Using the Back Up Database utility only saves the structure of the database, not the content.

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.

Filters do not delete data or records.

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

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

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

Match the following terms with their description: i. Table II. Record III. Form IV. Report v. Query

How can you toggle viewing the Navigation Pane?

Common Features

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 2: Access: Introduction to Powerpoint

When you enter a field into a database, you are entering ________.

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

How would you sort records in a field so that the oldest birthday is listed first?

Match the following terms with their description: i. Navigation Pane II. Object III. Primary key IV. Record v. Relationship

Which of the following is not a valid comparison operator?

The ________ command helps you locate specific records.

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

When you split a database, what object type is put in the back end?

What is not true about field properties?

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

How many records do most forms display?

Using the Back Up Database utility only saves the structure of the database, not the content.

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.

Filters do not delete data or records.

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

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

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

Match the following terms with their description: i. Table II. Record III. Form IV. Report v. Query

How can you toggle viewing the Navigation Pane?

Common Features

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Introduction to Excel

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters