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.
Course details and outline can be found at https://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
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.
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.