Access

  • Thread starter Thread starter Paul D
  • Start date Start date
P

Paul D

How do you create a link between two tables, both in Access? I am a student
who is working on a class project with Access. I have never used this program
before and I'm really lost. Can someone help me please?
 
How do you create a link between two tables, both in Access? I am a student
who is working on a class project with Access. I have never used this program
before and I'm really lost. Can someone help me please?
Click to expand...

Depends on what you mean by "create a link". Define a Relationship using the
Relationships window (there's an icon in the toolbar that looks like three
little datasheets joined by lines); add the two tables and drag the linking
field from the "parent" table to the corresponding field in the "child" table.
To create a Query joining two tables, just add the two tables to the query
design window and again drag the linking field.

Here are some tutorials and other resouces you might find useful:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top