- Introduction
- Creating a Custom Database Template
- Using a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating an Application Part Using a Template
- Importing Data into Tables
- Linking to Data in Tables
- Working with Table Records
- Working with a Table in Design View
- Specifying a Primary Key in Design View
- Planning Table Relationships
- Defining Table Relationships
- Creating and Printing a Table Relationship Report
- Ensuring Referential Integrity
- Identifying Object Dependencies
- Modifying Object Dependencies
This chapter is from the book
This chapter is from the book
This chapter is from the book
Identifying Object Dependencies
As you develop a database, you create a relationship between objects to share data and provide the information in forms and reports. When you make changes to one object, it might affect another object. For example, if you no longer need a field in a table, instead of deleting it right away and possibly creating problems, you can check object dependencies to make sure that the field you want to delete is not used in another table. Checking for object dependencies helps you save time and avoid mistakes. Access generates dependency information by searching name maps maintained by the Name AutoCorrect feature. If Track Name AutoCorrect Info is turned off on the Current Database pane in the Options dialog box, you cannot view dependency information.
View Dependency Information
In the Navigation pane, click the database object in which you want to view dependencies.
Click the Database Tools tab.
Click the Object Dependencies button.
If prompted, click OK to update dependency information. If prompted, click Yes to close all objects.
Click the Objects that depend on me or Objects that I depend on option.- The Object Dependencies task pane shows the list of objects that use the selected object.
Click the Expand icon (white arrow) next to an object to view dependency information. Click the Collapse icon (black arrow) to hide the dependency information.
When you’re done, click the Close button on the task pane.
)
Dependency Information
|
Object |
Dependent |
Description |
|
Table |
Table or query |
A relationship is defined between the objects |
|
Table |
Form |
Fields in the selected table look up values |
|
Query |
Table or query |
Query is bound to the table or query |
|
Form |
Table or query |
Form is bound to the table or query |
|
Form |
Form |
Form includes the other form as a subform |
|
Report |
Table or query |
Report is bound to the table or query |
|
Report |
Form |
Report includes the form as a subform |
|
Report |
Report |
Report include the other report as a subreport |