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”

Is Access A Relational Database – It Is But There Are Other Models Too

Is Access A Relational Database – It Is But There Are Other Models Too

If you have been working with Microsoft Access for a while now, you should be building databases the correct and perceived way but Is Access a relational database?

You should be familiar with the term RDBMS which stands for Relational Database Management System and this is the true definition for MS Access (as defined by Wikipedia) emphasising on ‘database management system‘.

However, DBMS comes in many shapes and sizes depending on the database processes, workflows and the size of the organisation.

Is Access A Relational Database

Therefore, there are different types of DBMS’s and here are some for you to contemplate and evaluate which Continue reading “Is Access A Relational Database – It Is But There Are Other Models Too”

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”

MS Access Tools: How To Convert And Deploy An Access Database File As An Executable (ACCDE Or MDE)

MS Access Tools: How To Convert And Deploy An Access Database File As An Executable (ACCDE Or MDE)

Building your Access database for others who do not necessarily have the MS Access application or need to gain access to the design environment means wrapping and converting your file into an executable format (ACCDE or MDE). Using the MS Access tools available, this is just a start to a full deploy-able solution.

Take a look at this quick video (less than three minutes) showing first the process to convert your ACCDB/MDB file into an executable format and then introducing you to the free independent downloadable install script turning this into a polished application…

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

There are some Continue reading “MS Access Tools: How To Convert And Deploy An Access Database File As An Executable (ACCDE Or MDE)”