I am working with Microsoft access and don’t know the formulas needed for these questions?
The Book Corner is a small, local bookstore that sells to both recreational readers and the local college student population. The manager uses Access to track inventory, customers, and transactions. You have been asked to create advanced queries that will help the management team make important business decisions. To keep the file small while you work with the database, the store manager removed most of the data and left only some sample data. Once the store manager has accepted your changes, she will load all the data and implement the new database.a. Open the a03ch06BookCorner database, and then save it as a03ch06BookCorner_LastFirst using your last and first name.b. Open tblCustomer, and then add your information in record 25. Replace YourName in the First Name and Last Name fields with your first and last name. Close tblCustomer.c. Create a query based on the tblShipments and tblTransaction tables that display the TransID from tblTransaction and a calculated field called DaysToShip that calculates the number of days it took to ship the items from the date purchased, using the DateDiff function. Sort the results in Descending order by DaysToShip. Save the query as qryDaysToShip and then close the query.d. Create a query that is based on the tblInventory table. Display InventoryID, Price, and a new calculated field called NewPrice The NewPrice should be 30% more if the book is OutofPrint and 10% more if not. Both values should be rounded to the near-est dollar. Format the NewPrice field as Currency. Save the query as qryNewPrice and then close the query.e. Create a query based on the tblAuthor and tblInventory tables that contains a calculated concatenated field called Description The Description field should dis-play the following for all books in the database:Author: FirstName LastName – Title: BookTitle – Genre: BookGenreSave the query as qryBookDescription and then close the query.f. Create a query based on the tblCustomer, tblTransaction, tblTransactionDetails, and tblInventory tables that will return the top 25% of customers based on a calcu-lated field called Revenue Display CustomerID and Revenue. Calculate Revenue by multiplying the price and quantity, format Revenue as Currency, and sort the results in Descending order. Save the query as qryTop25%Customers and then close the query.g. Create a query based on the tblInventory table to help determine when to order addi-tional copies based on the NumberInStock. Display InventoryID, BookTitle, and a calculated field called Status If there are seven or more copies in stock, then display None If there are between four and six copies in stock, then display Critical. For those with fewer than four in stock, then display Urgent Save the query as qryOrderStatus and then close the query.h. Create a query based on the tblInventory table to help determine which books in the fiction and literary genres were written during the 19th century (1801-1900). Display BookTitle, AuthorID, YearPublished, BookGenre, and Condition. Save the query as qryNineteenthCentury and then close the queryi. Create a query based on the tblInventory, tblTransaction, and tblTransaction-Details tables to help determine which “Your Office” books have been shipped within a specific 90-day period. Display CustomerID, BookTitle, Transaction-Date, and Qty. Use a parameter and the Between…And function that allows you to enter a start date and end date when you run the query. Use a wildcard and the Like operator to ensure that only books with “Your Office” in the title are included. Test your query by using 7/1/2020 as your start date and 9/30/2020 as your end date. Save the query as qryNinetyDays and then close the query.j. Create a query based on the tblTransaction table to help determine the date when a purchase should be shipped. Display TransID, CustomerID, TransactionDate, Shipped, and a calculated field called ShipByDate that calculates the date by which the order should be shipped, using the DateAdd function. Orders should be shipped within seven days from the date when the order was placed. Sort the results in Ascending order by ShipByDate. Save the query as qryShipByDate and then close the query.k. Close the database, exit Access, and zip and submit your file.
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more