Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Access is a ________ product.

Accepted Answer

A)  Microsoft 
B)  Google 
C)  Yahoo 
D)  Corel 
A)  Microsoft 
B)  Google 
C)  Yahoo 
D)  Corel

Question 3

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 4

DBMS stands for ________.

Accepted Answer

database m

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

You can only sort records by one field.

Accepted Answer

A) True 
 B)False

Question 7

A module uses what programming language?

Accepted Answer

A)  SQL 
B)  VBA 
C)  VBL 
D)  HTML 
A)  SQL 
B)  VBA 
C)  VBL 
D)  HTML

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

Access is a ________ product.

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

DBMS stands for ________.

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

You can only sort records by one field.

A module uses what programming language?

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

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

Access is a ________ product.

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

DBMS stands for ________.

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

You can only sort records by one field.

A module uses what programming language?

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