Computer Services Worcester – Creating Access Databases

Computer Services Worcester

When you are starting off writing an Access database the temptation is to launch straight into it. My advice is to start off with a large white piece of flip chart paper and map out all your data tables with their fields and relationships on it. This will really help you to focus on the data which is most important and where fields should be stored.

A lot of people approach using Access like they do with Excel, “I’ll jump straight in and pick it all up as I go along I’m sure?”. They load up the package like they would do Excel and think that they will be able to start using it straight away. However that is not necessarily how Access works, you have to create data tables with fields and relationships before you can utilise Access to create Queries or Reports.


Top five tips for creating a database

  • Map out your data tables on paper first (this can help you visualise what you want to achieve)
  • Don’t duplicate data fields other than the primary keys where necessary
  • Test out using data table entry first before creating forms
  • Introduce some simple queries to test out the relationships
  • Always involve your customers from the start – never develop in isolation

For Computer Services Worcester, including Access training courses as well as Microsoft Excel Training in Birmingham, Worcestershire, Gloucestershire, Herefordshire, Warwickshire, Leicestershire get in touch on 07903 840105 or email us on

We have a number of hints and tips on our website. A lot of them are within the Excel package as that is the topic that people most find useful, however we do have some in Access too! To take a look at some of these hints and tips, click here to browse through the ones we have created.

If you liked this hint and tip, why not take a look at our previous one on the different faces of the SUM function?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy