Database Assignment using books database

Download the books09.accdb database and answer the following questions.

This assignment will be done in class as a group assignment and each group should submit one answer.

One member of the group will be designated the leader for this assignment, the leader should submit the answer along with the list of the group members. If you disagree, you can note that and your discussion points on the assignment.

If you are a distance learning student or a student option student that was not in class, I will send you the email for your group which will include two other students from the class and the designated group leader. You can then do the assignment by email communications. You might organize this project by each doing the assignment and then comparing and discussing things where you do not agree.

This is the data in the table, check the database to see the structure/layout of the table.

If I have a series of conditions, I can refer to the conditions as condition A, condition B, condition C, condition D etc. For example, condition A might be checking for a specific topic or condition A might check for a year greater than a given year etc.

Question #1: What is the table name and what is the primary key for the table?

Question #2: Which query tests for two things that both have to be true?

Question #3: When two things both have to be true, this is an _______ relationship.

Question #4: Which query tests to see if one of two conditions is true?

Question #5: When either one of two things has to be true, this is an _________ relationship.

Question #6: Which query tests to see if condition A and condition B are true or whether condition C and condition D are true.

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

Question #8: Which query tests to see if condition A and condition B are true or if condition C is true.

Question #9: Which query tests to see if condition A is true or condition B and condition C are both true.

Question #10: How do you set up an Access query to show that one thing has to be true when the query also asks other questions that involve the criteria line and the or line.

Question #11: What if I had a query that asked if condition A was true or condition B was true or condition C was true. How would I set that up. Experiment to figure this out.

Question #12: Which query would produce the results shown in this flowchart?

Question #13: Which query would produce the results shown in this flowchart?

Question #14: Which query would produce the results shown in this flowchart?

Question #15: Which query would produce the results shown in this flowchart?