Open or create the Access database you want to edit. Click the tab of the table you wish to open in design view. Click the "View" menu icon and click "Design View." ...

Creating Tables in Design View You have created a new database in the first part of this tutorial, and you've chosen to create a table in Design View. Below is a portion of what you should have on ...

When you open the new table in Design view, it will have the exact same table structure as the original. Now you can now make any changes to the table structure to customize it to fit your needs.

Figure B Select Tables, click the table to be added to the query, and then click Add. You can add as many tables as you need to the query; just select the next table in the same window and click Add.

The Design View allows you to design and set up the database. The Design View is where you configure your table, forms, reports, etc. Can we delete a field in Access Design View?