Chat with AI
New Perspectives on Microsoft Access 2013 1st Edition by Joseph Adamski,Kathy Finnegan,Sharon Scollard
Edition 1ISBN: 978-1285099200New Perspectives on Microsoft Access 2013 1st Edition by Joseph Adamski,Kathy Finnegan,Sharon Scollard
Edition 1ISBN: 978-1285099200 Exercise 2
You connect the records in two separate tables through a(n)
that appears in both tables.
that appears in both tables.
Explanation
Verified
Verified
You connect the records in two separate tables through a (n) Common field that appears in both tables.
• Common field means two tables having the same field name with the same set of data.
• Through relationship between common fields of two tables, records in one table can be linked to records in another table.
• A table can have one primary key and one or more foreign keys, where these keys have an important role in table relationship.
• Common field in one table acts as a primary key and the same field acts as a foreign key in another table.
Example
Consider two tables Customer and Order.
Customer table have attributes such as CustomerID, CustomerName, CustomerAddress, and PhoneNumber.
Order table have attributes such as OrderID, CustomerID, and Amount.
Customer
Order
Here common field between two tables is CustomerID. Primary key of Customer table is CustomerID. Primary key of Order table is OrderID. Foreign key of Order table is CustomerID.
You can create relationship between these two tables. One - to- one relationship exists between common fields of two tables. So records of two tables can be connected easily. Once when you type the CustomerID, you can get their OrderID, Amount, Name, Address, PhoneNumber.
• Common field means two tables having the same field name with the same set of data.
• Through relationship between common fields of two tables, records in one table can be linked to records in another table.
• A table can have one primary key and one or more foreign keys, where these keys have an important role in table relationship.
• Common field in one table acts as a primary key and the same field acts as a foreign key in another table.
Example
Consider two tables Customer and Order.
Customer table have attributes such as CustomerID, CustomerName, CustomerAddress, and PhoneNumber.
Order table have attributes such as OrderID, CustomerID, and Amount.
Customer
Order Here common field between two tables is CustomerID. Primary key of Customer table is CustomerID. Primary key of Order table is OrderID. Foreign key of Order table is CustomerID. You can create relationship between these two tables. One - to- one relationship exists between common fields of two tables. So records of two tables can be connected easily. Once when you type the CustomerID, you can get their OrderID, Amount, Name, Address, PhoneNumber.
New Perspectives on Microsoft Access 2013 1st Edition by Joseph Adamski,Kathy Finnegan,Sharon Scollard
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
