Access week 8 exam new solution complete doc

Document Content and Description Below

Access week 8 exam new solution complete doc 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 bett... er 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 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. Question 22 0 / 5 pts (CO 4) Which statement below is NOT true of the one-to-many relationships in the database description below? Description: Image Description: Three tables are pictured: Table 1: Order details with primary keys of OrderID and ProductID and fields: UnitPrice, Quantity, and Discount. Table 2: Orders with an OrderID primary key and fields of CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, and ShipCountry. Table 3: Customer has a primary key of CustomerID, Fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, and Fax. There is a relationship labeled with the infinity symbol attached to the OrderDetails (Table 1) and also attached with a number 1 to the orders table (Table 2). There is also a relationship with the infinity symbol beginning at orders table (Table 2) and connected to the customers table (Table 2) using a 1. 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? Quiz Score: 225 out of 270 [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages