BIS 245 Academic Achievementuophelp

1
BIS 245 Academic Achievement/uophelp

• For more Academic Achievement/uophelps visit
• www.uophelp.com

2
BIS 245 Academic Achievement/uophelp

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

• BIS 245 Final Exam

• 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.

• 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 Academic Achievement/uophelp

• BIS 245 Week 2 Lab

• BIS 245 Week 1

• 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.

• 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

4
BIS 245 Academic Achievement/uophelp

• BIS 245 Week 3 Lab

• BIS 245 Week 2

• 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.

• 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

5
BIS 245 Academic Achievement/uophelp

• BIS 245 Week 5 Lab

• BIS 245 Week 4 Lab

• 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.

• 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

6
BIS 245 Academic Achievement/uophelp

• BIS 245 Week 7 iLabDevry University

• BIS 245 Week 6 iLab Creating Reports

• BIS 245 Week 7 iLabDevry University

• 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.

7
BIS 245 Academic Achievement/uophelp

• BIS 245 Week Entire Course

• 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
•  BIS 245 Week 7 iLabDevry University

8
BIS 245 Academic Achievement/uophelp
For more Academic Achievement/uophelps
visit www.uophelp.com