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. | |
Post a Comment