MS Access 2007 - Lesson 8: Establish relationships between tables
TipsMake.com - The relationship between tables is the data link between tables. By defining table relationships , you can drag records from related tables based on relational fields.
One-to-one relationship
One-to-one relations are relations between two tables that are set when the relational field is both the primary key on both tables. Each record in Table A can only have one matching record in Table B.
One-to-one relationship
One-to-many relationship
One-to-many relationship is the relationship between two tables that the primary key in a table can be copied multiple times in another table or it can be understood that a record in table A can only have multiple records matching in table B , but a record in Table B has only one matching record in Table A.
One-to-many relationship
Create a table relationship
To create relationships between tables:
- Click on the Database Tools tab on the Ribbon
- Select Relationships button
- Click on the Design tab
- Select Show Table
Select the tables you want to create relationships with
- Click the Add button to add tables
- Click the Close button to turn off the Show Table window.
- Choose the school you want to create a relationship from
- Drag a merge field with the relational field in another table
- Click OK.
Print table relationships
- Click the Database Tools tab.
- Click on Relationships button.
- Click the Relationship Report button on the Design tab.
- Click the Print button.
You should read it
- Relationships between tables in Access
- 1-1 relationship between tables in ACCESS
- MS Access - Lesson 6: Managing tables
- MS Access 2003 - Lesson 6: Creating a table in Access
- MS Word - Lesson 8: Creating a table
- Steps to export Microsoft Access data to Word documents
- MS Access 2003 - Lesson 39: Analyzing tables
- MS Access 2003 - Lesson 15: Create an initial table
May be interested
- Discover Microsoft Web Officemicrosoft web apps allow you to view, edit and share ms office documents through the web environment
- MS Word - Lesson 8: Creating a tabletable is used to display data in a tabular format. how to create a table in word, how to format word 2007 tables? please follow the instructions below.
- IBM Lotus Symphony - free replacement for MS Officeduring the current economic recession, spending a lot of money to buy a package of office applications like ms office makes you a headache.
- MS Access - Lesson 9: Data managementallow data to be displayed flexibly and according to your requirements. in this article, we introduce some basic ways to manage data for databases.
- MS Word - Lesson 9: Insert pictures, mathematical characters, especially on documentsword 2007 allows you to insert special characters, symbols, images, illustrations and watermarks.
- Some new features of Access 2010access 2010 allows conditional formatting in reports, displaying information that meets a certain condition or group of conditions.