Tables and queries

[Guest]

Why are database tables and queries protected and forms and reports used
instead of datasheets?

 

[Tom Ellison]

Dear Princess:

Forms and Reports have capabilities not readily available in tables or
queries.

Forms are interactive (to whatever extent that intelligence is designed into
them).

Reports have easy ways of formatting the data into columns.

Both have sub-section capabilities not generally found in tables (although
there have been minimal attempts at creating some functionality).

Generally, I believe mature designers consider tables and queries as
fundamental steps toward building forms and reports.

Your humble servant,
Tom Ellison

 

[Pat Hartman\(MVP\)]

Tables and queries aren't protected unless you implement security to prevent
their use. Forms are preferred for user interaction because they provide
events that can be used to validate data and keep users from adding bad data
to the tables. Reports are used rather than tables/queries because they
provide more flexible formatting and have the capability of providing
multiple levels of subtotals.