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

Chapter 6. Keeping Your Information Accu... > Using Data Type Settings to Restrict...

Using Data Type Settings to Restrict Data

The Data Type setting restricts entries to a specific type of data: text, numbers, dates, and so on. If, for example, the data type is set to Number and you attempt to enter text, Access refuses the entry and displays a warning.


In this exercise, you will create a new blank database, add fields of the most common data types, and experiment with how the Data Type setting and Field Size property can be used to restrict the data entered into a table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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