BIS 245 WEEK 1 LAB 1 INTRODUCTION TO MS VISIO AND MS ACCESS (KELLER),Devry University: GRADED A | 100% CORRECT
2 views 0 purchase
Course
BIS 155 (BIS245)
Institution
DEVRY UNIVERSITY
BIS 245 WEEK 1 LAB 1 INTRODUCTION TO MS VISIO AND MS ACCESS (KELLER),Devry University: GRADED A | 100% CORRECTBIS 245 WEEK 1 LAB 1 INTRODUCTION TO MS VISIO AND MS ACCESS (KELLER),Devry University: GRADED A | 100% CORRECTBIS 245 WEEK 1 LAB 1 INTRODUCTION TO MS VISIO AND MS ACCESS (KELLER),Devry Univ...
bis 245 week 1 lab 1 introduction to ms visio and ms access keller
Written for
DEVRY UNIVERSITY
BIS 155 (BIS245)
All documents for this subject (20)
Seller
Follow
NURSINGUNIVERSITYWALDEN
Reviews received
Content preview
BIS 245 WEEK 1 LAB 1 INTRODUCTION TO MS VISIO
AND MS ACCESS (KELLER)
A. Lab #: BSBA BIS245A-1
B. Lab 1 of 7: Introduction to MS Visio and MS Access
C. Lab Overview—Scenario/Summary
COs:
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.
Scenario:
You have been asked to create two conceptual database models using MS Visio
database notation template. The purpose of this lab is to have you gain familiarity with
the various modeling tools needed to create a conceptual model (entity-relationship
diagram or ERD) of a database. You will create two conceptual models.
You will then open an existing access database to explore database objects and to
experiment with simple data manipulation using filters and sorts and to begin
elementary work with relationships.
Upon completing this lab, you will be able to
1. relying on detailed instructions, create a simple conceptual model for a two-table
database using MS Visio;
2. use experience gained in creating the first model to construct a similar
conceptual model without the instructions; and
3. download an existing Microsoft Access database file. Open the database; find
and identify different database objects in this database.
D. Deliverables
Section Deliverable Points
Part B Step 4 YourName_Lab1.vsdx (Visio Diagram)
Part C Step 8 YourName_Lab1C_ScreenPrints.docx
E. Lab Steps
,Preparation
1. Download the database file.
a. Download Lab1_Nwind.accdb file from the Week 1 Lab page, and save the
file to your local drive.
b. Create a new MS Word document named Lab1C_ScreenPrints.docx from the
Week 1 Lab page, and save the file to your local drive.
2. Using Citrix for MS Visio and/or MS Access
a. If you are using the Citrix remote lab, follow the login instructions located in
the lab area in Introduction and Resources.
b. You will have to upload the Lab1_NWind.accdb file to your Citrix drive. Follow
the instructions for uploading files to Citrix, located in the lab area in the
Introduction and Resources area.
Lab
Part A: Become Familiar With MS Visio
Step 1: Locate the Microsoft Office Applications
a. If you are using Cirtix, click on the Microsoft Office applications folder.
b. If you are using Visio on a local computer, select it from your program list. You
may need to select Microsoft Office from your program menu, and then select
Visio.
Step 2: Start Visio
a. Click on Microsoft Visio and it should open like the following screen. Notice that
the list of diagrams is shown. At the upper left-hand side, there are two tab
options: featured and categories. Click on the categories section, as shown
circled in red below.
, b. Select the database and software option from the categories listed, as seen
below.
c. From the template categories, click to select the software and database category.
See the next screen capture. The database notation diagram template is
selected.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller NURSINGUNIVERSITYWALDEN. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
