Anonymous
Anonymous Asked in Cars &Transportation ยท 2 weeks ago

How do you create a relationship between two tables in Access?

Contents
  1. How do you do Relationships in Access?
  2. How do you create a relationship between two tables in Access 2007?
Create a table relationship by using the Relationships window On the Database Tools tab, in the Relationships group, click Relationships. On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013). Select one or more tables or queries and then click Add.


How do you do Relationships in Access?

You do that by following these steps:1Click the Database Tools tab on the Ribbon. ... 2From the Relationships group, click the Relationships button. ... 3For each pair of tables you want in the relationship, click the table and then click Add. ... 4After you finish adding tables, click the Close button.

How do you create a relationship between two tables in Access 2007?

Relating tables1Select a field name from one table by holding down the left mouse button. ... 2Drag the field name from one table to the other table in the desired relationship.3Drop the first field name onto the field name you want to relate by releasing the left mouse button. ... 4The Edit Relationships dialog box appears.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours