Microsoft Access Security: How To Login Into Your Access Database
With the release of Microsoft Access 2007 introducing a new file format (ACCDB), the Microsoft Access security completely changed. In fact, it dropped the MDWworkgroup security utility altogether in favour of trusted locations and/or using SharePoint.
However, I wanted to have the ability to control my own collection of objects within my Access database and not rely on either a third party tool or online service but instead keeping it all in one place having full control of my database.
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 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 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.
In fact, when I train this area of MS Access, I normally categorise into four types of use for such an object; these are:
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‘!
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.
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.
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.