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

Lesson 8. Creating a Table Without a Wiz... > Understanding Data Types and Formats

Understanding Data Types and Formats

Each field must have a type, so Access will know how to handle its contents. Here are the types you can choose from:

TextPlain, ordinary typing, which can include numbers, letters, and symbols. A Text field can contain up to 255 characters.
MemoMore plain, ordinary text, except you don't set a maximum field length, so you can type an almost infinite amount of text (64,000 characters).
NumberA plain, ordinary number (not currency or a date). Access won't allow any text.
Date/TimeSimply a date or a time.
CurrencyA number formatted as an amount of money.
AutoNumberAccess automatically fills in a consecutive number for each record.
Yes/NoThe answer to a true/false question. It can contain one of two values: Yes or No, True or False, On or Off.
OLE ObjectA link to another database or file. This is an advanced feature that this book doesn't cover.
HyperlinkA link to a location on the Web. (See Lesson 27 for more information.)
Lookup WizardLets you create a list to choose a value from another table or list of values in a combo box for each record. It's an advanced feature that you'll learn more about in Lesson 16.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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