Microsoft Access database table design


The video is part 2 of the how to create a Microsoft Access database series, Access database table design. The information covered in this video is available as part of the Introduction Access course, details can be found at https://www.itseasy.co.uk/courses/access-training/ Online training courses are also available at http://www.itseasytraining.co.uk We can deliver training at your site with our laptops or you can come to our site in Gateshead. All courses have free after course support for each delegate via email and or video examples.

Calculations

This video explains how to use calculations in a Microsoft Access database table. The tutor covers how to create a calculated field and then use it. I have used many calculated fields in my own database, for example to flag up if an item has vat due or not. Creating an Access database calculation can save a lot of time on data entry and make data entry more accurate. The more automated features you have, such as database calculations and lookups the safer the data.

Data Types

All the data types are explained with examples of how to use them. The short text data type is now the default setting but the date/time data type is used very often. It is important to put an input mask on date field and not just rely on the format feature.

Primary Key

The primary key is a unique identifier and is not duplicated, fields like staff id or payroll number are usually best as a primary field. The primary key is used extensively when you start to join tables and create relationships in Microsoft Access database. You must take care in choosing a primary key, because if you get it wrong it can have a catastrophic effect on your data.

Validation rules

You can add data validation rules to your fields to make sure data entry is correct this video explains how this can be done. The video also covers how to add data validation rules at table level.






Leave a Reply

You must be logged in to post a comment.

Testimonials


“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group




“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services




“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA