How To Document A Database: Using Microsoft Access Tools And Your Disciplines

How To Document A Database: Using Microsoft Access Tools And Your Disciplines

Oh the paperwork! Having spent a lot of time designing, developing and implementing your MS Access database you really should consider the housekeeping – so how to document a database?

You may feel that this task could be avoided altogether but what happens if:

  1. You are no longer wanted and someone else inherits your baby?

  2. You become all too important (promotion) and someone else needs to take over the responsibility?

  3. The business has grown and you don’t have the time to extend your database functionality?

  4. You need to provide technical and end-user training?

Without some sort of sensible database documentation, you and others are left with the potential exposure of database misuse, unstructured administration, a fragmented system and a lack of disciplines in carrying out essential repairs and tasks.

How To Document A Database

Therefore, a database design document will Continue reading “How To Document A Database: Using Microsoft Access Tools And Your Disciplines”

Microsoft Access Database Articles: Check Out My EzineArticles

Microsoft Access Database Articles: Check Out My EzineArticles

It’s too hot to work – taking a vacation!

While I’m away, checkout my Microsoft Access Databases EzineArticles or click that big ‘Diamond Expert Author’ logo to the right of my home page.

microsoft access databases articles

Microsoft Access Database Articles: Check Out My EzineArticles

Here are some of the direct links to popular articles:

Microsoft Access Database Design Tips – Want To Know 7 Quick Tips To Designing Your Access Database?

I’m often asked How do you design a good Access database? My simple answer is I Reverse engineer it when planning and designing an Access database! Reverse engineer it – What’s that? It’s not Continue reading “Microsoft Access Database Articles: Check Out My EzineArticles”

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: How To Print A Record In Access Through A Form

Access Database Forms: How To Print A Record In Access Through A Form

Interacting with Microsoft Access database forms provides that rich, smooth and harmonious way to control data with functionality. 

One popular feature is the ability to call another object namely a report for the active/current record and either preview or print a hard copy avoiding the extra steps of navigating and finding the same record via the database or navigation window.

So, how do you print just the one record you are viewing via the form?

access database forms how to print a record

You will first need to create your final report, setting the correct layouts for printing. Ideally, learn to use the primary key value that will Continue reading “Access Database Forms: How To Print A Record In Access Through A Form”

How to Use Smart Tags In Microsoft Access 2010

How to Use Smart Tags In Microsoft Access 2010

How to use smart tags in Microsoft Access will only be applicable to 3 versions (2003, 2007 and 2010). Forget about the earlier versions and now even with the latest Access 2013, this too has been dropped!

Since most users are still engaged with the main three releases mentioned, I thought it may be worth a re-visit to understand how to apply a smart tags for your fields in a table.

how to use smart tags in ms access 2010

The key decision to consider when a smart tag should be added will be to identify a benefit for a user-friendly list of actions for certain type of information (or value) being stored allowing users to simple choose from a pre-set list of actions.

For example, a contact name field in a table (or form) could be best served to assist with Continue reading “How to Use Smart Tags In Microsoft Access 2010”