Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book