*NURSING > QUESTIONS & ANSWERS > BIS245 WEEK 8: FINAL EXAM solution complete 100% approved questions and answers docs (All)

BIS245 WEEK 8: FINAL EXAM solution complete 100% approved questions and answers docs

Document Content and Description Below

BIS245 WEEK 8: FINAL EXAM solution complete 100% approved questions and answers docs Question 1 5 / 5 pts (CO 1) A primary key is Question 2 5 / 5 pts (CO 1) What Microsoft Access feature w ... ould give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the total revenue generated from UPS Express box large in November 2017?” Question 3 0 / 5 pts (CO 1) Which one of the following tools is the quickest way to create a tabular report in MS Access based on the selected table or query? Question 4 5 / 5 pts (CO 1) Most of the printed documents generated by managers using Access will come from Question 5 3 / 5 pts (CO 1) A Report section that is used to summarize grouped field data is Question 6 5 / 5 pts (CO 2) A table is also recognized as a(n) Question 7 1 / 5 pts (CO 2) SQL is a fourth-generation language that is Question 8 5 / 5 pts (CO 3) Which of the following should be considered when designing a database? Question 9 5 / 5 pts (CO 3) The following data type would appear as a checkbox in a table. Question 10 5 / 5 pts (CO 3) Which of the following does NOT describe a caption property? Question 11 5 / 5 pts (CO 4) Which of the following does NOT describe the following description of a one-to-one relationship? FE_IMG55.jpg Description: Image Description: There are two tables. Table number 1 is named Employees and has a primary key of EmpID with fields: LastName, FirstName, and Salary. Table number 2 is named NewEmployees and has a primary key of EmpID with fields of LastName, FirstName, and Hiring Expenses. The two tables are related with a line. The line has no symbols. Question 12 5 / 5 pts (CO 5) To edit a form, use Question 13 5 / 5 pts (CO 5) The following are form creation tools except Question 14 5 / 5 pts (CO 6) Queries are objects in a database based on one or more underlying Question 15 2 / 5 pts (CO 6) The benefit of a relationship is to determine which fields to include in each table. Question 16 5 / 5 pts (CO 9) A deletion anomaly is Question 17 2 / 5 pts (CO 2) Which of the following statements best describes data mining? Question 18 5 / 5 pts (CO 8) A navigation form is a Question 19 0 / 5 pts (CO 9) An encrypted file is Question 20 5 / 5 pts (CO 9) A digital signature Question 21 5 / 5 pts (CO 10) After creating an ACCDE file, you Question 22 5 / 5 pts (CO 4) The term cascading refers to Question 23 40 / 40 pts (CO 1) Describe three-tier architecture. Explain the functions performed by each tier. Question 24 14 / 40 pts (CO 2) Explain the purpose of a conceptual database model, and describe the most common method of creating one. 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) If you were given an ERD that contained a M:N relationship between orders and products, what would you need to do in order to create the tables and relationship in Access? [Show More]

Last updated: 3 years ago

Preview 1 out of 11 pages

Buy Now

Instant download

We Accept: