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.