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?
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
