Monthly Archives: August 2019

Microsoft Access database

The video is part 2 of the how to create a Microsoft Access database series. The information covered in this video is available as part of the Introduction Access course, details can be found at http://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.

Access database

This video explains how to start and create your own Access database. This tutorial is part one of many. The next series in this blog will be all about building a Microsoft Access database.

Access Database

Course details and outline can be found at http://www.itseasy.co.uk/courses/access-training/ Courses can be delivered onsite at your location, we can provide laptops or you can come to our training room in Gateshead. Every delegate will receive a training manual and after course support via email. Online courses are available at http://www.itseasytraining.co.uk

Table Design

The most important feature in Microsoft Access is the database design. The column titles and the data type are absolutely crucial to the database integrity. The video explains how to create input mask to prevent inaccurate data entry and how to add data validation rules to make sure dates for example are entered in the correct sequence. The video also explains the field properties, such as input masks, data validation, formatting and field size. It is important to get this foundation correct. The field sizes will impact on the database size if not set correctly, 255 characters is the default setting but often fields are much smaller.

Lookup tables

This first module quickly explains how to create a lookup table and name it. The tutorial covers how to add the lookup table to a field. lookup tables are a safe way to add data to a field because the data entry is already present and correct in the lookup table, therefore cannot be entered incorrectly. In follow up modules more details will be given on how lookup tables work and the different types.

Street Map

Street Map in Microsoft Visio

Using the 2D and 3D directional shapes in Microsoft Visio to build a street map can be frustrating if you only use the shapes that are available in the template. This video explains how to get the best out of custom shapes and a personal stencil and why they are so useful

Training

IT’s Easy Training provides two forms of training, onsite in out Gateshead training rooms or online at http://www.itseasytraining.co.uk. Course details for the classroom based courses can be found at http://www.itseasy.co.uk/courses/visio-training/ Courses are available on your own site anywhere in the UK if you prefer onsite training. We will provide laptops and a trainer.

Custom shapes

Creating custom shapes and adding them to your own stencil is a great way to speed up your drawings in Microsoft Visio. You may need to create several different stencil to cater for different template drawings and scaling issues, but once done you will find it well worth your while.

Stencils

It is a simple process to create new stencil, just select More Shapes and click on New stencil, name it and save it. To add shapes simply drag and drop them on to your stencil, remember to save the stencil. You will have to rename any shape that you add or create, simply double click on it and rename it.

Street Map

I find it useful to create groups of houses and road segments and then add them to my stencil. I achieve consistency of design and size doing it this way. There is nothing worse than shapes that are suppose to be the same appearing all over the place in terms of size and scale.