Shulou(Shulou.com)05/31 Report--

This article mainly introduces access how to establish the relationship between tables, the article introduces in great detail, has a certain reference value, interested friends must read it!

Methods: 1, establish the database; 2, click the "View" icon on the toolbar, select "relationship" to open the window; 3, select the added table in the "add Table of Relations" window, click "add" to add the table to the window, click "close" to return to the relationship window; 4, click the primary key in the table, and make another table the same, click "OK".

The operating environment of this tutorial: windows10 system, Microsoft Office Access2019 version, Dell G3 computer.

After opening the Access database, we create two data tables as examples.

The method of establishing the relationship between tables in access

1. After setting up the data table, click the table to see that the two tables contain different field contents. If we want to query the record contents of any field, we need to establish a relationship between the two tables and associate them. Select any table, and then click the view icon on the toolbar. Now switch to the design interface and click the relationships button on the toolbar to open the relationships window.

3. In the add Table of relationships window, select the table you want to add, and then click the add button to add the table to the relationship window. After you add it, click close to return to the relationship window.

4. Click the primary key field of one of the tables, that is, the only field with no duplicate values. Hold down the mouse and drag it to the same field in another table to release it, and then click OK in the pop-up window. Now these two forms have established a relationship with [employment certificate number]. You can later display eligible field records in any table through a query.

The above is all the contents of the article "how to establish the relationship between tables in access". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.