It’s easy to create tables in Access, but you’re not stuck with the first version of a table. After you create a table, you can modify it by adding, deleting, and reordering fields. Although the order of your fields doesn’t affect how your table functions within the database, changing their order can make it easier for you and your colleagues to understand your table’s structure
To delete a field, click the row selector of the row you want to delete, click the Delete Rows button, and then click Yes to confirm that you want to delete the row.
To add a field, click the row selector of the row below where you want the new field to appear, click the Insert Row button, type a name for the field, click the row’s Data Type cell, click the down arrow that appears, and then click the desired data type.
To reorder the fields in your table, click the row selector of the row you want to move, and then drag the row selector to the desired position.