Define relation in Microsoft Access

Tags:
Microsoft Access
In Microsoft Access, what is meant by define relation?


Software/Hardware used:
whay my computer was working soo slow
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Jaideep Khanduja
    It is as simple as the relation concept in any database. Suppose you have a table EMPLOYEE MASTER and another table as EMPLOYEE ASSETS. Now Employee Master will have all the basic details of an employee. And you generate a key Employee Code. In the other table Employee Assets you need not repeat this basic details of an employee. Just create records with the existing Employee Code which establishes a relation between the two tables.
    19,435 pointsBadges:
    report
  • ToddN2000
    A relation is a way of connecting tables/files in a database. You need a common element to link the corresponding data. This can be anything as long as it is found in both tables. It can be an ID#, customer name, product, date...
    134,780 pointsBadges:
    report
  • Subhendu Sen
    Assuming you are in a learning process, you can read your books and gather knowledge for the same. However, for your concepts, a relationship that access creates depends on how the related fields are defined. If one to many relationship is created if only one of the related fields is a primary key Or if one to one relationship is created then both of the related fields are primary keys. Almost same concept is applied for many to many relationship. One more thing is that, when create a relationship between two tables, access provides uses the referential integrity feature.
    140,750 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: