IT163 Database Concepts Using Microsoft Access Select a course

User Generated

qngobv

Computer Science

Description

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey I am through with the work. Find the correct answer in the attached word file.

1

Name...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags