AssignmentThreeInstruction

AssignmentThreeInstruction - NC A&T State University...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
BUAD 341 INTRODUCTION TO MANAGEMENT INFORMATION SYSTEMS Fall 2009 Instructor: Dr. Hong Wang Office: 303 Merrick Hall Office Phone: 334-7656 ext. 6018 E-mail: hwang@ncat.edu Assignment #3: A. Topics: 1. Use the data in the Excel file Artists to create three Access databases: PAINTER, GALLERY, and PAINTING. The foreign keys will be the painter number and the gallery number. Do the following operations: 1. Use Query Wizard to display only two fields: painting title and painting price, save the query; 2. Use Query Wizard to find the average painting price, the min and the max prices, save the query; 3. Use Query Design to find all the paintings with a price >= $700 AND by painter 123, save the query; 4. Use SQL to find PTR_LASTNAME, PTR_FIRSTNAME, PTNG_TITLE, PTNG_PRICE, GAL_OWNER, GAL_RATE for the records that satisfy PTNG_PRICE>=$200, save the query. 2. Write a report to explain how Access database management system could be used to help business achieve its goals by
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

AssignmentThreeInstruction - NC A&T State University...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online