Access 2007 Reports Tutorial

It always amazes me when users and developers design an Access database they pay a lot of attention to the designing and planning of the database structures – and of course this is very important.

The next step is usually building the objects starting with the Tables then Queries followed by the Forms and finally the Reports.

By the time they are onto the Reports, it seems a bit of an after thought and the designs are very basic because of the the time consuming element reports can take. It is important to spend time in the design view of an Access report which is as I say is overlooked a lot of the time.

This video tutorial is a good introduction as it covers the report wizard tool which everyone starts with (and a lot of the time that’s it!) followed by the switching between the different views showing you how to add groups, calculate and change the various key properties for a report. It even explains the footer calculation for pages and concatenation (look the word up!).

At the end of the day, if you are going to present the results to your customers or executives, you need good looking Access reports and the report wizard tool will simply not do!

This entry was posted in MS Access, Queries, Reports and tagged , , , , , , , . Bookmark the permalink.

3 Responses to Access 2007 Reports Tutorial

  1. Thanks for that awesome posting. It saved MUCH time :-)

  2. benb says:

    You can find the facebook like button in one two places; in the button links at the bottom of each article and to the right hand pane on any page where it says “See me on Facebook”.

  3. Blair says:

    Where is the facebook like button ?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>