Data Entry - Tables Vs Forms

[Mae]

I have seen several people mention that it is better to
enter data through forms, rather than directly in the
tables. Why is that? I prefer the linear layout of the
table, and I also like having all of my records right
there in front of me as I'm doing my data entry. As an
open-minded person, who is always looking for a better
way, however, I'm willing to be persuaded if anyone can
help me see the benefit of forms.

Thanks for your insight...

 

[Pat Garard]

G'Day Mae,
When you use a Form, the scope for checking Data Integrity
is huge.
You may validate data exhaustively, according to complex
conditions, or even against data from a different database.

This is not possible with DataSheets.

You can format a Form to give an appearance somewhat
similar to a DataSheet if there is a need.
--
Regards,
Pat Garard
Australia

Anne & Pat Garard.
apgarardATbigpondDOTnetDOTau
_______________________________________________

 

[Rick Brandt]

I have seen several people mention that it is better to
enter data through forms, rather than directly in the
tables. Why is that? I prefer the linear layout of the
table, and I also like having all of my records right
there in front of me as I'm doing my data entry. As an
open-minded person, who is always looking for a better
way, however, I'm willing to be persuaded if anyone can
help me see the benefit of forms.

Thanks for your insight...

Because all but the simplest of databases need to take advantage of the
events in forms to facilitate data entry and there are no such events when
using a table or query datasheet. In addition, There are validation rules
that can be done with forms that cannot be done at the table level.

That prevailing opinion that you speak of is voiced in the context of
*Developers* who create programs for *other people* to use. The point is
fairly moot when talking about a database for your own personal use.