BIS245/ BIS245 WEEK 4 QUIZ (A+++++ ANSWER)

Question 1. 1.(TCO 1) Data aggregates (Points : 4)
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. 2.(TCO 2) All of the following are Access data types EXCEPT (Points : 4)
autonumber.
date/time.
number.
string.
Question 3. 3.(TCO 2) Which of the following is NOT true of a single-table query? (Points : 4)
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. 4.(TCO 2) Access has __________ data types. (Points : 4)
six
eight
10
12
Question 5. 5.(TCO 2) The command language used with relational databases is (Points : 4)
PNPI
RDBMS
SQL
tuple.
Question 6. 6.(TCO 2) Another term for an expression is (Points : 4)
formula.
function.
parameter.
query.
Question 7. 7.(TCO 2) A function used to isolate a specific portion of a date such as year month or day in a date field is (Points :4)
Date.
DateDiff.
DateParse.
DatePart.
Question 8. 8.(TCO 2) A primary key (Points : 4)
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. 9.(TCO 6) A parameter query is (Points : 4)
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. 10.(TCO 6) Which of the following is true about a crosstab query? (Points : 4)
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.