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

Chapter 12. Creating a Database with Acc... > Specifying Data Types and Field Prop...

Specifying Data Types and Field Properties

Access provides different data types— field formats that define the kind of data the field can accept—which cover a wide variety of data. When you choose a data type for a field, Access will accept data entered only in the format specified by the data type. Selecting the appropriate data type makes it easier for users to enter and retrieve information in the database tables. It also acts as a check against incorrect data being entered. For example, a field formatted to accept only numbers removes the possibility that a user will erroneously enter text into the field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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