Programming errors? Nope, none that come to mind.
However, "garbage in garbage out"... So your querying and filtering will be
interesting and useless. Allowing Users to type anything they want anywhere
they want will make it difficult, if not impossible, for your Users to have
workable data. Let's look at City Name... You want to Filter by all the
people that live in Brooklyn. Only, some people misspelled Brooklyn or they
abbreviated it, now what? Your Users will not get accurate information and
you will spend more than half your time cleaning that field up because your
Users are blaming the database for inaccurate results. Use Data Validation
wherever you can, it pays for itself in the end.
Gina Whipp
Microsoft MVP (Access)
<http://www.access-diva.com/> Description: access-diva
Specializing in MicrosoftC AccessR Solutions
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of RalphCelento
Sent: Monday, September 17, 2012 10:19 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Data validation techniques
My experience without data validation and format controls you get lots of
garbage data and it becomes difficult if not impossible to manage or analyze
the data for leadership or decision makers.
Ralph
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , MEL
<girl_moon_godess@...> wrote:
>
> What are major programming errors that have occurred because data
validation techniques were not used.
>
>
> Thanks
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar