Thursday, September 20, 2012

Dear Class: Open up your DB ACCESS from Tuesday. The Job column, DB experience, and the Programming experience should be yes/no. The money column should be currency. This is done in design view. I want two reports done today; first one with Last (change to descending), First, Food, Color, Middle School, Grade, and Age (in that order). I want you to do a second report with Last, First, and any other four that you have with First Name in descending order. When you are done, these reports will be shared with me by uploading the file to google docs and put into your shared folder for me. To "print" these, they will be printed as "PDF" file and then uploaded to your account. I want to then do a query with Last name, first name, age, jobs, DB experience, Programming experience, and money. The query will have with jobs only (yes or not "no"), money (greater than or equal to $20). Have the last name as "descending" and show all. The project will be on cars. Sincerely, Mr. Green-Hite