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 MDW workgroup 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.
You can still apply a basic and global database file password to your ACCDB files but everyone will need to use the same password and gain access to all areas of your database – not really recommended!
So, how can you login into your own custom built database with the later versions (2007, 2010 & 2013) and take full control or your own access rights?
Well, the simple answer is to build it yourself and mimic the Workgroup and Access Rights utility of old.
Check out: Building Your Very Own Access Database Security Offer
The advantage here of course is you have full control of what level of security you really need and eliminate all the unwanted other elements that Continue reading “Microsoft Access Security: How To Login Into Your Access 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…
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
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…
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
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.
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 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.
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
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:
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
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‘!
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
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.
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
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.
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 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”