Scribd
Upload
37 views2 pages

Creating Relationships in MS Access

This document provides instructions for creating relationships between tables in a database, querying related tables, and building forms. It explains that to create a relationship, you need to add a foreign key to the related table and use the Relationships dialog box to link the tables by their related fields. It describes how to design a query that selects fields from related tables and how to view the SQL code. It also outlines how to design a form by adding fields from related tables and configuring command buttons for common record operations like adding, saving, deleting, and finding records.

Uploaded by

Pallab Datta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
37 views2 pages

Creating Relationships in MS Access

This document provides instructions for creating relationships between tables in a database, querying related tables, and building forms. It explains that to create a relationship, you need to add a foreign key to the related table and use the Relationships dialog box to link the tables by their related fields. It describes how to design a query that selects fields from related tables and how to view the SQL code. It also outlines how to design a form by adding fields from related tables and configuring command buttons for common record operations like adding, saving, deleting, and finding records.

Uploaded by

Pallab Datta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

How to create relationship between multiple tables?

1st ensure that you have a foreign key in your related table. Now
go to Database Tools tab > relationship > dialog box appeared
with all table name > select each table and click add button >
close > edit relationship > a dialog box appeared > create new >
another box appeared > select Left Table Name, Right Table
Name, Left column Name(related id field), Right Column
Name(related id field) > OK > Create.

How to create Query on related table?

After creating relationship go to Create tab > Query Design > now
select each field > Run.

To view the SQL code : view > SQL view

How to create form?

1st enter the table field then go to create tab


> form design > form design tools Add Existing
Fields > select show all table from right side
pane > then double click on the fields name .

Now add the buttons as per required. Select


button icon on design tab Control group >
drag it on the form design body > Command
Button Wizard appeared > then follow the
steps for different type of button.

New Record  wizard > record operation >


Add New record > next> select text option >
next > Finish.

Save Record  wizard > record operation >


Save record > next> select text option > next >
Finish.

Delete Record  wizard > record operation >


Delete record > next> select text option > next
> Finish.

Find Record  wizard > record navigation >


Find record > next> select text option > next >
Finish.

You might also like