Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button

Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button

Building Access forms is a time consuming aspect to front-end database designs and in this Microsoft Access tutorial, I want to add some extra aesthetics and alternative control enhancements for you.

There are many Access form controls, formats and properties that can be applied to a form over and above the basics ranging from the more advanced conditional formatting options to the custom built controls including my recent post on coloured tab controls.

So here’s some alternatives for your traditional command button…

Microsoft Access Tutorial How To Build Alternative Access Form Controls

Using the standard command button, you can still apply different format effects using the correct event with some Access VBA code or Continue reading “Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button”

Microsoft Access Queries: 7 Basic Things to Know About MS Access Queries

Microsoft Access Queries: 7 Basic Things to Know About MS Access Queries

As I have mentioned before, Microsoft Access queries is considered the most important object in your database. It’s the heart of the system and if you bypass it, there’s simply no life to your application!

Just to put words into pictures, have a look at this simple diagram below (taken from one of my eBooks)

microsoft access queries - object workflow

You can see the above ‘Middle’ tier is a query which sits comfortably in the middle servicing all other key ‘Access‘ objects. Now imagine there were no queries! How inflexible would your tables, forms and reports be?

The query brings together the main source files (tables) which are compiled and churned out into Continue reading “Microsoft Access Queries: 7 Basic Things to Know About MS Access Queries”

How To Design An Access Database: Take The First Step And Plan It

How To Design An Access Database: Take The First Step And Plan It

It’s that time of year again where new students need ‘real world’ induction and training and that sometimes includes Microsoft Access.

But the very first step in learning how to use MS Access is to have a database application in mind and in order to know how to design an Access database.

Here’s a quick (four and half minutes) video tutorial to help explain the concepts. Take a look…

httpvh://www.youtube.com/watch?v=aBhK61KMqYs

How To Design An Access Database: Take The First Step And Plan It

You will find most database systems are typically based Continue reading “How To Design An Access Database: Take The First Step And Plan It”

Setting Your Forms And Reports In Access As The Defaults

Setting Your Forms And Reports In Access As The Defaults

If you are regular as clockwork like me (I mean creating Access databases that is), then setting your forms and reports in Access other than using the ‘Normal‘ blank default should help – but does it?

Just to bring everyone else up to speed, you can set your MS Access form and report defaults by typing the name of your custom form or report in place of the standard ‘Normal‘ option which means all new objects will inherit these designs as the template style going forward – saving you some extra design time!

forms and reports in access defaults

To set your defaults:

  • for Access 2010/2013 go to  File | Access Options |  Object Designers,
  • for Access 2007 go to the Office Button | Access Options | Object Designers,
  • for Access 2003 (and earlier) go to  Tools | Options | Forms/Reports.

However, your forms and reports will not Continue reading “Setting Your Forms And Reports In Access As The Defaults”