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)
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.
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Storing hashed or encrypted data.
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user. I would like to think this is a "le…