Microsoft Access Tips

When we enter a criteria for a text field in an Access Query, the results can be a little limiting when we use the equality operator (ie = ...

Append Queries are really useful when you acquire a new table full of data, and want to add it to an existing table in your database.  This ...

Earlier this week I was asked how to filter the results of a report using a criteria selected from three Combo Boxes on a search form.  You ...

So we have a table of sales figures for 2011.  Suppose we want to find out the largest and smallest sales value for the month of May. Access...

Earlier this week I was working on a design for an Order Management Database, and one of the tasks I dealt with involved dynamically Enablin...

There is a very good reason why we separate name fields when we create an Access Table .  If we store the Title , First Name and S urname i...

Adding a Group and Sort to an Access Report has the potential to make our data much easier to read.  This is because our information may app...

This is the last post in the series of introductory tutorials on  Learning Access VBA .  So far we have covered a wide range of areas - the...

This is the third tutorial in the Learning Access VBA series. In the first tutorial we learnt how to create a simple VBA Sub Procedure and...

This the second post in the Learning Access VBA series.  Last week I introduced you to the VBA Development Environment where we we also lea...