• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Working with Tables > Understanding Data Types

Understanding Data Types

When you create a field, it's important to select the most appropriate data type for the information you want to store in that field. Data type refers to the particular class of information. For instance, text information can be letters, numbers, or any other combination of characters on a keyboard. Fields with a number data type, however, can only contain numerical data. This allows Access to perform calculations on the data in number fields, which isn't possible for the numbers in text fields—just try finding the sum of a number and a name.

Access gives you a variety of data types to choose from, each with its own unique properties. You should have no trouble finding the best data type for your fields. Figure 3.20 shows the menu used to set a field's data type while the table is in Design view.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint