BIS 245 Experience Tradition/uophelp.com

1
BIS 245 Experience Tradition/uophelp.com

• For more course tutorials visit
• www.uophelp.com

2
BIS 245 Final Exam

• For more course tutorials visit www.uophelp.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?
• (TCO 1) A Detail line is used to
• (TCO 2) For the following image, which of the
  following is TRUE?

3
BIS 245 Week 1 Lab 1 Introduction to MS Visio and
MS Access

• For more course tutorials visit www.uophelp.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.2. Given a situation containing
  entities, business rules, and data requirements,
  create the conceptual model of the database using
  a database modeling tool

4
BIS 245 Week 1

• For more course tutorials visit www.uophelp.com
• Week 1 DQ 1 - Databases and Gathering
  Requirements
• Week 1 DQ 2 - Choosing a Database
• Week 2 DQ 1 - Entity Relationship (ER) Modeling
• Week 2 DQ 2 - Database Table Design
• Week 3 DQ 1 - Conceptual Database Design
• Week 3 DQ 2 - Requirements Analysis
• Week 4 DQ 1 - Creating Queries from Woodcraft
  Database
• Week 4 DQ 2 - Creating Queries from Northwind
  Database

5
BIS 245 Week 2 Lab

• For more course tutorials visit www.uophelp.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.

6
BIS 245 Week 2

• For more course tutorials visit www.uophelp.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 
• BIS 245 Week 6 iLab Creating Reports 
• BIS 245 Week 7 iLabDevry University

7
BIS 245 Week 3 Lab

• For more course tutorials visit www.uophelp.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. 

8
BIS 245 Week 4 Lab

• For more course tutorials visit www.uophelp.com
• 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)
•  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.

9
BIS 245 Week 5 Lab

• For more course tutorials visit www.uophelp.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.

10
BIS 245 Week 6 iLab Creating Reports

• For more course tutorials visit www.uophelp.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. After a report is created, the
  student will sort the fields in different ways.
  Also 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 theme for
  professional appearance of the report. Use
  Report Design to generate your own report.

11
BIS 245 Week 7 iLabDevry University

• For more course tutorials visit www.uophelp.com
• BIS 245 Week 7 iLabDevry University

12
BIS 245 Week Entire Course

• For more course tutorials visit www.uophelp.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 
• BIS 245 Week 6 iLab Creating Reports

13
BIS 245 Experience Tradition/uophelp.com

• For more course tutorials visit
• www.uophelp.com