building the example database in ms access
DESCRIPTION
Building the Example Database in MS Access. Table: SalesOrders SalesOrderNo Date CustomerNo ClerkNo Total Table: OrderItems SalesOrderNo ItemNo ItemQuantity ItemUnitPrice. Table: InventoryItems ItemNo ItemDescription Table: Customers CustomerNo CustomerName CustomerAddress - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/1.jpg)
INFM 603 – Information Technology and Organizational Context
Lecture 9
Building the Example Databasein MS Access
![Page 2: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/2.jpg)
2
Example (Final Tables)• Table: SalesOrders
– SalesOrderNo– Date– CustomerNo– ClerkNo– Total
• Table: OrderItems– SalesOrderNo– ItemNo– ItemQuantity– ItemUnitPrice
• Table: InventoryItems– ItemNo– ItemDescription
• Table: Customers– CustomerNo– CustomerName– CustomerAddress
• Table: Clerks– ClerkNo– ClerkName
![Page 3: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/3.jpg)
3
Example (ER Diagram)
SALES ORDERS
INV. ITEMSORDER ITEMS
CLERKSCUSTOMERS
![Page 4: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/4.jpg)
4
![Page 5: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/5.jpg)
5
![Page 6: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/6.jpg)
6
![Page 7: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/7.jpg)
7
![Page 8: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/8.jpg)
8
![Page 9: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/9.jpg)
9
![Page 10: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/10.jpg)
10
![Page 11: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/11.jpg)
11
![Page 12: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/12.jpg)
12
![Page 13: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/13.jpg)
13
![Page 14: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/14.jpg)
14
![Page 15: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/15.jpg)
15
![Page 16: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/16.jpg)
16
![Page 17: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/17.jpg)
17
![Page 18: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/18.jpg)
18
![Page 19: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/19.jpg)
19
![Page 20: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/20.jpg)
20
![Page 21: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/21.jpg)
21
![Page 22: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/22.jpg)
22
![Page 23: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/23.jpg)
23
![Page 24: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/24.jpg)
24
![Page 25: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/25.jpg)
25
![Page 26: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/26.jpg)
26
![Page 27: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/27.jpg)
27
![Page 28: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/28.jpg)
28
![Page 29: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/29.jpg)
29
![Page 30: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/30.jpg)
30
![Page 31: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/31.jpg)
31
![Page 32: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/32.jpg)
32
![Page 33: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/33.jpg)
33
![Page 34: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/34.jpg)
34
![Page 35: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/35.jpg)
35
![Page 36: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/36.jpg)
36
![Page 37: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/37.jpg)
37
![Page 38: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/38.jpg)
38
![Page 39: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/39.jpg)
39
![Page 40: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/40.jpg)
40
![Page 41: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/41.jpg)
41
![Page 42: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/42.jpg)
42
![Page 43: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/43.jpg)
43
![Page 44: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/44.jpg)
44
![Page 45: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/45.jpg)
45
![Page 46: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/46.jpg)
46
![Page 47: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/47.jpg)
47
![Page 48: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/48.jpg)
48
![Page 49: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/49.jpg)
49
![Page 50: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/50.jpg)
50
![Page 51: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/51.jpg)
51
![Page 52: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/52.jpg)
52
![Page 53: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/53.jpg)
53
![Page 54: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/54.jpg)
54
![Page 55: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/55.jpg)
55
![Page 56: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/56.jpg)
56
![Page 57: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/57.jpg)
57
![Page 58: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/58.jpg)
58
![Page 59: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/59.jpg)
59
![Page 60: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/60.jpg)
60
![Page 61: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/61.jpg)
61
![Page 62: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/62.jpg)
62
![Page 63: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/63.jpg)
63
![Page 64: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/64.jpg)
64
![Page 65: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/65.jpg)
65
![Page 66: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/66.jpg)
66
![Page 67: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/67.jpg)
67
![Page 68: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/68.jpg)
68
![Page 69: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/69.jpg)
69
![Page 70: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/70.jpg)
70
![Page 71: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/71.jpg)
71
![Page 72: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/72.jpg)
72
![Page 73: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/73.jpg)
73
![Page 74: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/74.jpg)
74
![Page 75: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/75.jpg)
75
![Page 76: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/76.jpg)
76
![Page 77: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/77.jpg)
77
![Page 78: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/78.jpg)
78
![Page 79: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/79.jpg)
79
![Page 80: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/80.jpg)
80
![Page 81: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/81.jpg)
81
![Page 82: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/82.jpg)
82
![Page 83: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/83.jpg)
83
![Page 84: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/84.jpg)
84
![Page 85: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/85.jpg)
85
![Page 86: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/86.jpg)
86
![Page 87: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/87.jpg)
87
![Page 88: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/88.jpg)
88
![Page 89: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/89.jpg)
89
![Page 90: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/90.jpg)
90
![Page 91: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/91.jpg)
91
![Page 92: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/92.jpg)
92
![Page 93: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/93.jpg)
93
![Page 94: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/94.jpg)
94
![Page 95: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/95.jpg)
95
![Page 96: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/96.jpg)
96
![Page 97: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/97.jpg)
97
![Page 98: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/98.jpg)
98
![Page 99: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/99.jpg)
99
![Page 100: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/100.jpg)
100
![Page 101: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/101.jpg)
101
![Page 102: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/102.jpg)
102
![Page 103: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/103.jpg)
103
![Page 104: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/104.jpg)
104
![Page 105: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/105.jpg)
105
![Page 106: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/106.jpg)
106
![Page 107: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/107.jpg)
107
![Page 108: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/108.jpg)
108
![Page 109: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/109.jpg)
109
![Page 110: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/110.jpg)
110
![Page 111: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/111.jpg)
111
![Page 112: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/112.jpg)
112
![Page 113: Building the Example Database in MS Access](https://reader036.vdocuments.us/reader036/viewer/2022081520/56815616550346895dc3d564/html5/thumbnails/113.jpg)
113