Access and SQL

This assignment will be done in class (or at least started in class). Students not in class can choose to do it individually or in groups. If I have heard back from you about your preference to be in a group, I will match you up with someone else who prefers to work in a group when possible. If you do not hear from me, ask.

This assignment will use the books09 database that we used for the last group project. I have added some SQL queries, so you will need to download it again. Use the queries with SQL in the name.

Question #1: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #2: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #3: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #4: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #5: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #6: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #7: Which SQL query tests to see if condition A is true and also that either condition B or condition C are true?

Question #8: Which SQL query tests to see if a group of two conditions has both conditions true or a stand alone condition is true?

Question #9: Write the SQL query in Access to test for Course Technology as the publisher and either topic of CSS or price < 75. Test it and copy and paste the solution into the answer sheet.

Question #10: Write the SQL query in Access to test for Course Technology as the publisher and year published greater than 2005 or price < 25.