Information Technology Database Concepts Using Microsoft Access

Get perfect grades by consistently using our affordable writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20

Order a Similar Paper Order a Different Paper

Thanks for working with me, and added tip will be added as an appreciation for all the good work!!!! thanks so much

This Assignment requires Microsoft Access, I will attach the Database File as a .zip file that will be needed for completing the assignment


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

For the following Assignment, you will need to use critical thinking to develop a logical solution to each problem below. Using the schema in the Books2010 database, write SQL statements for these questions:

  1. Number of books published by New Moon Books in 2010.
  2. What was the highest royalty paid for a book?
  3. Identify the five Authors made the highest royalty.
  4. Identify the top 10 author lastname title by sales.
  5. Which publishers had sales?
  6. What were the total sales of each publisher?

In a word document copy each of the questions in BOLD.

After each question, place the SQL statement in text.

After the text, place the screen shot of the execution from Access. Start a new page with the next question.

After you develop your statements, compose a short rationale of two to three paragraphs describing how the process you used to identify these solutions, or SQL statements. In your rationale, identify how you were able to define, analyze, and design, or compose the statements. Finally, include a one or two sentence reflection on how you were able to examine the statements afterwards to determine if they were written correctly.

Have your paper completed by a writing expert today and enjoy posting excellent grades. Place your order in a very easy process. It will take you less than 5 minutes. Click one of the buttons below.

Order a Similar Paper Order a Different Paper