How Do You Delete Table Relationships In Microsoft Access?
Microsoft Access tables are the foundation of your Access databases. They hold all the records required to run queries, use forms, and create reports. In order to make more powerful queries, tables are often linked in various ways to create relationships between fields in tables. Table relationships can be created and deleted easily. You may need to delete table relationships if fields change or to create a new relationship between tables. Microsoft Access makes deleting table relationships a very straightforward process. Open an existing Microsoft Access database with at least one existing relationship between tables. Go to “Tools — Relationships” at the top of the screen. Alternately, go to “Queries” in the database window if you created the relationship for a specific query. Sometimes a relationship link is created within a query instead of in the relationship design window. Single-click the query containing the relationship and choose “Design View.” This step is only if you’re vie
