Objective 1.1 Create and modify databases
- 1.1.1 Create databases
- 1.1.2 Import database objects and data
- 1.1.3 Delete database objects
OBJECTIVE 1.1: Contents
1.1.3 Delete database objects
Delete database objects
Access databases depend on the relationship between tables to preserve the integrity of data and to eliminate redundant data. You can delete most types of database objects, including queries, forms, and reports, without affecting underlying relationships. However, Access prevents you from deleting a table that is related to another table without first deleting the relationship. Access deletes the relationship for you if you agree.
A warning about deleting a table
See Also: For more information about table relationships, see “Objective 1.2: Manage relationships and keys.” For information about renaming database objects, see “Back up and restore databases” in “Objective 1.4: Protect and maintain databases.”
To delete a database object
1. Close the object that you want to delete.
2. In the Navigation Pane, right-click the object, and then click Delete.
3. In the Microsoft Access message box asking you to confirm that you want to delete the object and remove it from all groups, click Yes.
4. If you are deleting a table and Access prompts you to confirm that you want Access to delete the relationship, click Yes to remove the relationship and delete the table.