I have listed the students who i think may still remain in the class although this probably maximizes the number of students remaining. 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 3 days from the end of class. Specifically, Midnight on Thursday, April 12th for the Monday class and midnight Friday, April 13th for the Tuesday class.
Students not submitting this assignment by the deadline will receive a zero for the test. We do not have the time and there will be no delaying of the deadline. In addition, for those of you who have a habit of non submission, you are already aware that non submission of this assignment will effect scrutiny of possible previous non submissions and it is my intention to drop students who are making this practice a habit.
The first query uses either recyceid or townships depending on the problem
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