BIS245 Final Exam New Version

BIS245 Final Exam New Version

Author: Abraham Nolito


(TCO 1) Which of the following is NOT an Access interface element? (Points : 5)
Navigation Pane
Status Bar
Title Bar

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)
report tool.
report design.
report wizard.
blank report.
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)
Datasheet Form
Multiple Items Form
Split 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)

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.