The database in the Microsoft Access file ChOlEx02_ E6e contains the same records of employee activity on special projects as in Application Exercise AE-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, relevancy, and sufficiency, select the one query that is most appropriate for the information requirements in Application Exercise AE1, parts a-f. Ifno 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?