The Table wizard is an interactive coach that lets you choose from several predefined tables. The Table wizard asks you questions about the fields you want to include in your table, then creates the table for you. Once the table is created you can alter the table to add or remove a field as required. Every field has a field name to identify the data in the field. A field name must not contain spaces and can be up to 64 characters including letters, digits, and spaces.
Every field also has a data type .
Access recognizes nine data types. An alphanumeric value. AutoNumber field a special data type that causes access to assign the next consecutive number each time you add a record. Each number is unique and is often used as a primary key. The primary key is a field that uniquely identifies a record.