• 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:

Text Plain, ordinary typing, which can include numbers, letters, and symbols. A Text field can contain up to 255 characters.

Memo More 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).

Number A plain, ordinary number (not currency or a date). Access won't allow any text.

Date/Time Simply a date or a time.

Currency A number formatted as an amount of money.

AutoNumber Access fills in a consecutive number for each record automatically.

Yes/No The answer to a true/false question. It can contain one of two values: Yes or No, True or False, On or Off.

OLE Object A link to another database or file. This is an advanced feature which we won't cover in this book.

Hyperlink A link to a location on the World Wide Web. (See Lesson 25 for more information.)

Lookup Wizard Lets you create a list to choose a value from another table or list of values in a combo box for each record. It is an advanced feature that we won't cover here.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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