Project Assignment|Computer Info Systems
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.