Input Data Validation and Masks for Southern Dog Club DB Solution - MS Access Beginner Tutorial

Because we are a slow talker, we recommend you use the YouTube "Tools Cog" on the player bar to watch the video at a speed of 1.5x or even 1.75x.

In this Lesson we provide Validation Rules that check all data entered into the Member and Dog Tables for the Southern Dog Club.

We also look at how Input Masks can be used to assist Users with correct data entry of Phone Numbers, Post Codes, and Member IDs into the Database.

This video lesson contains detailed instructions on how to set up Validation Rules, Masks, and Custom Error Messages.

Even if you are not doing our full Access Learning Course, this video will show you how to do Input Validation in MS Access.

The Lesson Support Materials mentioned in the video can be found on our website at the link below:
https://tinyurl.com/y8cska2d

If you are a Teacher watching this video then click the downloads link and get all of the lesson materials for your students.
These Downloads include detailed Step by Step Instructions and well as the PDF Analysis Document for the Southern Dog Club Solution, and the Tables Design Spreadsheet.

Give these resources to your students and we think you will find that some of them will "get it" very quickly. The other students need to watch this video which goes through everything in full detail slowly step by step with repetition of examples.

This is a detailed video, if you want to fast track learning, then just Download and quickly work through the PDF of Step by Step Instructions using the Link given further down below.

Then for anything you do not fully understand in the Lesson Instructions, simply use the Timeline Index below to go and watch the relevant section of Video explanation.

If you have the time it will be extremely beneficial to watch the entire video to maximize learning outcomes.

VIDEO TIMELINE INDEX:

00:00 to 03:40 Introduction and Lesson Overview
03:40 to 04:43 Getting the Start Database and Downloads
04:43 to 06:14 List of Validations that are Needed
06:14 to 11:26 Fields Not Blank Validation
11:26 to 13:28 Adding Number Range Validation
13:28 to 19:15 Creating Custom Error Messages
19:15 to 20:39 Remaining Validations to Do
20:39 to 25:00 Date Validations
25:00 to 27:37 Using OR Statements
27:37 to 28:24 Remaining Validations to Do
28:24 to 33:37 Email Address Validation
33:37 to 34:06 Or Statements Revisited
34:06 to 36:29 Input Data Masks Overview
36:29 to 40:35 Masking Member ID Code
40:35 to 41:46 Member ID Mask in Dogs Table
41:46 to 44:06 Masking Dog Rego Number
44:06 to 45:50 Validation of Phone Numbers
45:50 to 47:11 Input Masking Phone Numbers
47:11 to 48:32 Input Mask for Post Code
48:32 to 50:20 Full Testing of Tables Validation
50:20 to 50:40 Input Masks Quick Reference Table
50:40 to 51:14 Saving the Database
51:14 to 52:12 Database Tables Current Status
52:12 to 53:10 Where to Next - The Rest of the Course
53:10 to 53:43 Our MS-Access Beginners Course
53:43 to 54:12 Video Outro

This video will be useful for anyone learning Computing, especially students doing VCE Applied Computing or VCE Data Analytics or HSC Computing high school courses in Australia, and GCSE in the UK.

Check with your Teacher or Instructor before getting any Downloads from our Website, as they may already have these materials for you.

You can download a hard copy of the Step By Step Instructions Guide, and the Full Analysis and Overview Document at the following link:
https://tinyurl.com/y8cska2d

Check with your Teacher or Instructor first, as they may already have these Download materials for you.

You can check out our MS-Access Beginners Course at the following link:
http://passyworldofict.com/access-sdc/

We are planning to make a number of Video Lessons that will be a great course for people to learn how to build Databases using Microsoft Access.

Like this video if you found it helpful.

Subscribe to our Channel to get notified of our weekly video updates.

Enjoy,
Passy

Видео Input Data Validation and Masks for Southern Dog Club DB Solution - MS Access Beginner Tutorial канала Passy's World of ICT