<

Create a Query and Grouped Report and Modify Design using Access

Posted on
10,167 Points
567 Views
1 Endorsement
Last Modified:
Approved
Experience Level: Beginner
16:48
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

Become an Android App Developer
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

1
Comment
  • 3
  • 3
6 Comments
 
 

Administrative Comment

by:Kyle Santos
Great video submission, Crystal!  Congratulations.  Your video has been Approved and is now published on Experts Exchange.  Feel free to share this video by selecting the social sharing icons.
0
 
LVL 24
Thank you, Kyle. Can anyone watch it or only those with an EE membership?
0
 
 

Administrative Comment

by:Kyle Santos
If you share this video by using the icons on the left, then anyone can watch the full video.
0
 
LVL 24
awesome! Thank you, Kyle.  I will do that.
0
 
LVL 24
the next video is here:

Polish Reports in Access
https://www.experts-exchange.com/videos/4559/Polish-Reports-in-Access.html
0
 
 

Administrative Comment

by:Kyle Santos
Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month