Download FREE courseware handouts. These
documents are ideal for teachers, students and anyone wanting to
learn more about their Microsoft Office programs. Each handout
covers a specific topic and is illustrated with full-colour
screenshots. Many have accompanying sample files. The files are
not restricted in any way so you can print copies or read them
Get my Free Courseware here.
Do you want to learn more about Access, Excel and
VBA? Are you a teacher looking for top quality courseware for your
students? My eBooks are the ideal solution to your needs. They are
packed with code snippets, illustrations and step-by-step
exercises. Written in the same
style as my popular on-line tutorials, my eBooks will help you
develop your skills and build useful, professional looking
applications. Find out more at my eBooks Page.
Support this site!
Make a small donation to help
support this site.
Add an Audit Trail to your Access Database
It's important to keep track of your valuable business data and
especially in a multi-user environment it can be important to know who did
what and when. The task might seem daunting but when I set out to build an
Audit Trail tool it turned out to be much easier than I expected. This
simple tool works from any data form so you only need to build it once in
your database. [23 April 2013]
Build Better Access Forms: Mastering the Combo Box
When a field has a limited list of possible values a combo box is usually
the best way to help the user make their choice. This tutorial shows you
several ways to enhance your Access forms by harnessing the power of the
combo box NotInList event.
Access and SQL Part 6: Dynamic Reports
Reports are often seen as inflexible, with the decisions about which data is
to be displayed being made at design time. Access users often think that if
they want to see a different set of data they need to build a new report.
Not true! Add some VBA and a sprinkling of SQL and you can have truly
dynamic reports which change their content at the click of a button.
Access and SQL Part 5: More Instant Queries
This tutorial takes expands on the theme of "all purpose" queries and shows
you how to build SQL statements from multi-select list boxes, how to offer
And/Or criteria options, and how to let the user choose how the data is
sorted. There are also tips on filling lists programmatically and clearing
list box selections.
Access and SQL Part 4: Building Queries "On the
When you build a database you can't anticipate your users' every need,
especially when it comes to queries. Even if you have the skill to create
your own queries it can be tedious to build a new query every time you want
to ask your database a different question. This tutorial shows you how to
build "all purpose" queries that write their own SQL.
Access and SQL Part 3: Some Practical Examples
A hands-on session where you can test the power of SQL by building and
modifying tables, and adding and editing records, all with a line of VBA/SQL
Access and SQL Part 2: Putting VBA and SQL
VBA and SQL are different languages. This tutorial explains how to get your
VBA code to "speak" SQL. It illustrates good coding techniques and shows you
how to avoid errors and debug your code when things don't work.
Access and SQL Part 1: Setting the SQL Scene
The first in a series of tutorials about using SQL to help you build a
better database. This first tutorial takes an overview of where and how SQL
fits in to database management and offers a taste of what is to come in
A Combo Box Date Chooser
People need help entering dates, and I often add a calendar to my Access
forms to make things easy for the user. But sometimes the ActiveX calendar
isn't appropriate so I designed an "intelligent" date chooser using combo
boxes. The VBA code that powers the form verifies the date and won't let you
enter a bad one (like September 31). This tutorial is in two parts. The
first part shows you how to build the form. The second part adds the VBA
code and explains how everything works.
Coloured tabs for Your Access Forms
Access forms are where the database builder can show off their artistic
talent, but some components can't be customised to match your colour scheme.
An obvious example is the command button. Another is the tab control, so
when I was asked if the tabs could be given custom colours my first answer
was "No". But as usual, some ingenuity and a little VBA can solve the
Making Sense of List Boxes
Unlike the Combo Box the List Box can allow the user to make multiple
selections from the list, but to make use of this feature you need to use
VBA code. Fortunately it's quite simple and this tutorial shows you various
ways to do it.
Form design is all about making life easier for the user. One way to achieve
this is to help them make decisions. This tutorial shows you how to make the
contents of a drop-down list dependent upon the choice the user makes in a
A Pop-up Calendar for your Access Forms
Solve your date input headaches by providing the user with a pop-up
calendar. This tutorial shows how to use the Microsoft Calendar Control on
your Access forms and power it with some simple VBA code.
Customizing Parameter Queries
The question I get asked most of all in Access is "Can I have a drop-down
list in my parameter query?" With a little form design and a touch of VBA
code you can have just exactly what you need.
Access Query and Filter Criteria
New users are often baffled by the wealth of different ways you can ask
a query to look for data. This tutorial illustrates many useful criteria
expressions to get you started.
- Using Parameter Queries
You don't have to create a whole set of queries for each eventuality.
Instead you can use parameters in your query. These make the query ask the
user for some input, such as... "Which invoices do you want to see?"
- Parameter Queries: Handling Null Responses
Control what happens if the user leaves the parameter dialog blank.
- Calculating in Access Queries
One of the principal rules of databases is that you don't need to store
calculated data. Instead, you should get Access to do the calculations when
you need to see them. This tutorial explains the basics.
- Working with Dates in Access Queries
Sooner or later everyone needs to do some date calculations and, like
Excel, Access has a number of useful date-related functions. Using these
tools can greatly increase the scope of your date queries.
- Calculating Totals in Access Queries
The Totals tool is a powerful but often-overlooked feature of the ordinary
select query is its ability to calculate totals.
- Working Out a Person's Age
When storing personal data, it is normal practice to record a person's date
of birth rather than their age. This piece of data is constant, whilst their
age changes every year. Here's an easy way to get Access to calculate it for
More Access tutorials from my VBA section...
- Selecting Random Records from an Access
This tutorial uses both VBA and SQL to select records at random from a
table and place them into a new table with the aid of VBA's Rnd()
- Build Custom Functions for Your Access
If you ever thought that Access was a little short on calculating power,
this tutorial is for you. You will learn how to write a Custom function in
Access and find out how to make use of it in forms and queries.
- More Custom Functions for Access and Excel
If you're short of ideas for Custom Functions take a look at these. This
tutorial shows you how to build and use RandomNumbers,
FindSaturday, EOMonth and RemoveSpaces functions that
can be used in both Excel and Access. You will also see examples of If
Statements and Case Statements, and some built-in functions
that you might not have discovered yet.
Access Questions from my Mailbag section...