NURSING > QUESTIONS & ANSWERS > Access week 8 exam.docx go ahead docs solution questions and answers (All)

Access week 8 exam.docx go ahead docs solution questions and answers

Document Content and Description Below

Access week 8 exam.docx go ahead docs solution questions and answers Question 1 5 / 5 pts (CO 1) Databases create business values by Correct! Question 2 5 / 5 pts (CO 1) In what situation would Access be a better choice than Excel? Question 3 5 / 5 pts (CO 1) When creating a report in Access, what report tool best outlines the following description? This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given. Question 4 0 / 5 pts (CO 1) Filters are used to do all of the following except Question 5 0 / 5 pts (CO 1) The number of sections Access creates for a report is Question 6 5 / 5 pts (CO 2) Which of the following is NOT a database system? Question 7 5 / 5 pts (CO 2) A symbol used in ER diagrams for an entity is a Question 8 5 / 5 pts (CO 3) Which relationship is used most commonly within the database environment? Question 9 5 / 5 pts (CO 3) Attributes are better defined as Question 10 5 / 5 pts (CO 3) A good recommendation for a primary key in a customer table is Question 11 0 / 5 pts (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. Question 12 0 / 5 pts (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? Question 13 5 / 5 pts (CO 5) Clicking on the form tool will open a(n) Question 14 0 / 5 pts (CO 6) Which of the following is a term used to describe a calculated field? . Question 15 0 / 5 pts (CO 6) Data aggregate functions Question 16 0 / 5 pts (CO 9) Normalization improves organization. Question 17 5 / 5 pts (CO 2) A required field that is used in entering data is a field that Question 18 5 / 5 pts (CO 8) The switchboard manager is an Access utility that is used Question 19 0 / 5 pts (CO 9) A database documenter tool will Question 20 5 / 5 pts (CO 9) Database security is a specialty within computer security that protects a database application from unintended use. Unintended use includes Question 21 5 / 5 pts (CO 10) The table analyzer tool does this for your database. Correct! Question 22 0 / 5 pts (CO 4) Which statement below is NOT true of the one-to-many relationships in the database description below? Question 23 40 / 40 pts (CO 1) Explain the organization of data in relational databases in terms of tables, records (rows), and fields (columns). Give an example of a table and specify its fields. Which field(s) would you choose as the primary key of that table? Question 24 40 / 40 pts (CO 2) Explain entity integrity and referential integrity. Give an example of each. Question 25 40 / 40 pts (CO 4) Explain the terms entity and attribute. Describe an example of an entity and then list two attributes. Using your examples, explain the data types that would be used to capture the attributes. Question 26 40 / 40 pts (CO 4) What is a relational database management system, and how does it relate to a database administrator?

[Show More]

Last updated: 3 years ago

Preview 1 out of 15 pages

Buy Now

Instant download