A. Lab BSBA BIS245A-4

 

B. Lab 4 of 7: Completing Queries (40 Points)

 

C. Lab Overview--Scenario/Summary

COs:

6. Given a physical database containing tables and relationships and business requirements, create the necessary queries.

 

Scenario/Summary

 

We can collect all the data in the world; however, if we can’t access it and use it, it is probably useless. Gaining knowledge from stored data can be very beneficial when it comes to making important business decisions. This lab will give the student practice in querying or questioning data. The lab begins with a simple example of query development using Access, then evolves to more complex queries which the student should perform after completing the first exercise. The student can create a query with the wizard or with query design view.

 

Upon completing this lab, you should be able to

 

1. create a query by following lab instruction;

2. create a query by using either query designer, or query wizard; and

3. interpret and analyze the results of queries.

 

D. Deliverables

 

Submit the MS Access database file YourName_Lab4.accdb that contains the queries created in this lab.

Step	Deliverable	Points
Part A Steps 1-3	3 queries: Supplier Contacts      High Value Products      Product Recalls	24
Part B Steps 1-2	2 queries: Extended Order Prices      Order Fulfillment Time	16

 

E. Lab Steps

Preparation

1.      Download the file Lab4.accdb from the link provided on the Lab Overview page-> Lab Files.

2.      If you are using Citrix for MS Visio or MS Access, follow the login instructions located in the Lab area in the Introduction and Resources, and upload the Lab4.accdb file to your working folder on the Citrix server. (You can see a video about how to do this by clicking the link Saving From Citrix under Citrix Tutorials from Course Resources link listed at the bottom of the Modules page.)

 

Attachments:

• 1551549996-BIS245_W4_Lab_Instructions_RW3v2.docx