Question
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started