a easy project

CO SCI 201-Intro to Computer Info Systems Dr. Simon Lin

BONUS-Project Assignment 9 (PA9) Version: 8/24/17

BONUS Project

CS201 Project Assignment 9 (PA9)

Note: This is a bonus project for extra 4% points above the normal 100% points.

Please do the ACCESS’s Challenge Yourself 4.3, which is on page AC-225 to AC-226 of the ACCESS section in the book “Microsoft Office - A Skills Approach 2016”.

The start file “AC2016-ChallengeYourself-4-3” (for step 1) can be obtained from the Files folder by the name of “CS201-PA9-AC2016-ChallengeYourself-4-3.accdb”.

Special Notes about this project:

(1) There are 5 queries to be created: [1] GreenhouseTechsFT, [2] NewPlants, [3] RedPlantSale, [4] PlantsMissingMaintenance, and [5] PlantsByColor.

(2) The ACCESS manual shows how to create a QBE query, which may be easier for you to do. However, you are welcome to design your query by using SQL, which is the international standard structured query language for a relational DBMS.

(3) You would get partial credit for what you have accomplished for this project.

How to submit your work?

You must submit your work by uploading your final result file.

Page 1 of 1