<

Create a Query and Grouped Report and Modify Design using Access

Posted on
11,419 Points
819 Views
1 Endorsement
Last Modified:
Community Pick: Many members of our community have endorsed this article.
Experience Level: Beginner
16:50
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final polish on the report, rename it, and add it to a menu form. Download the START and SOLUTION sample databases.

Video Steps

1. Download the START and SOLUTION sample databases (zip file)

SimpleGroupedReport_START_SOLUTION_D.zip

2. Open the START sample database

3. Create a Query to Line Up Data for Report

4. Use the Report Wizard to create a Grouped Report


Source is the query created in step 3

5. Group by year, month, day, then product category

6. Sort by product name then descending amount

7. Specify the amount to be summed

8. Choose Outline layout

9. Modify the Report Design


Add, delete, resize and move controls; show and use different report sections; spacing and boundaries; calculated controls;  formatting and properties; Report View and Print Preview.

10. Compare what you did to the SOLUTION database

1
  • 3
3 Comments
LVL 26
Thank you, Kyle. Can anyone watch it or only those with an EE membership?
0
LVL 26
awesome! Thank you, Kyle.  I will do that.
0
LVL 26
the next video is here:

Polish Reports in Access
https://www.experts-exchange.com/videos/4559/Polish-Reports-in-Access.html
0
Over the past few months, many folks seem to be having a variety of Outlook problems. This article contains troubleshooting and repair steps that will often solve the various issues people have been encountering. Step-by-Step instructions and illust…
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use.  Here is how I added one to a Microsoft Access database. Please see the important note at the bottom of this article regarding compati…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month