O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Access 2002 Data Types

How do you know which data type to use for each field? Access enables you to use the text data type (default) for every field if you want to do that. But, in this instance, that approach is not wise for several reasons. You would not be able to sort numeric data properly and you would not be able to calculate the number of days between two dates at all. And this is just the tip of the iceberg.

The solution is to know the reason you are using the various data types. Let’s examine these and then put them into action by example. Figure 3.1 shows the Text data type being applied. It also shows the other data types that you can use.

Figure 3.1. A drop-down menu in table design showing the data type options available.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required