To Create a New Table in MS Access
Microsoft Office Access 2007 has made creating tables easy by providing a handful of common schemas.
1. On the Ribbon, on the Create tab, in the Tables section, click Table.
2. Type the first value in the cell, just as you would in a Microsoft Office Excel spreadsheet, and then press ENTER.
3. Double-click the column heading to rename the field.
Based on the value typed, Access automatically defines the data type, although it does so differently from a spreadsheet. In Access, each field—a column in your datasheet—is defined by a data type.