Bis245 week 1 Study guides, Class notes & Summaries

BIS245/ BIS 245 FINAL EXAM. Practice tested exam questions and answers scored 75 out of 270 points Score for this quiz: 75 out of 270 * Submitted Aug 26 at 1:20pm This attempt took 102 minutes. (CO 1) MS Visio is used during database design for the following reasons. It calculates formulas. It depicts entities and relationships between entities. It sets reports. It can query information. (CO 1) In a table, the view is where you add, edit, and delete rec...

BIS245 WEEK 8 Final Exam / BIS245 WEEK 8 FINAL EXAM 2023. A primary key is a field or set of fields that uniquely identifies a record. a key that uniquely identifies columns in a table. Correct! the key used to uniquely identify a record in a table. a nonunique value. Question 2 5 / 5 pts (CO 1) What Microsoft Access feature would 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 re...

BIS245 WEEK 8 Final Exam / BIS245 WEEK 8 FINAL EXAM. A primary key is a field or set of fields that uniquely identifies a record. a key that uniquely identifies columns in a table. Correct! the key used to uniquely identify a record in a table. a nonunique value. Question 2 5 / 5 pts (CO 1) What Microsoft Access feature would 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...

BIS245 WEEK 8 Final Exam / BIS245 WEEK 8 FINAL EXAM 2022-2023. A primary key is a field or set of fields that uniquely identifies a record. a key that uniquely identifies columns in a table. Correct! the key used to uniquely identify a record in a table. a nonunique value. Question 2 5 / 5 pts (CO 1) What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the tot...

BIS245 Final Exam BIS245 Final Exam COMPLETED WITH 100% Correct answers BIS245 Final Exam Question 1 (CO 1) A foreign key is a value that can connect two tables simultaneously. a unique value that identifies each row within a table. another name for a candidate key. a field in one table that is also the primary key of another table. Question 2 (CO 1) In what situation would Excel be a better choice than Access? You have a limited amount of data or must do a complicated c...

BIS 245 iLab Week 6 BIS245 iLab Week 6 Scenario/Summary The purpose of this lab is to create Access reports. After a report is created, the student will sort the fields in different ways. The student can also delete fields in layout view and modify the appearance of the report by applying themes. In addition to the report generated by Access, the lab also uses report design to allow users to design their own reports. Upon completing this lab, you should be able to create a report an...

BIS 245 iLab Week 6 BIS245 iLab Week 6 Scenario/Summary The purpose of this lab is to create Access reports. After a report is created, the student will sort the fields in different ways. The student can also delete fields in layout view and modify the appearance of the report by applying themes. In addition to the report generated by Access, the lab also uses report design to allow users to design their own reports. Upon completing this lab, you should be able to create a report and apply a the...

BIS245 WEEK 1: QUIZ practice weekly questions and answers (CO 1) A database management system (DBMS) is a collection of programs that store data. manage data. use collections of data. All of the above (CO 1) Which statement is NOT true? A relationship is a connection between two tables using a common field. A primary key is used to identify common fields in a table. Multiple users on different computers can work on a database simultane...

BIS245 WEEK 8: FINAL EXAM 2022 a grade Question 1 5 / 5 pts (CO 1) A primary key is a field or set of fields that uniquely identifies a record. a key that uniquely identifies columns in a table. Correct! the key used to uniquely identify a record in a table. a nonunique value. Question 2 5 / 5 pts (CO 1) What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the to...

BIS 245 Case Study Guide: Small Surgery Center: DeVry University, Chicago BIS245 Case Study Guide: Small Surgery Center: DeVry University, Chicago A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments. 1. Please identify the attributes and primary keys needed for each of the entities. 2. Identify the data types you would use for each of the attributes. 3. Determine th...