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

Lesson 5. Creating a Table from Scratch > Understanding Data Types and Formats

Understanding Data Types and Formats

To assign appropriate data types to the fields you create in a table, it is necessary for you to know what differentiates the different data types available for use with your table fields. When you create a field, you want to assign it a data type so that Access knows how to handle its contents. The following are the different data types you can choose:

  • Text— Text and numbers up to 255 characters (numbers that are not going to be used in calculations).

  • Memo— Lengthy text.

  • Number— Numbers used in mathematical calculations.

  • Date/Time— Date and time values.

  • Currency— Numbers formatted for currency.

  • AutoNumber— Sequentially numbers each new record. Only one AutoNumber field can be placed in a table. This field type is typically used for the primary key field.

  • Yes/No— Lets you set up fields with a true/false data type.

  • OLE (Object Linking and Embedding)— A picture, spreadsheet, or other item from another software program.

  • Hyperlink— A link to another file or a location on a Web page. This field type lets you jump from the current field to information in another file.

  • Lookup Wizard— This field type chooses its values from another table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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