How To Add Fields To Tables in MS Access

ADDING FIELDS TO TABLES

After creating a database, if you want to add some more fields in the database table, you can adding fields by the following steps:

1. Click on HOME tab.



2. Click on View group.

3. Select Design View by clicking on it

4. Now, add the new field in the last. If you want to add the new field between previous fields then place the mouse pointer there and right click. Then, click on Insert Rows option.



5. Close the table from design view and open the table again in datasheet view.

Now, new fields which you have added will be shown on the screen.