Please do the question 1 to five

Exercises

Your instructor will specify how you are to prepare and submit the answers to the following exercises.

Create a report based on the Quarterly Orders query that already exists in Northwind. Place all the fields of the query into the report. Group by Country and sort the records within country by Customer ID. Modify the wizard-created report in accordance with the Report Design Guidelines.

One of the suppliers, Exotic Liquids, is having a sale. Create a query that lists the product IDs, names, quantity per unit, unit price, units in stock, and reorder level of all products purchased from that supplier. Save the query with the name Exotic Products. Then create a report based on this query. Add totals for Units in stock at the bottom of the report. Revise report in accordance with the Report Design Guidelines.

Using the report wizard, create a tabular report of the Employees table.  Include in order from the left, the hire date, employee ID, first name, and last name.  Sort the report ascending by last name within hire date (you can do this as part of the wizard or by the “Sorting and Grouping” option of the View menu.  Change the title of the report (in the Page Header band) to “Employee Listing by Hire Date”. Revise report in accordance with the Report Design Guidelines.

Create a report from the Customers Table that includes all the fields, is sorted by Company Name, and is in columnar layout.  Revise report in accordance with the Report Design Guidelines.

Create a query that lists from the Products table all Product Names that contain the words Cajun, Gumbo, or Hot.  Next create a report using the “Create report by using wizard” option to show all the product names of this query.  Do not use any type of grouping, but do sort upon the Product Name.  Title your report “Hot Products”.  Select the title label, bring up the Properties box, and change the title Font Name to Script and Font Size to 28. Revise report in accordance with the Report Design Guidelines.

• 1500567519-Lab 11 - Report Design Using Microsoft Access.doc

APlusGrades

Not Rated (0)

Status NEW Posted 20 Jul 2017 04:07 PM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- �-----------� -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m �-----------�on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer