BCIS 1305 Access Library Project Part 2 Write queries and run them in Access. Save each query naming it as indicated. ALL of your output should be...

I am having troubles with these steps. There's something wrong because whenever I follow the steps the record results don't match the records on the instruction sheets. I don't know how to fix these.

• Attachment 1
• Attachment 2
• Attachment 3

BCIS 1305Access Library ProjectPart 2Write queries and run them in Access. Save each query naming it as indicated. ALL of your output should be shown withappropriate field headings/captions, i.e. Book_title is Title. Trick to building queries: Decide what tables are needed and add them to the design. Add your fields to the gridand run the query before you set your criteria. That way you know you are getting data. If running the queryafter setting the criteria and you see nothing, you know the problem is with the way you enter the criteria.Refer to the FAQ sheet where indicated. It will make your life easier.1. Open the Author table in Datasheet view. For Author_Code ACCH, change the name to yourname. Open the Branch Table in Data Sheet View. In the second column, change the names of thebranches with Your name to our actual name: Example: Your Name’s North would becomePhillips North.2. List all fields for the publishers from Massachusetts. Use the default field names.Name the query ALP_Query02 3. List all the books and the author name’s (presented as one field in the display) for those booksthat are NOT hardcover. Each title should be listed only once. See FAQName the query ALP_Query03 4. 1365 records Count the number of books at each branch. The results should show the branch name (i.e. Nora’sEast. This is an example, all the branches should be displayed.) along with the number of books.The output should be titled “Number of Books at Each Branch”. See FAQName the query ALP_Query07 8. 54 records List the titles, type/category (mystery, art, etc.), price of all books sorted by type of book andbook title. Works left to right.Name the query ALP_Query06 7. 332 records List all the names, just the names, of the ‘Computer’ and ‘Mathematics’ writers who have booksat the South branch.Name the query ALP_Query05 6. 500 records List all the names of the ‘Computer’ and ‘Mathematics’ writersNote: Refer to your printed relationship report. What table connects the Categories with theAuthors?Name the query ALP_Query04 5. 2 records 4 records What is the value of all the books at each branch? See FAQ (just a different function on the dropdown list)Name the query ALP_Query08 4 records BCIS 1305Access Library Project9. List the names of all unique book titles and their authors giving the resulting columns appropriatetitles. (If there are multiple copies of his/her work at the various branches list the book/authorcombination just once.) See FAQName the query ALP_Query09 10. For each author, list his/her entire name as Name and their associated publisher. The resultsshould alphabetical by author’s last name. (A field may be included in the grid but not shown inthe output.) If the author has written several titles list the name just once. However, if an authorhas multiple publishers, that name will appear multiple times. See FAQName the query ALP_Query10 11. 481 records How much has been invested on paperback books? A query may be built upon another query aslong as the results contain the information you need. See FAQ (just a different function on thedrop-down list)Name the query ALP_Query14 15. 1286 records For each paperback, list only the book title, publisher, and priceName the query ALP_Query13 14. 9 records For each publisher, list the all the different books they publish and their name (the publisher) inorder by publisher.Name the query ALP_Query12 13. 970 records How many different books does each publisher publish? List the results by publishers. See FAQ(just a different function on the drop-down list)Name the query ALP_Query11 12. 1090 records How many paperbacks books are located at the west branch? See FAQName the query ALP_Query15 1 record 1 record 16. Write a form to input new books as the library receives them. Save the form. 17. Using the form just created, enter the book information for your favorite book. 18. Write a report using the results of query 10 as the basis. The data should be organized/grouped bypublisher. Change the color of the text on the title. 19. Upload your files (Access database file and Data Dictionary sheet) 5 BONUS POINTS if you can use a drop-down list of publisher numbers in your form.