To assign a data type or format to a field

To assign a data type or format to a field:

To use Design view to create a new table:

1. Activate the Create tab.

2. Click Table Design in the Tables group. Access changes to Design view and the Table Tools become available.

To set field properties:

1. Click the field for which you want to set the field properties.

2. Activate the General tab in the Field Properties area.

3. Set the properties you want to set.

4. Repeat steps 1 through 3 until you have set all the properties for all fields.

Date/Time

Use for dates and times.

Currency

Use for currency.

Prevents rounding during calculation.

AutoNumber

Unique sequential numbers or random numbers automatically inserted when you create a record. Use to create a primary key.

Yes/No

Logical data. Use when only one of two values is valid. Yes/No, True/False, etc.

Hyperlink	Use to store hyperlinks.
Attachment	Use to store attachments.
OLE Object	Use to attach an OLE object such as a Word document, Excel spreadsheet, or PowerPoint presentation.

JoxTech