Category Archives: Reports

Microsoft Access Database 2016: Printing Reports

Microsoft Access database

A report is only as good as the data stored and retrieved (typically via a query) in your Microsoft Access database but this simple video tutorial (less than 3 minutes) demonstrates what the feature you can run from your report print preview… While you can print reports using commands via the Backstage view, you can also use Print Preview. Print Preview shows you how your report will appear on the printed page. It also allows you to modify the way your report […]

Tags: , , , ,

Microsoft Access Queries: Some Pointers To Building Those Reports

Database developers have admired Microsoft Access because it’s scalable and user friendly (for a development application that is) and provides a good ‘one-stop‘ shop balance for database management meeting small and medium sized company needs. I have always harked on about the key to a good database is in the query and just in case you are not yet familiar with Microsoft Access queries, here is just a little bit of information. What are Access Queries? Well the simple answer […]

Tags: , , , ,

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

Microsoft Access

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… Using the pre-built report templates or wizard features are a good start but to really have a handle of good report designs, you […]

Tags: , , , , ,

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

Microsoft Access

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. With the Expression Builder, users can create a hierarchal reference if loaded via the main report design with a sub-report included […]

Tags: , , , , ,

Access Form Designs – How To Create A Report Interface For Your Access Database

Access form

For the more polished and professional database, using Access form designs doesn’t necessarily mean viewing records from tables and queries. It can also serve as a general way to manage your MS Access database objects namely Access reports. For example, running reports from a nicely designed form showing a list of available reports that calls another form (perhaps for its criteria) before it actually displays the preview or hard copy report can improve the usability of your custom built application. […]

Tags: , , , , , ,

Microsoft Access Tutorial: How To Create A Leading Dot List

Microsoft Access Tutorial

If you wanted to generate a table of contents or a set of index pages, the format for this type of document tends to have leading dots connecting narratives with page numbers. Using Microsoft Word or other word processors and DTP applications; generating these pages is a breeze. With Microsoft Access however, it simply doesn’t exist and to mimic such a document we need to be a little creative here.  In this MS Access tutorial, I’m going to create a […]

Tags: , , , ,