Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.
Create a Query and Grouped Report and Modify Design using Access
Posted on
11,298 Points
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.zip2. 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
-
3
3
6 Comments
Active today
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.
Active today
If you share this video by using the icons on the left, then anyone can watch the full video.
the next video is here:
Polish Reports in Access
https://www.experts-exchange.com/videos/4559/Polish-Reports-in-Access.html
Polish Reports in Access
https://www.experts-exchange.com/videos/4559/Polish-Reports-in-Access.html
Featured Post
The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.
Suggested Videos
Generating random numbers is quite easy, but making them persistent to form updates, deletes, sorting, and filtering takes a little more work. Here we will show how to accomplish this with a few lines of code.
Currency codes can be obtained from many sources. The modules here retrieve them from two sources: ISO itself (the definitive source) and Currency Converter API. Both methods will allow you to maintain a table of current currency codes.
