Answer in one word.
To set a relationship between two tables
them
to create a query
To nn a query
to select the primary key for a table
0 Are the following questions
What is a foreign key?
Answers
Answer:
1) Create a table relationship by using the Relationships window
On the Database Tools tab, in the Relationships group, click Relationships.
On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013).
Select one or more tables or queries and then click Add
2)To create a simple one-table query:
Select the Create tab on the Ribbon, and locate the Queries group.
Click the Query Design command.
Access will switch to Query Design view. ...
Click Add, then click Close.
The selected table will appear as a small window in the Object Relationship pane.
3)Primary Keys
The primary key consists of one or more columns whose data contained within are used to uniquely identify each row in the table. You can think of them as an address. If the rows in a table were mailboxes, then the primary key would be the listing of street addresses.
4)A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. ... The FOREIGN KEY constraint is used to prevent actions that would destroy links between tables.
Explanation: