In Microsoft Access, fields can be added and removed from the list of available fields. Learn how to add or delete a Field in Design View in Access.

The Query Design: Create a new blank query in Design View. You can use the Show Table dialog box to add queries and tables to the Query Design. What are the Advantages of using a Query?

Select the table that has the ID field you wish to delete. Switch to Design View by clicking on the "Fields" tab. Select "Views Group" and then "View." Select the ID field.