Sometimes when you use Microsoft Access database you need to get pieces of information from different tables and show them in one form. It could be a hard task to do for many of us. But with some tips and little skills you will be able to link database tables easily even with a little experience. The simplest way to do that would be through the Primary Key option in the MS Access. This option identifies and classifies the data in a table. If you represent your data in different tables but with the same Primary Key, you could relatively easy link the tables.
The first thing you have to do is to create a new query. Once you have created it and named it, you should view the inner workings of the query and open it in the Design View. It is a new query so there should be no tables listed. Then you should select the option to add table or query, in order to select the tables you want to link.
You will be able to link the tables easily if the Primary Key for the selected tables is the same. You could simply select the field set as your primary key and then drag it to the particular table’s primary key. So, in the result, the tables are linked by the identifying primary key. And your query will be able to display the information from either table.
If the selected tables have a different Primary Key, then in order to link the table you will need to do a little more work. Let’s imagine you have two tables. One of them has the automatically numbered Primary Key and it also contains another field besides Primary Key. That field has the description of different options that you can select and that are stored as strings. This kind of table is known as the static table or the list table because the information in it doesn’t change. The other table in question contains the information about accounting for customers in small businesses. And one of the fields in this table shows if the customer paid the outstanding bill.
So, in the new query, you should link the two fields together. You can use the Criteria option in the viewer in order to accomplish the linking. You can also link the data in the static and dynamic tables. With a little practice you will be able to pull the data from multiple tables and display it in a single query. After you gain some more experience you will be able to create more complex queries, which will help you make your Microsoft Access database work more effective and efficient for your personal or business use.
The world of computers and computer applications expands all the time. But you can turn this issue into your strong point by catching up with this knowledge and becoming an expert, for example in microsoft access database niche.
Please visit this site that specifies in microsoft access database topic and has a nice line of microsoft access database products available.