Assignment Overview:

Reports are critical to a business because they take the data stored in organizational databases and present the data in the form of meaningful information that is then available to executives and business analysts. By presenting the data in a meaningful form, executives and analysts are able to make better business decisions. The queries that drive reports are critical to delivering a meaningful report. This suggests that analysts and database administrators need to work together to determine the information needed by the organization.

Instructions

You must have the Access Database system installed for this Assignment. You should have imported the Books2010 database into Access.

Using the schema in the Books2010 database, you will create reports to retrieve data from the database.

1. Create a report that displays a list of books.
2. The report will contain the book type, title and price.
3. Sort the list by book type.
4. Create a report that displays a list of employees.
5. The report should contain the first name, last name, job title, and hire date of each employee.
6. Sort the list by last name.

In a word document, place a screen shot of the execution of each report you created. You can do a print preview and take a screen shot of that.

Be sure to label each screen shot.