The database in the Microsoft Access file Ch01Ex02_ E7e contains the same records of employee activity on special projects as in Application Exercise 1-1. Before going any further, open that database and view the records in the Employee Hours table.

a. Eight queries have been created that process this data in different ways. Using the criteria of accuracy, 100101 001010 100101 relevancy, and sufficiency, select the one query that is most appropriate for the information requirements in Application Exercise 1-1, parts a–f. If no query meets the need, explain why.

b. What conclusions can you make from this exercise?

c. Comparing your experiences on these two projects, what are the advantages and disadvantages of spreadsheets and databases?