Speed up table creation with default field settings
When you add fields to a table, Access assumes you want to use a 50/255-character Text field by default. However, you may typically use a smaller field size or you may personally use Number fields more often than Text ones.
You can avoid having to change the size and data types for new fields by setting defaults that are appropriate to your own design habits. To do so:
Choose Tools> Options from the menu bar and switch to the Tables/Queries sheet.
Select the data type you use most from the Default Field Type dropdown list.
Set the Text and Number sizes you usually want to use in the Default Field Sizes panel and
In Access 2007 go to Access Options>Object Designers: