Extra Practice 1. Create And Manage Databases

1.2 Manage relationships and keys

 

Instructions

Tips & Tricks

Help
1 Open the "Access_1-2" database, and save it in the practice files folder as "Access_1-2_Final". Then do the following: Acc16_PrT_1-2_Ex01
2 Open the "Status" table in Design view.
3 Set the "StatusID" field as the table's primary key. Exam Task
Set the field "StatusID" as the Primary Key in the "Status" table.		 Acc16_ExT_1-2-2_Ex01
4 Save the changes to the table. Close the table.
5 Open the Relationships window and do the following: Acc16_PrT_1-2_Ex02
6 Clear the Layout.
7 Display the "Tasks" and "Status" tables in the window. Στο π.δ. Show Table μπορείτε να κάνετε διπλό κλικ στον πίνακα που θέλετε να προσθέσετε.
8 Create a relationship between the "Status" table ("StatusID" field) and the "Tasks" table ("Status" field). Create a one-to-many relationship between the "StatusID" field of the "Status" table and the "Status" field of the "Tasks" table. The relationship should support joins that return records in the "Tasks" table even if there is not a related record in the "Status" table. Keep all other settings at default. Acc16_ExT_1-2-1_Ex01
9 The relationship should support joins that return records in the "Tasks" table even if there is not a related record in the "Status" table. Keep all other settings at default.
10 Use the Show Table command to add the "Compensation" table to the Relationships window.
11 Edit the relationship between the "Compensation" table and the "Employees" table to enforce  referential integrity. Θα πρέπει να εμφανίσετε τον πίνακα "Employees".
Exam Task:
Enforce referential integrity on the relationship between the "EmployeeID" field of the "Compensation" table and the "Employees" table. Keep all other settings at default.		 Acc16_ExT_1-2-1_Ex02
12 Close the Relationship window saving the new layout. Προσοχή - πρέπει οπωσδήποτε να αποθηκευθεί το νέο layout ώστε να βαθμολογηθούν κάποιες από τις προηγούμενες ασκήσεις.
13 Close the database.