Data Validation in Forms and Tables

[Nikki225]

I'm currently trying to build an access database based off of data that I have in excel.

Right now, I'm creating the tables and will eventually begin working on the forms for data entry.

If I'm going to require users to use the forms for data entry, is there any reason to have data validation in both the form controls and the table?

Thanks

 

[Micron]

It would be redundant to have both. At the table level, you will have to be happy with those limitations. At the form level, you can do much more, such as what to do if fieldA is less than fieldB, plus you can have more robust messaging to the user. BTW, the step after tables is not forms, it is queries that work, assuming you have your relationships mapped out (at least in your schema if not actual defined Access relationships).

 

[Nikki225]

Thanks. That makes things easier.