Bis 245 final exam 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...

BIS 245 A Small Surgery Center Case Study Week 3 & Week 5 |iLab Week 1-7|Quiz Week 1-6| Discussions Week 1-7, 2 Sets|Final Exam BIS 245 A Small Surgery Center Case Study Week 3 & Week 5 Scenario 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 ...

BIS 245 Week 8 Final Exam

BIS 245 Final Exam

BIS 245 Final Exam Answer (Updated) 1. Question : (TCO 1) Which object would you use to enter, delete, or modify data? Criteria Form Query Table 2. Question : (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Criteria Form Query Table 3. Question : (TCO 1) To design a report you should do all of the following EXCEPT draw a paper design of the report. identify all sources of data, fields and groups. input the data. select a reporting tool. 4. Ques...

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 calculation. You have an extensive amount of data. You need to maintain constant connectivit...

BIS 245 Final Exam Study Guide Fields - ANS the smallest data element of a table, such as first name, last name, address, or phone number. Records - ANS a group of related fields representing one entity, such as data for one person, place, event, or concept. Tables - ANS An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database. Databases - ANS A collection of data o...

BIS 245 Database Essent for Busn Lab Final Exam Questions and Answers

BIS 245 Database Essent for Busn Lab Final Exam Questions and Answers

BIS 245 Final Exam Study Guide Fields - Answer the smallest data element of a table, such as first name, last name, address, or phone number. Records - Answer a group of related fields representing one entity, such as data for one person, place, event, or concept. Tables - Answer An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database. Databases - Answer A collection o...