(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)
Question 4.4. (TCO 6) Using the rules for order of operations, what is the result of the following expression: (4 * 3) +1 + 4 – 2 * 3 + 5 ? (Points : 5)
Question 5.5. (TCO 7) Which term best describes demographics? (Points : 5)
It is a bar code on a card that contains information about you.
It defines population into segmented groups such as age, income, gender, and race.
It is the quantity of merchandise a store will purchase.
It is tracking customer purchases.
Question 6.6. (TCO 7) Discrete data (Points : 5)
are easily scaled.
are used to measure time or money.
cannot be subdivided into meaningful information.
may be subdivided into smaller and smaller units.
Question 7.7. (TCO 8) All of the following describe a Navigation Form EXCEPT (Points : 5)
click the Create tab and then Navigation in the Forms group to create a Navigation form.
is another term for a Switchboard Manager.
helps users open forms and reports.
has the look and feel of a Web form.
Question 8.8. Of the following security techniques available in Microsoft Access to keep a database application safe, which choice would make the database virtually impossible to break into: (Points : 5)
Creating a menu system
Encrypting and password-protecting the database
Digitally signing and publishing the database
Saving the database as an ACCDE file
Question 9.9. (TCO 9) Database security is a specialty within computer security that protects a database application from unintended use. Unintended use includes: (Points : 5)
unauthorized viewing of data
inadvertent mistakes made by employees
all of the above
Question 10.10. (TCO 10) After creating an ACCDE file, you (Points : 5)
can convert it back to its source format.
will see a “file already in use” message that continues to display to all other users.
will be able to modify forms and reports but not tables.
will need to go back to the original file if an underlying object requires a change.
Question 11.11. (TCO 4) Which of the following is NOT true of a ship date field? (Points : 5)
A ship date is considered a constant.
A ship date would be defined as a date/time field.
A ship date would be defined as a calculated field.
Date arithmetic can be applied to a ship date field.
1. (TCO 1) Let’s imagine this scenario. Development of a database system is about to start. Before development actually starts, the Director of Systems Development asks you to evaluate the database schema design and report your observations. Given this scenario what would you look for? Please discuss and explain. (Points : 40)
Question 2. 2. (TCO 2) What is a conceptual model? Explain its importance. Conceptual models are typically made up of three main parts. Name these parts giving a full definition and purpose. Give two possible examples of each part. (Points : 40)
Question 3. 3. (TCO 4) What are the advantages and disadvantages of de-normalization process. (Points : 40)
Question 4. 4. (TCO 4) Explain 1NF, 2NF, and 3NF as related to database design. (Points : 40)