Microsoft Access Database 2016: Printing Reports

Microsoft Access Database 2016: Printing Reports

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 is displayed, print it, and even save it as a different file type like the popular PDF format .

Continue reading “Microsoft Access Database 2016: Printing Reports”

Microsoft Access Queries: Some Pointers To Building Those Reports

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 is…

"Access, I have a question for you!"

…It then goes off and finds the answer.

In other words, a query is simply an instruction or request for a report or some other form of output of information.

The language it uses to communicate and ask that question of your data is known as SQL (Structured Query Language) and it uses this SQL query syntax to provide answers very quickly indeed.

microsoft access queries some pointers

The advantage with Microsoft Access database queries however, is that there is no requirement to learn the language at all as it Continue reading “Microsoft Access Queries: Some Pointers To Building Those Reports”

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…

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”

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

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

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.

access form designs - reports

By having an Access form design to list all the reports in a List Box control with a series of command buttons to choose the output (how they run), drives the Continue reading “Access Form Designs – How To Create A Report Interface For Your Access Database”

Microsoft Access Tutorial: How To Create A Leading Dot List

Microsoft Access Tutorial: How To Create A Leading Dot List

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 Microsoft Access tutorial, I’m going to create a report showing the company name, a contact name and the telephone number sitting (as right aligned) at the end of a dot leader line (see image below).

microsoft access tutorial string function

In fact, the telephone number may appear as right aligned but is in fact Continue reading “Microsoft Access Tutorial: How To Create A Leading Dot List”

Setting Your Forms And Reports In Access As The Defaults

Setting Your Forms And Reports In Access As The Defaults

If you are regular as clockwork like me (I mean creating Access databases that is), then setting your forms and reports in Access other than using the ‘Normal‘ blank default should help – but does it?

Just to bring everyone else up to speed, you can set your MS Access form and report defaults by typing the name of your custom form or report in place of the standard ‘Normal‘ option which means all new objects will inherit these designs as the template style going forward – saving you some extra design time!

forms and reports in access defaults

To set your defaults:

  • for Access 2010/2013 go to  File | Access Options |  Object Designers,
  • for Access 2007 go to the Office Button | Access Options | Object Designers,
  • for Access 2003 (and earlier) go to  Tools | Options | Forms/Reports.

However, your forms and reports will not Continue reading “Setting Your Forms And Reports In Access As The Defaults”

Microsoft Access Database Articles: Check Out My EzineArticles

Microsoft Access Database Articles: Check Out My EzineArticles

It’s too hot to work – taking a vacation!

While I’m away, checkout my Microsoft Access Databases EzineArticles or click that big ‘Diamond Expert Author’ logo to the right of my home page.

microsoft access databases articles

Microsoft Access Database Articles: Check Out My EzineArticles

Here are some of the direct links to popular articles:

Microsoft Access Database Design Tips – Want To Know 7 Quick Tips To Designing Your Access Database?

I’m often asked How do you design a good Access database? My simple answer is I Reverse engineer it when planning and designing an Access database! Reverse engineer it – What’s that? It’s not Continue reading “Microsoft Access Database Articles: Check Out My EzineArticles”

Access Database Forms: How To Print A Record In Access Through A Form

Access Database Forms: How To Print A Record In Access Through A Form

Interacting with Microsoft Access database forms provides that rich, smooth and harmonious way to control data with functionality. 

One popular feature is the ability to call another object namely a report for the active/current record and either preview or print a hard copy avoiding the extra steps of navigating and finding the same record via the database or navigation window.

So, how do you print just the one record you are viewing via the form?

access database forms how to print a record

You will first need to create your final report, setting the correct layouts for printing. Ideally, learn to use the primary key value that will Continue reading “Access Database Forms: How To Print A Record In Access Through A Form”

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports

Working and automating an Access report VBA will require some knowledge of the module window (VBE), the defined sections and an insight to pre-defined events for each element of a report design interface.

However, let’s take a step back and identify some of the report properties that can be used in a module that do not appear in a standard design view layout for a report. The three I want to highlight here and you may want to note are:

  1. PrintSection
  2. NextRecord
  3. PrintCount

In fact, to see a full list of report properties, open the Object Browser window (F2 on the keyboard) via the Access VBE window.

access report vba

These hidden properties can be manipulated only during the Access report run time which means the report Continue reading “Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports”