Information Technology Database Concepts Using Microsoft Access

Our papers are 100% unique and written following academic standards and provided requirements. Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Rely on us and be on schedule! With our help, you'll never have to worry about deadlines again. 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

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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.

Hi, student! You are probably looking for a free essay here, right? The most obvious decision is to order an essay from one of our writers. It won’t be free, but we have an affordable pricing policy. In such a manner, you can get a well-written essay on any topic. Let us cover any of your writing needs!

Order a Similar Paper Order a Different Paper