This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.
Create a Query and Grouped Report and Modify Design using Access
Posted on
10,063 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 2 days ago
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 2 days ago
If you share this video by using the icons on the left, then anyone can watch the full video.
Active 2 days ago
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
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 Already a member? Login.
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| How to create an Office 365 email signature using a Transport Rule | 285 | |
| Polish Reports in Access | 626 | |
| The Email Laundry | 18 | |
| How To Make a Graph with Microsoft Access | 146 |
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Suggested Courses
Course of the Month9 days, 7 hours left to enroll
Next Video:Microsoft Bookings Review