MICROSOFT ACCESS PROJECT

L12_Project1Datafile.accdb

Home >Information Systems homework help >MICROSOFT ACCESS PROJECT

ID	Employee Assigned To	Item Name	Per Unit Cost	Quantity	Total Item Cost
1
2	Smith	Camcorder	¤ 1,475.00	2.0	2950.0
3	Jones	Tablets	¤ 70.00	3.0	210.0
4	Jones	Compact Tripods	¤ 60.00	3.0	180.0
5	Smith	DSLR Camera	¤ 950.00	1.0	950.0
6	Smith	Lavalier Digital Wireless microphone	¤ 850.00	1.0	850.0
7	Smith	DSLR Camera	¤ 700.00	2.0	1400.0
8	O'Connor	Quadcopter Drone	¤ 1,650.00	1.0	1650.0
9	Perry	Maniken Cart	¤ 1,300.00	1.0	1300.0
10	Bernard	Wheeled Bucket Case	¤ 600.00	3.0	1800.0
11	Bernard	Mini Coverter	¤ 300.00	1.0	300.0
12	Bernard	On-Camera Shotgun Microphone	¤ 360.00	1.0	360.0
13	O'Connor	Shotgun Mic with Boom Pole	¤ 650.00	1.0	650.0
14	O'Connor	Rode VideoMic Pro	¤ 230.00	2.0	460.0
15	O'Connor	Cavision Next Generation Clock Slate Plus	¤ 300.00	1.0	300.0
16	O'Connor	Manfrotto Alu Master Air Cushioned Light Stand	¤ 283.69	2.0	567.38
17	O'Connor	Mixer	¤ 250.00	1.0	250.0
18	O'Connor	Diffusion filter kit	¤ 85.00	2.0	170.0
19	O'Connor	DJI Osmo	¤ 920.00	1.0	920.0
20	Jones	Condenser Microphone for Smartphones	¤ 90.00	10.0	900.0
21	Jones	USB Microphone	¤ 195.00	3.0	585.0
22	Jones	Video Tripod with Fluid Head	¤ 120.00	4.0	480.0
23	Jones	Micro-Lavalier Omnidirectional Microphone	¤ 155.00	3.0	465.0
24	Jones	Wired Intercom System with Four HP-2A Headsets Kit	¤ 1,500.00	1.0	1500.0
25	Smith	Canon EOS Rebel SL2 - digital camera	¤ 750.00	2.0	1500.0
26	Perry	Wacom Intuos Creative Pen Small Digitizer	¤ 70.00	2.0	140.0

SELECT DISTINCTROW * FROM [Lifetime Media Equipment];

SELECT [Lifetime Media Equipment].[Employee Assigned To], [Lifetime Media Equipment].[Item Name], [Lifetime Media Equipment].[Per Unit Cost], [Lifetime Media Equipment].Quantity FROM [Lifetime Media Equipment] WHERE ((([Lifetime Media Equipment].[Employee Assigned To])="Smith"));