Question

What inputs do I use in critera to successfully complete this assignment

create the following reports. Submit an Access database with the completed reports.

Create a product profit report. Include the name, Unit Price, Wholesale Price and the Profit (Unit Price – Wholesale Price). Order the list by highest to lowest profit.

Create a supplier mailing label report. Include the supplier name, contact, and address information. Information should be displayed in an address block (as you would address a letter).

Jonathon Boser has requested an updated contact list of employees who currently work in Shipping/Receiving or IT. Create a report of which employees are currently in these departments based on their job titles.

Create a report of customers by country. The report should prompt the user for a country, then display only customers in that country. Include the company name, contact name, full address, and phone number.

Create an orders report. The report should prompt the user for an order date, and display information about orders entered on that date. Include the company name, the orderID, order date, required date, and shipped date, and the freight amount and the shipping company name.

Answer 1

To successfully complete the assignment, you will need to create reports in an Access database. These reports include a product profit report, a supplier mailing label report, a report of employees in specific departments, a report of customers by country, and an orders report.

Step-by-step explanation:

To successfully complete this assignment, you will need to create various reports in an Access database. Here are the inputs you should use:

1. Product Profit Report: Include the name, unit price, wholesale price, and profit which is calculated as Unit Price - Wholesale Price. Order the list by highest to lowest profit.
2. Supplier Mailing Label Report: Include the supplier name, contact, and address information displayed as an address block.
3. Employees in Shipping/Receiving or IT: Create a report indicating employees currently working in the Shipping/Receiving or IT departments based on their job titles.
4. Customers by Country: Prompt the user for a country and display customers from that country. Include the company name, contact name, full address, and phone number.
5. Orders Report: Prompt the user for an order date and display information about orders entered on that date. Include the company name, order ID, order date, required date, shipped date, freight amount, and shipping company name.