DeVry BIS 245 Week 4 ILAB Database Essentials for Business with Lab

 IF You Want To Purchase A+ Work Then Click The Link Below  , Instant Download

http://www.hwspeed.com/BIS-245-Week-4-ILAB-Database-Essentials-for-Business-With-LAB-759458498.htm?categoryId=-1

If You Face Any Problem E- Mail Us At  JOHNMATE1122@Gmail.Com

week 4

BIS245 Database Essentials for Business with Lab

A.Lab # : BSBA BIS245A-4B

B.Lab 4B of 7:Completing Queries

C.Lab Overview – Scenario / Summary:

TCOs:

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

Scenario/Summary

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, with query design view, or with SQL statements. The Northwind database will be used again in this lab.

Upon completing this lab, you should be able to:

• Create a query by following lab instruction.

• Create a query by using either query designer, or query wizard.

• Create a query by using SQL statements.

• Interpret the results of queries

D.Deliverables:

Submit the MS Access Database file that contains the queries created in this lab.

Step	Deliverable	Points
1	Query #1 – step-by-step
2	Query #2 – Compound Statements
3	Query #3 – Suppliers – step-by-step
4	Query #4 – Suppliers (more advanced)
5	Query #5 – Customers – using SQL Statements
6	Query #6 – Putting it all together

E. Lab Steps:

Copyright © 2010 by DeVry Educational Development Corporation.

All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation.

BIS245_W4b_iLab_Instructions.docx Page 1 of 20