Microsoft Access Database: Crosstab Queries with Microsoft Access 2003

What is a Microsoft Access Crosstab Query? Here’s the simple answer by asking a different question. Do you know what an Excel Pivot Table is? If you do, then you have just answered the first question!

In fact, Microsoft Access Crosstab queries are quite basic and limited when comparing to the newer and richer reporting outputs of a Pivot Table but it’s still in use and effective.

Take a look at this video tutorial (no more than 5 minutes) called

Microsoft Access 2003 Tutorial Crosstab Queries

httpv://www.youtube.com/watch?v=CFYFXGth5VI

The trick is to base this type of Microsoft Access query on another query which would typically be made up from related tables.

To learn more about queries of all types, take a look at one of my eBook on More Microsoft Access Queries. There are other eBooks too, Microsoft Access eBooks.

Microsoft Access Database: A Powerful Database Program for Novice End Users!

I found the following article about Microsoft Access Databases which is aimed at those who are considering using a powerful database management tool and have no knowledge or have no idea which application to choose.

This article will ease the new ‘prospect user’ towards using Microsoft Access as being the friendlier application when Continue reading “Microsoft Access Database: A Powerful Database Program for Novice End Users!”

Microsoft Access Database: Adding OLE Objects (Pics) to Tables and Form in Access

How to Add Pictures/Images to An Access Database

Here is a quick video tutorial (less than 3 minutes) to show you how to add pictures into an Access database application using the OLE object data type field technique.

This video tutorial is based on an earlier version (2003) but still works for the later versions (2007 & 2010).

httpv://www.youtube.com/watch?v=QFUDt0cpIi0&feature=related

Microsoft Access Database – My Comments

Be careful not to have too many OLE Object data type fields in an Access database table, as it will use a lot more memory than conventional data types namely Text and Number.

Like the Memo data type field, you can not set field sizes and is driven by the image file size therefore the quality of the image will matter making a black and white low resolution image more memory efficient than a full colour high resolution equivalent.

Microsoft Access Database: Creating an Audit Trail in Microsoft Access

Some Microsoft Access database systems require an audit trail feature built to track the movement of sensitive records that administrators need to monitor and control data processing tasks.

I found this article from a popular database solution resource which is for the more advanced Access database developer but it’s the only way I know of how you create such a feature and it does require some VBA code too.

Microsoft Access Database – Article on How to Create an Audit Trail

Click here to view the article

If you wish to know more about VBA code and programming in Microsoft Access, then contact me for further help.

I would like to know if you have had any experience with this sort of feature and have perhaps found another to achive this – please post your comments!

Microsoft Access Database Hosting On The Internet

Microsoft Access database applications can now be used in a wider area network environment; in other words via the internet.

The following article called ‘Microsoft Access Hosting‘ gives you the heads up and is worth a read.

Click here to view the article

This is for the more advanced Access database user and developer wishing to publish via the internet who should read this article.

Microsoft Access Database: Changing the Theme for Forms & Reports in Access 2010

The following quick video tutorial (75 seconds) shows you the new feature in Microsoft Access called themes which are available to both forms and reports.

httpv://www.youtube.com/watch?v=FiPhKML6MEc&feature=related

Microsoft Access  Database – My Additonal Comments

The ability to now click and apply a pre-defined theme to a form or report is great and has been vastly improved replacing the template to forms and report approach (though still supported).

You can even design your own look and feel by changing all the attributes which include fonts, colours, borders and background styles, then capture this as a new theme which is available in the same area on ribbon bar.

The file format which you are prompted to save as is known as ‘.thmx’. Just remember the location for your themes which defaults to the template folder in Microsoft Access.

Microsoft Access Database: Think Relational, Not Flat with An Access Database

Microsoft Access databases are typically used as relational data sets of information but the clarity of what is a relational database versus the ‘flat‘ file database seems to muddy the waters from at times.

I personally have fallen foul to when I have used a relational, flat or both types of data capture processes and this is down to the lack of planning – shame on me!

It’s a common mistake to use ‘Yes/no‘ data types fields to attach transactional values in the same table as holding say, profile information. For example, if I have a list of people Continue reading “Microsoft Access Database: Think Relational, Not Flat with An Access Database”

Microsoft Access Database: How to Work with Nulls in Your Access database

Microsoft Access – Nulls: Do We Need Them?

The following three keywords are the most misunderstood when working with an Access Database:

  1. Null
  2. Empty
  3. Nothing

To answer the question; YES we need them; there are all important and you might as well master these operators and where it will be found in your Access database.

There is a definition Continue reading “Microsoft Access Database: How to Work with Nulls in Your Access database”

Microsoft Access Database: Practice Microsoft Access Database Decorum to Reap the Rewards

There is a saying when designing an Access database; “The information you get out is directly proportional to the information that is put in” (or something to that effect!).

The following article is written by an author who talks you through a typical scenario and how Microsoft Access is one powerful Continue reading “Microsoft Access Database: Practice Microsoft Access Database Decorum to Reap the Rewards”