Tables

DESCRIPTION OF DESIGN VIEW

• Field Name - This is the name of the field and should represent the contents of the field such as "Name", "Address", "Final Grade", etc. The name can not exceed 64 characters in length and may include spaces.

• Data Type is the type of value that will be entered into the fields.

• Text - The default type, text type allows any combination of letters and numbers up to a maximum of 255 characters per field record.

• Memo - A text type that stores up to 64,000 characters.

• Number - Any number can be stored.

• Date/Time - A date, time, or combination of both.

• Currency - Monetary values that can be set up to automatically include a dollar sign ($) and correct decimal and comma positions.

• AutoNumber - When a new record is created, Access will automatically assign a unique integer to the record in this field. From the General options, select Increment if the numbers should be assigned in order or random if any random number should be chosen. Since every record in a datasheet must include at least one field that distinguishes it from all others, this is a useful data type to use if the existing data will not produce such values.

• Yes/No - Use this option for True/False, Yes/No, On/Off, or other values that must be only one of two.

• OLE Object - An OLE (Object Linking and Embedding) object is a sound, picture, or other object such as a Word document or Excel spreadsheet that is created in another program. Use this data type to embed an OLE object or link to the object in the database.

Hyperlink - A hyperlink will link to an Internet or Intranet site, or another location in the database. The data consists of up to four parts each separated by the pound sign (#): DisplayText#Address#SubAddress#ScreenTip. The Address is the only required part of the string