Creating Tables Without the Wizard
Although the Table Wizard provides an easy method for quickly creating tables, it does not provide you with complete control over all the aspects of creating the table. It does allow you to select the fields used in the table from a set list, but it restricts you to only those predefined fields (there are also several types of fields, each used for a different data type). Creating tables from scratch in the Design view allows you to build the table from the bottom up and gives you complete control over all aspects of the table's design.
This view allows you to enter field
The Design view isn't the only way to create a table from scratch in Access. You can also create a table in the Datasheet view by labeling your field
Datasheet View This view places each record in a separate row and each field in a separate column (column headings are provided by the field names). This view is used to enter data directly into the table. You will use the Datasheet view whenever you want to view the records in the table or add or edit records.
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,
Another issue that
Field Naming Rules
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.