« How do you run a delete query from a command button in a form (MS Access)?
I have an Access database with geographic data. can i autobuild a KML with it to plot the data on google earth? »

How do I determine if I should link new tables in Microsoft Access?

Hi everyone. I’m new using Microsoft Access and I was hoping for some help. I’m doing an assignment that basically includes the tables for product, and suppliers for a motorbike company.

I’m supposed to suggest some new tables so I decided on suggesting one for employees with all their information, and one for customers. How do I know if these new tables should be linked with existing tables(suppliers, products) and how do I do it?

any help would be GREATLY appreciated. Thanks.

First, linking tables should be done utilizing the query part of Access. You can do this by selecting your tables in query/design mode. You link link them by using a common field. For example, if John, your salesman sold 2 monitors to Smith and Associates, your customer, you can link them by having John’s salesman Number with Smith and Associates customer number as part of the order. Then when you query it with the relationship, it will pull the order and give you all of Johns information with all the information from Smith and Assoc. You can then also track all the orders each of them made. Your relationship should be nuneric, kind of like a serial number for all. This can easily be done by designating your primary key on each of the tables as an autonumber in each table. I hope this helps.

This entry was posted on Sunday, February 21st, 2010 at 11:35 am and is filed under microsoft access. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How do I determine if I should link new tables in Microsoft Access?”

  1. Richard T Says:
    February 21st, 2010 at 5:05 pm

    First, linking tables should be done utilizing the query part of Access. You can do this by selecting your tables in query/design mode. You link link them by using a common field. For example, if John, your salesman sold 2 monitors to Smith and Associates, your customer, you can link them by having John’s salesman Number with Smith and Associates customer number as part of the order. Then when you query it with the relationship, it will pull the order and give you all of Johns information with all the information from Smith and Assoc. You can then also track all the orders each of them made. Your relationship should be nuneric, kind of like a serial number for all. This can easily be done by designating your primary key on each of the tables as an autonumber in each table. I hope this helps.
    References :
    Many years of MS Access and database experience dating back to DBase IV. I have built databases for many companies.

Leave a Reply