This article explains how to use validation rules and validation text in table fields and form controls.A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form.Access provides a number of ways to restrict input: You can use these methods of validating data alone or in combination with each other.Data types are not optional, and provide the most basic type of data validation.For more information about data types, field sizes, and input masks, see the article Introduction to data types and field properties.You can define validation rules for table fields and for controls on forms.A Backup system is merely part of a recovery system.
To add validation rules to a table, you open the table and use commands on the Fields tab of the ribbon.
Do you regularly make sure that you can restore a database from your backups? There’s an old saying “Your data is only as good as your last backup.” That’s very true.
I know that you’re probably running regular database backups. But, there’s a little known corollary to this: “Your backups are only as good as your last restore.” It’s great that you’re backing up your databases, but you need to do more. The ultimate test for any backup is a restore to a server, but there are a few other things you can do as well.
In this article I argue for a fully automated, continuous regression testing based approach to database testing.
Just as agile software developers take this approach to their application code, see Agile Testing and Quality Strategies, we should also do the same for our databases.