- Creating a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating a Table 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
Modifying Object Dependencies
As you view dependencies for an object in the Object Dependencies task pane and determine you can make changes without effecting other objects, you can open an object in Design view directly from the Object Dependencies task pane and modify it. If you need to look at other objects, you can open more than one from the Object Dependencies task pane. If you are having problems viewing dependency information, you need to turn on the Track Name AutoCorrect Info option on the Current Database pane in Access Options.
Modify Dependency Information
In the Navigation pane, click the database object in which you want to view and modify dependencies.
Click the Database Tools tab.
Click the Object Dependencies button.
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 (+) next to an object to view dependency information.
Click the object you want to open in Design view.
Modify the object in Design view, and then click the Close button in the Design view window.
When you’re done, click the Close button on the task pane.