Datavalidation with Access Macros

There's actually a number of ways we can validate the data on our Access forms. DatabaseDev lists 5 different ways in the article, Validating Data in MS Access. Of these, we've already seen and used the first 4! Don't believe me? Take a read now and verify that you understand the first 4... (we can talk together in class about these).

Now we're ready to learn the 5th - and most useful way... using the Before Update event to run a Macro!

Read carefully through Input Validation with an Access Macro before using this tutorial to add input validation to your Yahoo! Movies database. For example,

1. Make sure that each new movie has a title and rating before it is submitted.
2. Make sure that each new Complex has a Name and Location before it is submitted.