Microsoft Access 2007 Onwards – How To Create Access Reports From Scratch

Microsoft Access 2007 Onwards – How To Create Access Reports From Scratch

We all know that information will get out of an Access database is as only good as the data we input. This can also be measured when building Microsoft Access Reports.

Here’s a five minute video tutorial I found that I found that explains the simple process of building an Access 2007 report from scratch...take a look…

httpvh://www.youtube.com/watch?v=46pobpoY77s

Using the pre-built report templates or wizard features are a good start but to really have a handle of good report designs, you need Continue reading “Microsoft Access 2007 Onwards – How To Create Access Reports From Scratch”

Microsoft Access Reports – Passing Totals From A Subreport Into The Main Report

Microsoft Access Reports – Passing Totals From A Subreport Into The Main Report

Working with Microsoft Access Reports can be time consuming and fiddly to master and one of the common challenges is correctly writing calculated expressions between main reports and their embedded sub-reports.

If you are not familiar with writing expressions, then I suggest you start with the built in Expression Builder utility which will navigate and build the correct references.

microsoft access reports totals

With the Expression Builder, users can create a hierarchal reference if loaded via the main report design with Continue reading “Microsoft Access Reports – Passing Totals From A Subreport Into The Main Report”