Field and Query free essay sample

Dealers Project Description: In this undertaking, you will make a few inquiries, use gathering and arranging models, and make articulations to make determined fields. You will likewise set numeric and date measures to deliver explicit outcomes. Directions: For the reason for 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 question 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 matrix, make another field in the question named DaysToShip that takes away the OrderDate from the ShippedDate. We will compose a custom paper test on Field and Query or on the other hand any comparable subject explicitly for you Don't WasteYour Time Recruit WRITER Just 13.90/page In the measures line 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 rising 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 question structure lattice. | 6| 8| In Design see, add a Total line to the inquiry. In the main void field cell of the structure framework, make another field in the question named ExtendedAmount that increases 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 framework, make another field in the question named DiscountAmount that increases Quantity by UnitPrice by Discount. Select the Sum work from the Total column. Configuration the determined field as Currency. | 13| 10| Run the inquiry and afterward spare it as Order Summary. | 5| 11| View the Order Summary question in Design see. Set the standards 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 inquiry and glue it into the database as Order Summary by Country. View the new question in Design see. | 8| 13| Replace the OrderID field with the Country field (from the Customers table). Sort the question 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|