Microsoft Access 2019 Capstone Level 2 Project

profileLazarus
-AC2019-Capstone-Level2.accdb
Home>Computer Science homework help>Microsoft Access 2019 Capstone Level 2 Project
ItemID ItemName Price
CARA002 Sea Salt and Caramel 8
CHOC008 Chocolate 9
OLDB005 Old Bay 9
ORIG001 Original Blend 7
TRUF003 Truffle 10
LocationID LocationDescription Comments OpenTime CloseTime Days
FARR Farragut Square 12/30/99 12/30/99 M-F
Gtown Georgetown 12/30/99 12/30/99 Th-Sa
GW George Washington University 12/30/99 12/30/99 Th-Sa
KSt K Street 12/30/99 12/30/99 M-F
Tysons Tysons Corner Store Our store location at Tysons Corner near the mall 12/30/99 12/30/99 M-Su
ID SaleDate Quantity ItemID Total TotalSal
1.0 6/30/19 6.0 OLDB 33.0
2.0 6/30/19 4.0 OLDB 22.0
3.0 6/30/19 4.0 OLDB 22.0
4.0 6/30/19 2.0 OLDB 11.0
5.0 7/1/19 2.0 OLDB 11.0
6.0 7/1/19 5.0 OLDB 27.5
7.0 7/1/19 2.0 OLDB 11.0
8.0 7/1/19 4.0 OLDB 22.0
9.0 7/1/19 8.0 OLDB 44.0
10.0 7/2/19 2.0 OLDB 11.0
11.0 7/2/19 4.0 OLDB 22.0
12.0 7/2/19 2.0 OLDB 11.0
13.0 7/2/19 4.0 OLDB 22.0
14.0 7/2/19 2.0 OLDB 11.0
15.0 7/3/19 2.0 OLDB 11.0
16.0 7/3/19 4.0 OLDB 22.0
17.0 7/3/19 6.0 OLDB 33.0
18.0 7/4/19 2.0 OLDB 11.0
19.0 7/4/19 4.0 OLDB 22.0
20.0 7/5/19 2.0 OLDB 11.0
21.0 7/5/19 2.0 OLDB 11.0
22.0 7/5/19 6.0 OLDB 33.0
23.0 7/5/19 2.0 OLDB 11.0
24.0 7/5/19 4.0 OLDB 22.0
25.0 7/5/19 2.0 OLDB 11.0
26.0 7/5/19 4.0 OLDB 22.0
27.0 7/5/19 2.0 OLDB 11.0
28.0 7/6/19 2.0 OLDB 11.0
29.0 7/6/19 8.0 OLDB 44.0
30.0 7/6/19 10.0 OLDB 55.0
31.0 7/6/19 2.0 OLDB 11.0
32.0 7/6/19 4.0 OLDB 22.0
33.0 6/30/19 12.0 ORIG001 60.0
34.0 6/30/19 4.0 ORIG001 20.0
35.0 6/30/19 2.0 ORIG001 10.0
36.0 6/30/19 10.0 ORIG001 50.0
37.0 6/30/19 2.0 ORIG001 10.0
38.0 7/1/19 10.0 ORIG001 50.0
39.0 7/1/19 2.0 ORIG001 10.0
40.0 7/1/19 4.0 ORIG001 20.0
41.0 7/1/19 10.0 ORIG001 50.0
42.0 7/1/19 6.0 ORIG001 30.0
43.0 7/2/19 2.0 ORIG001 10.0
44.0 7/2/19 4.0 ORIG001 20.0
45.0 7/2/19 14.0 ORIG001 70.0
46.0 7/2/19 12.0 ORIG001 60.0
47.0 7/2/19 10.0 ORIG001 50.0
48.0 7/2/19 4.0 ORIG001 20.0
49.0 7/2/19 4.0 ORIG001 20.0
50.0 7/3/19 4.0 ORIG001 20.0
51.0 7/3/19 4.0 ORIG001 20.0
52.0 7/4/19 6.0 ORIG001 30.0
53.0 7/4/19 8.0 ORIG001 40.0
54.0 7/4/19 4.0 ORIG001 20.0
55.0 7/5/19 6.0 ORIG001 30.0
56.0 7/5/19 2.0 ORIG001 10.0
57.0 7/5/19 2.0 ORIG001 10.0
58.0 7/5/19 6.0 ORIG001 30.0
59.0 7/5/19 2.0 ORIG001 10.0
60.0 7/5/19 4.0 ORIG001 20.0
61.0 7/5/19 6.0 ORIG001 30.0
62.0 7/5/19 4.0 ORIG001 20.0
63.0 7/6/19 4.0 ORIG001 20.0
64.0 7/6/19 2.0 ORIG001 10.0
65.0 7/6/19 2.0 ORIG001 10.0
66.0 7/6/19 12.0 ORIG001 60.0
67.0 6/30/19 8.0 CARA002 48.0
68.0 6/30/19 5.0 CARA002 30.0
69.0 6/30/19 8.0 CARA002 48.0
70.0 6/30/19 4.0 CARA002 24.0
71.0 7/1/19 2.0 CARA002 12.0
72.0 7/1/19 2.0 CARA002 12.0
73.0 7/1/19 6.0 CARA002 36.0
74.0 7/1/19 4.0 CARA002 24.0
75.0 7/1/19 2.0 CARA002 12.0
76.0 7/2/19 6.0 CARA002 36.0
77.0 7/2/19 10.0 CARA002 60.0
78.0 7/2/19 2.0 CARA002 12.0
79.0 7/2/19 2.0 CARA002 12.0
80.0 7/3/19 2.0 CARA002 12.0
81.0 7/3/19 6.0 CARA002 36.0
82.0 7/4/19 2.0 CARA002 12.0
83.0 7/4/19 12.0 CARA002 72.0
84.0 7/4/19 2.0 CARA002 12.0
85.0 7/5/19 4.0 CARA002 24.0
86.0 7/5/19 2.0 CARA002 12.0
87.0 7/5/19 6.0 CARA002 36.0
88.0 7/5/19 2.0 CARA002 12.0
89.0 7/6/19 6.0 CARA002 36.0
90.0 7/6/19 4.0 CARA002 24.0
91.0 7/6/19 2.0 CARA002 12.0
92.0 7/6/19 4.0 CARA002 24.0
93.0 7/6/19 2.0 CARA002 12.0
94.0 7/6/19 10.0 CARA002 60.0
95.0 6/30/19 8.0 TRUF003 52.0
96.0 6/30/19 2.0 TRUF003 13.0
97.0 6/30/19 14.0 TRUF003 91.0
98.0 7/1/19 5.0 TRUF003 32.5
99.0 7/1/19 6.0 TRUF003 39.0
100.0 7/1/19 12.0 TRUF003 78.0
101.0 7/2/19 2.0 TRUF003 13.0
102.0 7/2/19 2.0 TRUF003 13.0
103.0 7/2/19 2.0 TRUF003 13.0
104.0 7/3/19 2.0 TRUF003 13.0
105.0 7/3/19 2.0 TRUF003 13.0
106.0 7/4/19 8.0 TRUF003 52.0
107.0 7/5/19 4.0 TRUF003 26.0
108.0 7/5/19 4.0 TRUF003 26.0
109.0 7/5/19 8.0 TRUF003 52.0
110.0 7/5/19 6.0 TRUF003 39.0
111.0 7/6/19 2.0 TRUF003 13.0
112.0 7/6/19 2.0 TRUF003 13.0
113.0 7/6/19 2.0 TRUF003 13.0
114.0 7/6/19 4.0 TRUF003 26.0
115.0 7/6/19 10.0 TRUF003 65.0
116.0 7/6/19 4.0 TRUF003 26.0
117.0 7/6/19 6.0 TRUF003 39.0
500.0 12/26/04 100.0 Popcorn 1000.0