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”

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”

Microsoft Access Features And Functionality: What Has Been Discontinued Or Modified In Access 2013

Microsoft Access Features And Functionality: What Has Been Discontinued Or Modified In Access 2013

Teaching and migrating to version 2013 has thrown up some Microsoft Access features which have since been dropped (or deprecated as we call it). Perhaps we should re-title this post as “Microsoft Access: Mind The Gaps!”

Not all the features I will list below in this post have completely gone; just been modified which is of course a good thing providing you are not too emotionally attached to the older style features of course.

microsoft access features

For me, as seems to be the case for the vast majority of developers and users I’ve spoken to, that they Continue reading “Microsoft Access Features And Functionality: What Has Been Discontinued Or Modified In Access 2013”

Access Database Forms: Working On Various Ways To Apply Read Only To Your Access Form Design

Access Database Forms: Working On Various Ways To Apply The Read Only State To Your Access Form Design

Whichever version of Microsoft Access you are currently using, working with and designing Access database forms can be time consuming, challenging and unpredictability, misbehave!

The key to a successful form requires two key elements; a) a design plan with scope and b) knowing what form properties to apply to control workflows.

It’s the second aspect I want to highlight in this blog post today and in this example, learning how to set a form and behave as ‘read only’ can be achieved in one of several ways.

To get started, take a quick look at this video tutorial (it’s less than 4 minutes) which demonstrates how to apply a ‘read only’ state for a form.

httpvh://www.youtube.com/watch?v=0GHShQ2On8I

Now the author covers Continue reading “Access Database Forms: Working On Various Ways To Apply Read Only To Your Access Form Design”

Microsoft Access Forms: What Are The Pros And Cons Of Using Unbound Access Database Forms

Microsoft Access Forms: What Are The Pros And Cons Of Using Unbound Access Database Forms

As you may have gathered, one of my roles within this niche covers IT software training. When teaching Microsoft Access forms (usually during day 2), delegates would normally be shown the quickest method of creating such forms and that means using either the Access form templates or the built-in wizard tool.

This of course means most forms (if not all) are ‘bound‘ forms or in other words, have a data source file attached whether it be a table or query.

microsoft access forms

In fact, when I train this area of MS Access, I normally categorise into four types of use for such an object; these are:

1. Data Entry Form – Forms which

Continue reading “Microsoft Access Forms: What Are The Pros And Cons Of Using Unbound Access Database Forms”

MS Access Report Design Tip: How To Hide Duplicates (Selectively) In Your Access Reports

MS Access Report Design Tip: How To Hide Duplicates (Selectively) In Your Access Reports

One of the many tips within the access database design vault are normally hidden secrets of unknown properties. For your Access report design collection of properties, you may have noticed a wealth of useful attributes to choose and one in particular I want to highlight is the ‘Hide Duplicates‘ property for reports.

However, this property is not perfect as I will explain in a moment. Instead, you may want to use another hidden property (outside of the Access VBA library) that can actually be applied directly to your Access report designs. The property in question is called ‘IsVisible‘!

access report design

From the illustration above, I’m showing three different instances of the same report. The first is a normal typical list report of customers, the order date, order number and products for each order. The second instance  Continue reading “MS Access Report Design Tip: How To Hide Duplicates (Selectively) In Your Access Reports”

Bar Code Font That Can Be Freely Used With Microsoft Access

Bar Code Font That Can Be Freely Used With Microsoft Access

Many Microsoft Access databases are designed to manage the products and order workflows of any production based or manufacturing business and with any delivery note or dispatch document using bar codes makes capturing data very easy.

However, your operating system (typically Microsoft Windows) will not have a default bar code font installed but with this free resource courtesy of BarcodesInc, you can now download and install the free fonts that is available across Windows and not just for MS Access.

bar code font for ms access

When you download and install this new font, you add Continue reading “Bar Code Font That Can Be Freely Used With Microsoft Access”

Access Form Design: Discover My 10 Key Properties To Your MS Access Database Designs

Access Form Design: Discover My 10 Key Properties To Your MS Access Database Designs

I wrote an article last year of my 10 key properties to Access form design which is just the beginning to mastering an access database that help to control and improve the look and feel to your application.

access form design

I’ve decided to add it here in my blog as this has recently come back as a discussion in a recent training course that Continue reading “Access Form Design: Discover My 10 Key Properties To Your MS Access Database Designs”

Microsoft Access Database Normalization Versus DeNormalization

Microsoft Access Database Normalization Versus De-Normalization

To normalize or to de-normalize that is the question!

Database normalization is widely misunderstood. Any new database system should adopt some level of database normalization (a minimum of ‘Third Normal Form (3NF)’) but what does this really mean?

The idea behind database normalization is to protect and maintain the data integrity keeping your data complete and consistent when storing data (input) to handling effective reporting (output). Keeping records in one place which can be related and impact data values in other places is the trick and this is why normalization is normally the methodology used here when designing an Access database.

Having smaller and re-usable manageable units of information maintains Continue reading “Microsoft Access Database Normalization Versus DeNormalization”