Microsoft access 2016 validating

31-Dec-2017 06:52

If, as the cooks say, a recipe is only as good as its ingredients, a database is only as good as its data.

Viewing, summarizing, and analyzing the data are meaningless if the table you're working with contains erroneous or improper data.

By "improper," I mean data that falls in either of the following categories: NOTE To stress the importance of data entry, consider the story told to me by computer book author Greg Perry.

Greg used to work for a large Fortune 500 company, and he says that the company made its data entry clerks enter all data : One clerk would enter the data in a file and then, when finished, another clerk would enter the same data.

microsoft access 2016 validating-11

sex dating in brewster washington

The lesson, he says, is that to the company, accuracy was far less costly than paying its employees to do the same job twice.

You have two choices: For example, Figure 3.1 shows the Mortgage Calculator form.

Notice the labels added beside the Interest Rate and Term text boxes that specify to the users that they must enter the interest rate per annum and the term in years.

It's important because the data must be entered accurately; otherwise, any analysis of the data becomes at best misleading and at worst just plain wrong.

The danger, then, lies in the fact that data entry is prone to errors but can't afford to have any.I am creating another table to hold the actual Goal for each Category that I will set independently each month.