G. Write the steps to create a relationship either one to one or one to
many, using the tables given below:
Name of the Tables 1 is - TRAIN DETAILS
Name of the Table 2 is - PASSENGER DETAILS
Insert at least 4 field names in each table with two to three records within
the database.
Save the Access file by your name on desktop.
Answers
Answer:
Make sure the workbook contains at least two tables, and that each table has a column that can be mapped to a column in another table.
Do one of the following: Format the data as a table, or Import external data as a table in a new worksheet.
Give each table a meaningful name: In Table Tools, click Design > Table Name > enter a name.
Verify the column in one of the tables has unique data values with no duplicates. Excel can only create the relationship if one column contains unique values.
For example, to relate customer sales with time intelligence, both tables must include dates in the same format (for example, 1/1/2012), and at least one table (time intelligence) lists each date just once within the column.
Click Data > Relationships.
If Relationships is grayed out, your workbook contains only one table.
In the Manage Relationships box, click New.
In the Create Relationship box, click the arrow for Table, and select a table from the list. In a one-to-many relationship, this table should be on the many side. Using our customer and time intelligence example, you would choose the customer sales table first, because many sales are likely to occur on any given day.
For Column (Foreign), select the column that contains the data that is related to Related Column (Primary). For example, if you had a date column in both tables, you would choose that column now.
For Related Table, select a table that has at least one column of data that is related to the table you just selected for Table.
For Related Column (Primary), select a column that has unique values that match the values in the column you selected for Column.
Click OK.
More about relationships between tables in Excel
Notes about relationships
Example: Relating time intelligence data to airline flight data
“Relationships between tables may be needed”
Step 1: Determine which tables to specify in the relationship
Step 2: Find columns that can be used to create a path from one table to the next
Notes about relationships
You’ll know whether a relationship exists when you drag fields from different tables onto the PivotTable Fields list. If you aren’t prompted to create a relationship, Excel already has the relationship information it needs to relate the data.
Creating relationships is similar to using VLOOKUPs: you need columns containing matching data so that Excel can cross-reference rows in one table with those of another table. In the time intelligence example, the Customer table would need to have date values that also exist in a time intelligence table.
Mark me as brainlist