ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ACCESS RELATIONAL DATABASE PRACTICAL
2
PurposeUse these two linked tables to practise importing data into Microsoft Access.
3
Table 1Suppliers: one record per supplier. SupplierID is the primary key.
4
Table 2Products: one record per product. ProductID is the primary key.
5
RelationshipSuppliers.SupplierID (one) → Products.SupplierID (many).
6
ImportantSupplierID in Products is a foreign key. Each value must match a SupplierID in Suppliers.
7
Suggested database name
Product.accdb
8
Import tipImport each worksheet as a separate table. Check that IDs are Number / Long Integer and prices are Currency.
9
Class taskCreate the relationship, queries, data-entry forms, and reports using the student practical guide.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100