Question 1. Data aggregates

are used to perform calculations on individual records in a table or query.
cannot be used in a report.
perform calculations on entire columns of data.
return multiple values.

Question 2. All of the following are Access data types EXCEPT

autonumber.
date/time.
number.
string.

Question 3. Which of the following is NOT true of a single-table query?

It can be created using the Simple Query Wizard.
Queries can be created using the Query Design Tool.
You can overwrite Table data using the Datasheet View of a Query.

The top portion of the Query Design View displays the fields and criteria.

Question 4. Access has __________ data types.

six
eight
10
12

Question 5. The command language used with relational databases is

PNPI
RDBMS
SQL
tuple.

Question 6. Another term for an expression is

formula.
function.
parameter.
query.

Question 7. A function used to isolate a specific portion of a date such as year, month, or day in a date field is

Date.
DateDiff.
DateParse.
DatePart.

Question 8. A primary key

can be computer generated.
consists of one field only that uniquely identifies each record in a table.
is a relationship between two or more tables.
All of the above

Question 9. A parameter query is

a select query where the user provides the criterion at run time.
an action query used to modify data.
an aggregate query used to summarize field data.
used to backup databases.

Question 10. Which of the following is true about a crosstab query?

It is an action query.
It is used to retrieve parameter data.
It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns.
It summarizes unmatched records from a data source.