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
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.
There are several ways to export data from Microsoft Access to other file formats. The general method when exporting data usually refers to the data itself namely to an Excel spreadsheet (.xls/.xlsx) or as a CSV (comma separated value) file or even as an HTML file for the web.
However, using the XML Continue reading “Microsoft Access Database: XML Data Export in Access”
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!”
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).
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.
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 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.
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.
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 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 – Nulls: Do We Need Them?
The following three keywords are the most misunderstood when working with an Access Database:
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”
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”