BIS 245 To exceed, you must read/Uophelpdotcom - PowerPoint PPT Presentation

About This Presentation

Title:

BIS 245 To exceed, you must read/Uophelpdotcom

Description:

Number of Views:3

Slides: 14

Provided by: Reddy4

Category: How To, Education & Training

Tags: checkpoints | dqs | entirecourse

Transcript and Presenter's Notes

Title: BIS 245 To exceed, you must read/Uophelpdotcom

1
BIS 245 To exceed, you must read/Uophelpdotcom

2
BIS 245 Final Exam (Keller)

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 (Keller)

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-7 All Discussion Questions
(Keller)

5
BIS 245 Week 1-7 All Labs (Keller)

6
BIS 245 Week 2 Lab - Skills Development in Visio
(Keller)

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.

7
BIS 245 Week 3 Lab - Visio ERD (Keller)

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. Uponcom
pletingthislab, youwillbeableto
create a new Visio file for database design
using the data requirements and the business
rules provided, develop a conceptual model (ERD),
including attribute data types and required field
lengths and create a new MS Access database
based on the ERD

8
BIS 245 Week 4 Lab - ER Diagram (Keller)

For more course tutorials visit
www.uophelp.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)
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 - ER Diagram and ER Matrix
(Keller)

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 (Keller)

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.