Field and Query free essay sample

Dealers Project Description: In this undertaking, you will make a few inquiries, use gathering and arranging measures, and make articulations to make determined fields. You will likewise set numeric and date measures to create explicit outcomes. Guidelines: For the motivation behind evaluating of the undertaking you are required to play out the accompanying errands: Step| Instructions| Points Possible| 1| Start Access. Open the downloaded Access database named Exploring_a03_Grader_EOC. accdb. | 0| 2| Create another inquiry in Design see. Include the Customers, Orders, and Employees tables to the inquiry plan window. From the Customers table, include the CompanyName, ContactName, and ContactTitle fields; from the Orders table, include the OrderID, OrderDate, and ShippedDate fields; from the Employees table, include the LastName field. Make certain to include the tables and fields in the request recorded. | 7| 3| In the principal void field cell of the structure network, make another field in the question named DaysToShip that deducts the OrderDate from the ShippedDate. We will compose a custom exposition test on Field and Query or then again any comparative subject explicitly for you Don't WasteYour Time Recruit WRITER Just 13.90/page In the standards column of the DaysToShip field, enter gt;20. | 10| 4| Run the question and afterward spare it as Shipping Efficiency. | 5| View the question in Design see. Add the Order Details table to the inquiry window, and afterward include the ProductID and Quantity fields (in a specific order). Sort the inquiry in climbing request by OrderID. | 5| 6| Set the inscription property of the LastName field to SalesRep. Run, spare, and afterward close the question. | 6| 7| Create another question in Design see. Include the accompanying tables in a specific order: Orders, Order Details, Products, and Customers. From the Orders table, include the fields OrderID and OrderDate (in a specific order) to the inquiry structure lattice. | 6| 8| In Design see, add a Total column to the inquiry. In the main void field cell of the structure matrix, make another field in the question named ExtendedAmount that duplicates Quantity by UnitPrice (in a specific order). Select the Sum work from the Total column in the new field. | 15| 9| In the following void field cell of the structure network, make another field in the inquiry named DiscountAmount that increases Quantity by UnitPrice by Discount. Select the Sum work from the Total column. Organization the determined field as Currency. | 13| 10| Run the inquiry and afterward spare it as Order Summary. | 5| 11| View the Order Summary inquiry in Design see. Set the measures for the OrderDate field to return dates between 5/1/2012 and 5/31/2012. Run, spare, and afterward close the inquiry. | 8| 12| In the Navigation Pane, duplicate the Order Summary question and glue it into the database as Order Summary by Country. View the new inquiry in Design see. | 8| 13| Replace the OrderID field with the Country field (from the Customers table). Sort the inquiry by the ExtendedAmount field in Descending request. Run, spare, and afterward close the inquiry. | 12| 14| Close the database and afterward leave Access. Present the database as coordinated. | 0| | Total Points| 100|