Input Field Validation Tutorial for Microsoft Access 2019 and 2016

This video tutorial contains detailed instructions on how to add Validation checking onto fields in Access Databases.

(Note that Validation "Input Masks" are not covered in this lesson, and are part of a separate lesson dedicated solely to Masks).

Even if you are not doing our full Access Learning Course, this video will show you how to add Field Validations in MS Access.

The Tutorial Support Materials mentioned in the video can be found on our website at the link below:

Video Timeline Links - Click the blue timing number to go to that section.

0:00 Introduction
4:04 Database Design - List of Validations
5:05 Required Fields Not Left Blank Validations
9:55 Exception for "Long Text" type Fields
10:58 Testing the Form for Required Fields
13:16 Sellers Table - Fields not left Blank
13:42 Number Range Validation
16:17 Customising Validation Error Messages
17:33 Splitting Error Messages accross two lines
21:29 Date Validation
28:20 Email Address Validation
34:10 Phone Number Validation
35:35 Setting Sepcific Form Fields as Protected
41:44 Form View Modes
42:32 Saving the Database
44:06 Validation Assignments to Check Your Learning
44:49 Where To Next - Upcoming Lessons
46:03 End Message

Subscribe and check out the rest of our YouTube channel for more great tutorials.

Enjoy, Passy