I have listed the students who remain in this class. You are to click your name and a word document should appear. The word document has a link to a database and you are to follow the instructions to do the test. The test consists of the creation of five(5) queries designated as q1 through q5.
Access (and databases) are not easy subjects and one could argue whether this should be included in a course like this. Therefore, I tend to be quite easy in marking whatever you submit, which should be the database with the 5 additional queries.
What I will not be easy about this term is your lack of submission of such. Your database - whatever, however, good or bad - is due by midnight, Friday night, June 15th. To be perfectly clear: 11:59PM on Sunday night, August 12.
Students not submitting this assignment by the deadline will receive a zero for the test. You are already aware that I plan to drop those students with two or more no shows per marking events. If you have missed any of the following: the Word multiple choice, the word scenarios, the library info test of the powerpoint submission, please note that your non submission of this exam will result in your being dropped from this class.
The first query uses either recyceid.
The second through fifth query uses recyclecommercial. The last two queries require group bys as you are intermixing aggregate and detail. The last query is an inner join to the generator table