Let us worry about your assignment instead!

We Helped With This ACCESS Database Assignment: Have A Similar One?

More InfoMs Access Assignment Help

Short Assignment Requirements

Access Assignment, instructions included in first document.

Assignment Description


Databases (Individual)


Your task in this assignment is to modify the Book database (books.accdb) available on Sakai to add the following functionality:

1.     Add a table to the database called Review

a.     The primary key of the table should be called ReviewID. The other fields in the table should be ReviewerName (text) and Rating (also text).

b.     Make the needed changes to the Book table so that Review table and the Book table can be linked:

i. The Book table needs a new field to be the foreign key ii. Add some records to the Review table. You can make up the data.

iii. Link the two tables together in the Relationships window. Each book is linked to one review, possibly many.

2.     Create 4 queries:

a.     Write a query that returns the Title of every book released before the 1st of March 2012.  Only the Title of the book should be returned by the query. Call the query “Query 1” and save it.

b.     Write a query that returns the Title and the Paperback identifier of every book which is either classified as a Horror Type (“HOR”) or Sci-Fi Type (“SFI”). Only the Title and the Paperback identifier of the book should be returned by the query. Call the query “Query 2” and save it.

c.     Write a query that returns the Title of every book written by anyone who has the first name of “Peter”. Only the Title of the book should be returned by the query. Call the query “Query 3” and save it.

d.     Write a query that returns a count of the number of book copies that meet the following conditions:


-  The book is written by “Toni Morrison”.     - The book is published by “Plume”.

-  A copy of the book is located at the “Henry Brentwood” branch of the library.


Only the count (e.g. CountOfTitle) should be returned by the query.  Call the query “Query 4” and save it.


3.     Create a report that displays all the books in the system. Sort the books into alphabetical order by name. The end of the report should show a total count of the number of books in the system. The top of the report

Databases (Individual) ³  INSS 300.101  ³  Fall 2016  ³  Page 1 of 2

should have a title, and the footer should show the date and number of pages. Name this report “Book Listing” and save it. Note the report name is not the same as the title that is at the top of the report.

a.     Use fonts, layout and colors to customize the look of the report. Assume the reports would be printed on landscape, letter sized paper.


o    All queries and reports should work correctly even if more data is added to the tables, or removed. o       Make sure you delete all draft attempts in your database. 

o    Make sure that all your work is saved inside the database, do not export objects and save them as separate files. You should submit a single Access file as your assignment.


Project Due Date:

            December 14th, 2016 (project must be submitted via Sakai prior to the start of class).


What to turn in:

            A digital copy of your single Access database file (submitted via Sakai as an attachment).

Databases (Individual) ³  INSS 300.101  ³  Fall 2016  ³  Page 2 of 2

Frequently Asked Questions

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

Regular homework$20 - $150
Advanced homework$100 - $300
Group project or a report$200 - $500
Mid-term or final project$200 - $800
Live exam help$100 - $300
Full thesis$1000 - $3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for $100, we could tell that the price is $200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On

soc fb soc insta

Paypal supported