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 NowThis Assignment requires Microsoft Access, I will attach the Database File as a .zip file that will be needed for completing the assignment
Instructions
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:
- Number of books published by New Moon Books in 2010.
- What was the highest royalty paid for a book?
- Identify the five Authors made the highest royalty.
- Identify the top 10 author lastname title by sales.
- Which publishers had sales?
- 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.
