BIS 245 Experience Tradition/uophelp.com - PowerPoint PPT Presentation

About This Presentation
Title:

BIS 245 Experience Tradition/uophelp.com

Description:

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? (TCO 2) A symbol used in ER diagrams for an entity is a – PowerPoint PPT presentation

Number of Views:7
Slides: 14
Provided by: FisherFarrar

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com