BIS 245 Education Begins/newtonhelp.com

1
BIS 245 Education Begins/newtonhelp.com
2
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Entire Course (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• BIS 245 Week 1-7 All Discussion Questions
•  
• BIS 245 Week 1 Lab 1 Introduction to MS Visio and
  MS Access
•  
• BIS 245 Week 2 Lab - Skills Development in Visio
•  
• BIS 245 Week 3 Lab - Visio ERD
•  
• BIS 245 Week 4 Lab - ER Diagram
•  
• BIS 245 Week 5 Lab - ER Diagram and ER Matrix
•  

3
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Final Exam (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
• (TCO 1) Which object would you use to enter,
  delete, or modify data?
• (TCO 1) Which object would you use to retrieve
  customers who live in Germany and the United
  States?
• (TCO 1) To design a report you should do all of
  the following EXCEPT
• (TCO 1) Which of the following is NOT a Report
  Section?

4
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 1 Lab 1 Introduction to MS Visio and
  MS Access (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• A. Lab BSBA BIS 245A-1B. Lab 1 of 7
  Introduction to MS Visio and MS AccessC. Lab
  Overview--Scenario/Summary
• TCOs1. Given a business situation in which
  managers require information from a database,
  determine, analyze and classify that information
  so that reports can be designed to meet the
  requirements.

5
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 1-7 All Discussion Questions
  (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• Week 1 DQ 1 - Databases and Gathering
  Requirements
• Week 1 DQ 2 - Choosing a Database
• Week 2 DQ 1 - Entity Relationship (ER) Modeling

6
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 1-7 All Labs (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• BIS 245 Week 1 Lab 1 Introduction to MS Visio and
  MS Access
• BIS 245 Week 2 Lab - Skills Development in Visio
•  
• BIS 245 Week 3 Lab - Visio ERD
•  
• BIS 245 Week 4 Lab - ER Diagram
•  
• BIS 245 Week 5 Lab - ER Diagram and ER Matrix

7
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 2 Lab - Skills Development in Visio
  (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• A. Lab BSBA BIS 245A-2
• B. Lab 2 of 7 Skills Development in Visio
  Creation of MS Access Database
• C. Lab Overview--Scenario / Summary
• TCOs
• 1. Given a business situation in which managers
  require information from a database, determine,
  analyze, and classify that information so that
  reports can be designed to meet the requirements.
• 2. Given a situation containing entities,
  business rules, and data requirements, create the
  conceptual model of the database using a database
  modeling tool.

8
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 3 Lab - Visio ERD (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• Lab 3 of 7 Database Design Using Visio and Based
  on Data Requirements and Business Rules
• You have been asked to create a database model
  using MS Visio Database Model Diagram Template. 
  The purpose of this lab is to provide experience
  designing, with limited instructions, a simple
  database based on a list of data requirements and
  associated business rules.
• You will then complete an MS Access database
  based on the model developed in Visio, creating
  the necessary tables and relationships. 

9
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 4 Lab - ER Diagram (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• Page 1 of 5
•  A. Lab BSBA BIS 245A-4A
•  B. Lab 4A of 7 Database design based on data
  requirements and business rules focusing on
  interpreting business rules to determine
  relationships.
•  C. Lab Overview --Scenario/Summary
•  TCO(s)

10
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 5 Lab - ER Diagram and ER Matrix
  (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• A. Lab BSBA BIS 245A-5A
• B. Lab 5A of 7 Database design using Visio, and
  based on data requirements
• and business rules focusing on normalizing data
  to third normal form.
• C. Lab Overview--Scenario/Summary
• TCO(s)
• 2. Given a situation containing entities,
  business rules, and data requirements,
• create the conceptual model of the database using
  a database modeling tool.

11
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 6 iLab Creating Reports (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• A. Lab BSBA BIS 245A-6B. Lab 6 of 7 Creating
  ReportsC. Lab Overview Scenario / Summary
• TCO(s) 7. Given a database application with a
  completed relational schema, populated tables,
  and business reporting requirements, create the
  necessary reports and make a business decision.
• Scenario The purpose of this lab is to create
  Access Reports.

12
BIS 245 Education Begins/newtonhelp.com

• BIS 245 Week 7 iLab University (Keller)
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
•  
• BIS 245 Week 7 iLab University

13
BIS 245 Education Begins/newtonhelp.com