Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make a report called REPORT1 with employee data, and make the Notes field relatively small and on its own line and set the can grow

 Make a report called REPORT1 with employee data, and make the Notes field 
relatively small and on its own line and set the can grow and can shrink properties 
to YES.
2. make a Category/Products Report called REPORT2 that groups products 
by category that starts a new category on each new page, that continues the 
category name if it continues onto the next page and that averages the unit price 
per category and then gives a grand average price at the end of the report.
3. Make a report called REPORT3 that provides a graphical report that 
counts the number of products per category.
4. Make a report called REPORT4 that provides a graphical report that 
calculates total sales per employee.
5. Make Mailing labels report called REPORT5 for customers that follow 
this format:
Tom Jones - Sales Associate
ABC Company
123 Main Street
Seattle, WA 98119 - USA
6. Make a report called REPORT6 that prompts for a customer name and 
then displays all of that customer's orders. (HINT: this requires a parameterized 
query as the record source).
7. Make a main report of suppliers called REPORT7, with a sub-report of 
products.
EXTRA CREDIT BONUS 
1. Make a report that gets its source of a customer that is selected from a combo 
box on a form and then displays all that customer's orders (Note this is similar to 
Report6, only harder ).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Solution Report 1 Employee Data Employee ID Employee Name Notes 12345 John Doe Excellent employee 67... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

What background experience do you have?

Answered: 1 week ago

Question

Processes produce outputs over time. O True OFalse

Answered: 1 week ago

Question

intrduction to data science bits wilp

Answered: 1 week ago