Query: A query is an object used to view, analyze, or modify data. How can you DELETE fields from a table? In the navigation pane, right-click the table and then click Design View.

To add and remove a Primary Key from an Access database table, follow the methods below. 1] How to remove the default Primary key from Access Table Open the database that you want to alter.