1. (TCO 1) To delete the filter shown below
click Filter in the Sort & Filter group and select Clear Filter.
click Remove Filter in the Sort & Filter group.
right click on any number in the Quantity column and select Clear filter from Quantity.
right click on any record in the table and select Clear filter from Quantity.
2. (TCO 1) In what situation would Excel be a better choice than Access?
You have a limited amount of data.
You have an extensive amount of data.
You need to maintain constant connectivity to an external database.
You require a relational view of your data.
3. (TCO 1) To design a report you should do all of the following EXCEPT
draw a paper design of the report.
identify all sources of data, fields and groups.
input the data.
select a reporting tool.
4. (TCO 1) Which of the following is NOT a Report Section?
Detail
Group Footer
Page Footer
Summary
5. (TCO 1) A report creation tool that will automatically pull in the fields from a table or query is the
report tool.
report design.
report wizard.
blank report.
6. (TCO 2) A field that uniquely identifies each record in a table is a
link.
relationship.
primary key.
foreign key.
7. (TCO 2) Which of the following is supported by a primary key?
Changeable over time
May be null
Unique
Updateable
8. (TCO 3) All of the following apply to the relationships image found below EXCEPT
a one-to-many relationship is found between the Suppliers table and the Products table.
a relationship exists between the two primary keys of the Suppliers table and the Products table.
one table is not joined to the two other tables.
the primary key for the Categories table is CategoryID.
9. (TCO 3) The following data type would appear as a checkbox in a table.
Attribute
Number
Text
Yes/No
10. (TCO 3) Which of the following is NOT true of a property?
A property is an object's characteristic or attribute.
Tables, forms, queries, and reports have a set of properties.
A property sheet is used to make changes.
Design properties are displayed in Datasheet View.
11. (TCO 4) Which function is used to isolate a specific portion of a date such as year, month, or day in a date field?
Date
DateDiff
DateParse
DatePart