Microsoft Access Database: Creating Database Field Type Templates

Microsoft Access Database: Creating Database Field Type Templates

Microsoft Access database applications just gets richer and richer as time goes by and from version 2010, you can now create field types or in effect user defined fields stored via the ‘Save Selection as New Data Type‘ command which is located from the context sensitive fluent ribbon bar Fields tab (Table Tools).

Take a look at a demonstration of this is set up and used in the video tutorial below (less than 4 minutes).

Microsoft Access Database (version 2010 onwards) has a new feature which allows you to preserve existing columns that you can use Continue reading “Microsoft Access Database: Creating Database Field Type Templates”

Microsoft Access Database – My Very Own Custom Built Utilities

Microsoft Access Database – My Very Own Custom Built Utilities

This time of year and over the last few weeks, we get new users or students entering the Microsoft Access database arena from people of various walks of life whether that is a student learning about IT and computer based systems or starting a new job or career wanting to brush up on their skills that I like to remind all of my custom built utilities which serves more than one objective.

microsoft access database custom built utilities

The tools I offer are not free but they do come with a money back guarantee and 30 day email support so you can at least try and ask questions. The main point to Continue reading “Microsoft Access Database – My Very Own Custom Built Utilities”

Microsoft Access Database: Working With A Database You Didn’t Create

Microsoft Access Database: Working With A Database You Didn’t Create

Working with Microsoft Access database is a skill to have and makes you stand out from the crowd of advanced Excel spreadsheet users and those wishing to step up and move into the world of MS Access will probably start by inheriting other people’s databases.

So what’s the first thing you need to do if you are given someone else’s Access database?

microsoft access database working with a database you didnt create

I wrote another post about a couple of years ago which addressed the challenges of inheriting other people’s Microsoft Access databases and Continue reading “Microsoft Access Database: Working With A Database You Didn’t Create”

Concatenating Multiple Rows Into Single Line In MS Access

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

Now I’m not going to take credit for this next piece of Microsoft Access database VBA code as it was originally created by a well-known Allen Browne – many thanks!

Instead, I’m going to borrow his code for you (my regular readers) just in case you haven’t seen this before and add an element of quickly adding criteria to a query as a workaround to avoid expanding the VBA code itself.

concatenating multiple rows into single line in ms access

There are potential problems and errors this code will throw at you if you try to add criteria in the normal manner or embed any SQL directly into the calling custom function which means using some common sense and logic to deal with the challenge here.

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

First of all, let’s get the function to work and the query understood. In a new module, you will need Continue reading “Concatenating Multiple Rows Into Single Line In MS Access”

What Types Of Things Can I Do With A Microsoft Access Database?

What Types Of Things Can I Do With A Microsoft Access Database?

Microsoft Access offers a variety of different ways to how a database can be used. There are six general types of applications which a database will naturally fall under. They are:

• Personal or One-to-one use

• Small-business (SME) use

• Departmental use

• Corporation-wide use

• Front-end only use (client/server databases)

• Web use

Of course the above uses can be merged into each other but at the very beginning when planning your Access database, you need to know the scope and general use – hence the above categories.

microsoft access database design processes

At a basic level, you can use Microsoft Access to develop simple, personal database-management systems (which can also be relational – RDBMS). Some users automate everything from their music CD collections to their home finances and is very easy to use with the built in templates and where applicable wizard tools that make MS Access look like a product that anyone can use.

With the prompts for a new database and after Continue reading “What Types Of Things Can I Do With A Microsoft Access Database?”

Auditing Your Microsoft Access Database: Tools And Data Processing

Auditing Your Microsoft Access Database: Tools And Data Processing

I’ve talked about the importance of auditing your Microsoft Access database before and it amazes me how developers and power users take this not seriously enough and cut corners.

There are two areas that can be considered the action of carryout some sort of audit to your database application which have been mentioned this is the past.

Auditing Your Microsoft Access Database
Auditing Your Microsoft Access Database

However, I found the following article Continue reading “Auditing Your Microsoft Access Database: Tools And Data Processing”

The Pros And Cons Of Using Access Queries Or Table Recordsets In A Form

Microsoft Access Database: The Pros And Cons Of Using Access Queries Or Table Recordsets In A Form

I wrote the following article this week based on a comment from a facebbok fan who wanted to know which type of record source should you use when building Microsoft Access database forms and reports.

microsoft access database record source

Here’s the aritcle…

You build your database using tables and queries testing the architecture and setting keys and indexes. Then you want to make the reporting easy to use and pretty to look at and now you are into spending

Continue reading “The Pros And Cons Of Using Access Queries Or Table Recordsets In A Form”

Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database Running Over a Network

Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database System

microsoft access database lan

I found the following article which gives you some pointers on how to speed up a slow running Microsoft Access database application when being shared over a network (LAN) and your Access database is playing the role of ‘Client/Server‘ as part of your business IT systems.

Take a look, read on…

Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database Running Over a Network

Microsoft Access is the perfect tool for building databases for companies of all sizes. However, when it comes to sharing that database over a network, amongst Continue reading “Microsoft Access Database: How To Speed Up a Slow Microsoft Access Database Running Over a Network”