(TCO 1) Which of the following is NOT an Access interface element? (Points : 5)
Question 4.4. (TCO 1) Filters are used to do all of the following EXCEPT (Points : 5)
a filter can be removed by selecting Remove Filter from the Sort & Filter group.
all records in a table will be displayed if all of the filters are removed.
filter effects are cumulative.
it does not matter whether you apply a filter or a sort first.
Question 5.5. (TCO 1) A report creation tool that will automatically pull in the fields from a table or query is the (Points : 5)
Question 6.6. (TCO 2) Which of the following is not a database system? (Points : 5)
Question 7.7. (TCO 3) Which of the following should be considered when designing a database? (Points : 5)
How calculated fields are used
Store data in its smallest parts
The relationship between attribute keys
The relationships between records
Question 8.8. (TCO 3) All of the following describe a caption property EXCEPT (Points : 5)
allows for placing spaces between words.
can take the place of a field name in Datasheet View.
can be used in place of a field name in an expression.
the caption appears in Datasheet, Report, and Form views.
Question 9.9. (TCO 3) All of the following summarize characteristics of a PivotTable EXCEPT (Points : 5)
can display information that is typically found in Datasheet totals.
can only be created from a table.
data is organized and summarized in an easy-to-read view.
is created by dragging fields from a field list into appropriate drop zones.
Question 10.10. (TCO 3) Which of the following does NOT describe a caption property? (Points : 5)
A label can substitute for a field name in Datasheet View.
The caption appears in Datasheet View, Form, and Report.
The label allows spaces between words.
The label can be used in place of a field name in an expression.
Question 11.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? (Points : 5)
1. (TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics? (Points : 5)
Multiple Items Form
Question 2.2. (TCO 5) A bound control (Points : 5)
always contains a label.
contains text and number values entered by the user.
is unique and contains a data field from another underlying source.
must contain a formula.
Question 3.3. (TCO 6) Which of the following is a term used to describe the names of controls, fields, or properties? (Points : 5)