Microsoft Access Database Templates – Some Are Even Free!

Microsoft Access Database Templates – Some Are Even Free!

With the latest version of Microsoft Access database (2016) and following on with tradition, Microsoft provides a selection of free Access templates and these can be found via a new database file action where thumbnails are available to get you started.

Quite a few of the standard templates are reasonable and they do require more custom design time to at least make them more user friendly.

microsoft-access-2016-task-template-database

However, take the above ‘Tasks’ database example which created several different objects including tables, queries, forms and reports – In fact, 30 objects were generated which also included macros and a little VBA code.

Other database templates can also been found like Continue reading “Microsoft Access Database Templates – Some Are Even Free!”

Designing An Access Database: Some Simple Steps For Your New MS Access Database

Designing An Access Database: Some Simple Steps For Your New MS Access Database

As I have preached many times and so it seems other Access database experts are of the same opinion, designing an Access database requires a plan, time and a methodical approach.

designing an access database

I found this article which is another perspective but similar to my 7 step MS Access database plan that may be worth a read – check it out below…

Create an MS Access Database – 9 Simple Steps to a Productive Database

STEP 1: Define the Purpose

Before you try to create an MS Access database first decide what the purpose for the database is. Software is much like a vehicle. Cars transport people from Continue reading “Designing An Access Database: Some Simple Steps For Your New MS Access Database”

How Building An Access Database To Your Own Specification Will Help

How Building An Access Database To Your Own Specification Giving You Total Control

One of my main ‘day’ jobs includes building an Access database and this would typically cover a wide range of tasks including an add-on report to an existing system, adding a new form interface making it more user-friendly, repairing errors and creating a new database from the ground up.

When applying to tender for a database build, often clients like to see my portfolio work as a way to measure my credentials as an Access database developer. Since most of my clients have sensitive data and processes, I just could Continue reading “How Building An Access Database To Your Own Specification Will Help”