Creating a Table in Table Design View
When you create a table in the Design view, you are creating the structure for the table; you create a list of the fields that will be in the table. You also select the data type for each field. (Fields can hold text, numbers , even graphicsyou learn the types of fields that can be created later in this lesson.) You also have the option of entering a description for each field. Field descriptions are useful in that they provide a quick summary of the type of data that goes into the field.
Another issue that relates to creating a table in the Design view (or editing a table's structure in the Design view) is that any changes you make must be saved before closing the table. If you have worked in other applications, such as Word or Excel, you might think that saving your work is just common sense. However, when you actually start working on entering data into a table or a form, Access automatically saves your records as you enter them. Therefore, in Access, you need to remember to save only the changes that you make to the structure of a table, form, query, or report. You learn more about this in Lesson 6, "Editing a Table's Structure."
Field Naming Rules Field names in Access can be up to 64 characters long and can contain spaces and both alphanumeric and numeric characters. You can't use periods or exclamation points in your field names. Also, avoid special characters (such as $, %, or #) in field names because some of these characters have special meanings in Access code.
To create a table in Table Design view, follow these steps:
Deleting a Field Ifyou enter a field and decide that you don't want it in the table's structure, select the field (its entire row) and press the Delete key.