Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Access_week_8_exam graded Awith complete solutions latest 2025/2026
Typology: Exams
1 / 30
This page cannot be seen from the preview
Don't miss anything!
(CO 1) Databases create business values by All of the above facilitating transaction processing. storing business data. providing data for decisions support systems. (CO 1) In what situation would Access be a better choice than Excel? You have a limited amount of data. You have an extensive amount of data. You need to conduct extensive statistical analyses on your data.
You require a flat file view of your data.
it does not matter whether you apply a filter or a sort first.
filter effects are cumulative. See Chapter 2: (Grauer) Microsoft Access 2016 Comprehensive. (CO 1) The number of sections Access creates for a report is Correct Answer five. four. three. six. See Chapter 4: (Grauer)Microsoft Access 2016 Comprehensive. (CO 2) Which of the following is NOT a database system? Network
Relational Hierarchical (CO 2) A symbol used in ER diagrams for an entity is a line. box. triangle. diamond. (CO 3) Which relationship is used most commonly within the database environment?
Two-to-one relationship.
customer address.
customer last name. customer designated ID. customer phone number. (CO 4) In a dependency, a relationship exists when one attribute uniquely identifies another attribute. For example, if we had a table consisting of the following attributes: instructor, course, time, and room number. Course would uniquely identify an instructor. Correct Answer functional referential transitive structural
(CO 5) Which form type displays records in a tabular format similar to a datasheet view but has more editing options, such as adding graphics? Split form Datasheet form Multiple items form Correct Answer Subform See Chapter 4: (Grauer) Microsoft Access 2016 Comprehensive. (CO 5) Clicking on the form tool will open a(n) new form in design view. existing form.
new form in layout view.
cannot be used on a row. Correct Answer
perform calculations on entire columns of data. are used to perform calculations on individual records in a table or query. See Chapter 3: (Grauer) Microsoft Access 2016 Comprehensive. (CO 9) Normalization improves organization. Correct Answer All of the above easier to modify. flexibility. See Chapter 3: Kroenke & Auer Text.
can be left blank. cannot be left blank. appears with a specific value. (CO 8) The switchboard manager is an Access utility that is used to make certain objects unavailable to some users and available to others. by all database users. to create and manage the menu items for a switchboard. to manage and optimize the database.
(CO 9) A database documenter tool will
