Posted: March 12th, 2023

Exp19_Access_Ch05_Cap_Varmel_Studio_Toys

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

Poughkeepsie, NY 12601
u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

Fort Lauderdale, FL 33308
u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==

Customer	ID	CustomerName	Address																																									1	Address										2				mSysRowId
		C0001	Conley, Cathrine	137 Jockey Hollow St.	Suitland, MD 20746																																																		u/xf14MqW9/Dwy9pZic1IEWoK4+7ltGLc9I/L4/JqZ8=-~qTaQst0L9oyjMwDvYD8mEw==
	C0002	Blakely, Ladawn	346 La Sierra St.	Greer, SC 29650
C0003	Bynum, Joya	42 S. Pierce Street	Appleton, WI 54911
	C0004	Neel, Hana	8840 Rock Creek Dr.	Pearl, MS 39208
	C0005	Sanford, Nilda	8115 Amherst Lane	Hillsborough, NJ 08844
C0006	Chesser, Isidro	8414 Strawberry St.	Vernon Hills, IL 60061
C0007	Fish, Aja	414 Dunbar Ave.	New Rochelle, NY 10801
				C0008	Holcombe, Shemeka	8737 East Elmwood Ave.	Garden City, NY 11530
	C0009	Willard, Denny	9296 E. Walnut Lane	Saginaw, MI 48601
	C0010	Gallo, Vaughn	86 S. Lyme Court	Lemont, IL 60439
C0011	Collado, Hyon	9724 Bowman St.	Sioux City, IA 51106
		C0012	Cheatham, Joaquin	988 King Dr.	Miamisburg, OH 45342
	C0013	Horan, Velia	544 Valley St.	Norman, OK 73072
	C0014	Meza, Leon	846 Marvon Dr.		Poughkeepsie, NY 12601
C0015	Whaley, Josefine	53 West Pulaski Ave.	Chillicothe, OH 45601
C0016	Kilgore, Nancie	24 Wild Horse Dr.	Tucson, AZ 85718
	C0017	Staten, Erasmo	9691 Park St.	Lexington, NC 27292
		C0018	Dorsey, Prince	5 Nicolls St.	Langhorne, PA 19047
	C0019	Kenney, Charlyn	93 Peg Shop Rd.	Emporia, KS 66801
C0020	Wick, Verlie	7516 South Road	Riverview, FL 33569
C0021	Scruggs, Rona	61 Applegate Avenue	Marlton, NJ 08053
	C0022	Kinder, Lavone	8477 W. Wood Street	Zanesville, OH 43701
	C0023	Isom, Eleni	169 Ann Road	Bear, DE 19701
C0024	Montanez, Nichelle	9831 Primrose Drive	Bay Shore, NY 11706
C0025	Best, Filiberto	60 John Street	Maspeth, NY 11378
	C0026	Echols, Quyen	7168 Yukon Ave.	Park Ridge, IL 60068
	C0027	Allan, Gidget	808 S. New Saddle St.	Billerica, MA 01821
	C0028	Crisp, Sol	8690 Leeton Ridge St.	Hummelstown, PA 17036
C0029	Jeffries, John	9447 Ivy Dr.	Ankeny, IA 50023
C0030	Gorman, Yael	9372 Inverness Ave.	Henrico, VA 23228
C0031	Bivens, Lona	81 Newport Lane	Chelmsford, MA 01824
C0032	Frame, Yolande	42 Vernon Street		Fort Lauderdale, FL 33308
C0033	Huerta, Candie	958 Sierra Ave.	Pensacola, FL 32503
C0034	Clancy, Twanda	552 Trenton Rd.	Portland, ME 04103
		C0035	Dunbar, Rosenda	543 SW. St Louis Ave.	Hartselle, AL 35640
	C0036	Smothers, Tabetha	8281 Hillside Ave.	Bradenton, FL 34203
C0037	Chapin, Tayna	793 Glendale Avenue	Catonsville, MD 21228
	C0038	Juarez, Alysa	9906 Addison St.	Sun Prairie, WI 53590
	C0039	Krieger, Gia	58 East Meadow Dr.	Melbourne, FL 32904
C0040	Mcmillen, Millard	692 White Lane	Mahwah, NJ 07430
		C0041	Kirby, Marth	299 E. Cherry Hill Lane
C0042	Low, Yi	7608 Dunbar Dr.	Petersburg, VA 23803
C0043	Haller, Lecia	7376 Pulaski Rd.	Hazleton, PA 18201
C0044	Villalobos, Ellsworth	7209 Henry Smith Street	Waldorf, MD 20601
	C0045	Fitzsimmons, Alta	314 El Dorado Street	Scotch Plains, NJ 07076
C0046	Loper, Cleopatra	225 King Drive	Rosedale, NY 11422
C0047	Rowan, Shonta	60 Roosevelt St.	Cranberry Twp, PA 16066
C0048	Gee, Orpha	7512 Stonybrook Rd.	Olive Branch, MS 38654
C0049	Leslie, Stefanie	714 Country Drive
	C0050	Cardona, Jasper	7558 Oxford St.	Ridgecrest, CA 93555

2018-11-25

	EmployeeID	EmployeeName	Phone	Email	DateOfLastReview
	E0001	Correia, Sammie	751-977-6807	s.correia@email.com
		E0002	Lentz, Tamisha	958-469-1408	t.lentz@email.com		2018-11-25
E0003	Rendon, Reiko	751-842-7254	r.rendon@email.com	2018-07-17
		E0004	Robb, Charla	751-658-5815	c.robb@email.com
		E0005	Atwell, Shu	424-952-2502	s.atwell@email.com
	E0006	Miner, Nathanael	700-479-8999	n.miner@email.com	2019-02-10
	E0007	Paquette, Christia	976-891-6875	c.paquette@email.com	2019-04-14
	E0008	Hathaway, Consuela	751-762-4200	c.hathaway@email.com	2019-07-25
	E0009	Latham, Kaylene	958-618-8599	k.latham@email.com	2019-09-11
		E0010	Aquino, Irish	950-559-1704	i.aquino@email.com	2019-03-08
	E0011	Batson, Hayley	857-247-8670	h.batson@email.com	2018-06-12
	E0012	Escamilla, Winter	751-470-1181	w.escamilla@email.com	2018-07-04
E0013	Coulter, Ashli	600-227-2901	a.coulter@email.com	2019-02-16
E0014	Delaney, Alexis	969-540-7928	a.delaney@email.com
E0015	Gallegos, Gwyneth	870-406-7690	g.gallegos@email.com	2018-10-10
E0016	Betancourt, Tori	600-617-8495	t.betancourt@email.com	2019-09-01
	E0017	South, Ray	711-547-4794	r.south@email.com
E0018	Burdette, Elza	600-210-4842	e.burdette@email.com	2018-01-16
E0019	Farr, Elwood	959-294-7770	e.farr@email.com	2018-01-17
	E0020	Braswell, Celesta	424-742-7627	c.braswell@email.com	2019-02-28
E0021	Hyland, Keturah	822-717-2870	k.hyland@email.com	2018-12-10
E0022	Browning, Lewis	950-757-9090	l.browning@email.com	2019-09-04
E0023	Dollar, Jeri	969-287-9787	j.dollar@email.com	2019-06-23
	E0024	Scully, Kimberli	877-780-5772	k.scully@email.com	2018-09-22
E0025	Compton, Pamala	727-781-2456	p.compton@email.com	2019-01-06
	E0026	Knott, Assunta	822-912-8158	a.knott@email.com
E0027	Painter, Jayne	976-770-9602	j.painter@email.com
E0028	Arnett, Audrie	424-541-9967	a.arnett@email.com	2018-10-05
E0029	Bader, Donny	950-279-2272	d.bader@email.com	2018-08-19
E0030	Mahon, Kaylee	870-641-7846	k.mahon@email.com	2018-07-24
	E0031	Cotter, Anjanette	751-622-7076	a.cotter@email.com	2018-08-08
	E0032	Devore, Winford	700-896-4017	w.devore@email.com	2019-05-21
E0033	Witt, Kati	276-725-7077	k.witt@email.com	2018-10-21
E0034	Finch, Suk	224-620-7087	s.finch@email.com	2018-04-18
	E0035	Grigsby, Lanny	958-578-8090	l.grigsby@email.com	2019-01-26
	E0036	Register, Caroll	950-896-5527	c.register@email.com	2018-09-06
E0037	Fontenot, Ester	969-670-2667	e.fontenot@email.com
E0038	Schmid, Antonio	822-785-1199	a.schmid@email.com
E0039	Prado, Margit	959-876-7748	m.prado@email.com	2019-06-28
E0040	Gunderson, Tamala	555-279-5807	t.gunderson@email.com
	E0041	Speer, Hilde	727-765-7677	h.speer@email.com	2018-05-24
	E0042	Cline, Twana	276-677-2875	t.cline@email.com	2018-12-26
E0043	Garnett, Antonetta	969-774-1119	a.garnett@email.com		2019-09-15
	E0044	Rivers, Oswaldo	969-599-8879	o.rivers@email.com	2019-11-27
		E0045	Mosier, Jalisa	976-850-1827	j.mosier@email.com	2019-04-13
E0046	Monk, Margo	751-871-8471	m.monk@email.com	2018-11-28
		E0047	Sellers, Sacha	600-802-2694	s.sellers@email.com
E0048	Dickerson, Arvilla	969-582-8124	a.dickerson@email.com	2018-05-28
		E0049	Jeffery, Daniela	751-546-8761	d.jeffery@email.com	2019-12-23
	E0050	Ontiveros, Jacinta	555-529-8778	j.ontiveros@email.com	2019-11-02

1

1

1

Chief Terrific Mole
2

1.99

1

1

1

1
10.0

1

16.99

1
7.0

Doctor Golden Bat
2
25.0
1.99

1

1
36.0

1

Huge Leopard
2

2.99

1
41.0

1

39.99

1

1
4.0

1
5.0

Mister Rapid Angel
2
10.0
2.99

1
36.0
29.99

1
20.0
35.99

1
2.0
39.99

Old Snipe
2

5.99

1

40.99

1

1
1.0

1

Solar Flare
2

5.99

1

40.99

1
9.0
14.99

1
3.0

1
24.0
40.99

1
55.0

1

29.99

1
20.0
16.99

1
24.0

The Golden Guard
2

4.99

1

The Long Gorilla
2
4.0
5.99

1

1
10.0
18.99

The Marvelous Ant
2
19.0
1.99

1
0.0

1

18.99

1
10.0

The Silver Elephantman
2
3.0
2.99

1
5.0

1
36.0
45.99

	SKU	ItemName	ItemTypeID	Inventory	Qty	Retail
1314005876	Alpha Dog				3		6.0		1	4.99
				1314015876	Broad Macaw			2	0.0	3			1.99
		1314045876		Chief Terrific Mole		2								5.0	44.99
1314055876									10.0
1314085876	Chief Whispering Hammer	4												2.0	49.99
1314095876	Dark Spider		55.0			18.99
1314125876	Doctor Defiant Bat		4																																					1.0		3			5.99
	1314135876	Doctor Dynasty			16.99
1314165876	Doctor Fancy Fox	3		7.0
		1314175876		Doctor Golden Bat	23.99
	1314205876
1314215876	Doctor Misty Wonder	32.0				39.99
	1314245876	Famous Mastermind	4			2.99
	1314255876		Huge Leopard								9.0	13.99
	1314285876	1						4.0
1314295876	Kind Scorpion	43.99
		1314325876	Master Marvelous Magician							3.0
1314335876	Metanite	1	8.0				40.99
1314365876	Mister Quick Lion			29.99
	1314375876		Mister Rapid Angel		31.99
1314405876
1314415876	Nifty Dagger
							1314445876	Nightwave
	1314455876		Old Snipe
1314485876			24.0
	1314495876	Razor	26.0
1314525876	Saberleaf	43.0	26.99
	1314535876	Scarlet Sentinel	19.99
1314565876		Solar Flare		19.0	33.99
	1314575876						13.0
	1314605876	The Bronze Wasp	45.0
	1314615876	The Colossal Rhino
		1314645876	The Colossal Tiger	37.99
		1314655876	The Electric Cricket
		1314685876	The Elegant Seer	47.99
		1314695876	The Ethereal Ant	52.0
1314725876	The Giant Commando
		1314735876		The Golden Guard		24.99
1314765876								15.0
	1314775876		The Long Gorilla					14.0	21.99
	1314805876
		1314815876	The Macho Crane	33.0		45.99
	1314845876		The Marvelous Ant
				1314855876
1314885876	The Orange Warden	25.99
1314895876	The Rapid Sage	47.0
1314925876		The Silver Elephantman	10.99
1314935876
1314965876	The Steel Swallow	34.99
	1314975876	The Yellow Jackal

ID
mSysRowId
1

Qquk6YEUrtFUP3kUBVIQ27aLxMo41fxpTrBk4wCmDkI=-~2Xb6Z4u1ok8u1etzHdU3rg==

EmployeeID
mSysRowId

C0019

E0010

C0041

E0026
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0026

E0049
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0004
2019-06-10
E0002
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0009
2019-06-10
E0011
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0017

E0045
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0005

E0004
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0001
2019-07-12
E0042
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0022

E0041
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0045
2019-08-13
E0035
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0002
2019-08-13
E0008
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0014

E0031
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0018

E0047
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0008
2019-09-14
E0005
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0012
2019-09-15
E0044
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0008

E0036
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0008

E0002
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0010
2019-10-16
E0004
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0028

E0045
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0012
2019-10-17
E0032
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0038
2019-10-17
E0047
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0050
2019-10-17
E0017
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0041

E0010
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0036
2019-10-18
E0006
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0013

E0012
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0008
2019-10-19
E0009
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0039

E0024
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0001

E0007
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0035

E0020
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0027

E0050
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0035
2019-12-21
E0049
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0023

E0005
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

C0018
2019-12-22
E0001
RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==

	OrderID	CustomerID	OrderDate
		O0001	2019-05-06																																	RVQBTB37lhhpJj+I9+fo4Mg2MNENYOlsaC2yDkj1S54=-~rI0OuCsJ6cXy/sNJ/NCXBg==
	O0002	2019-05-09
	O0003			2019-06-10
	O0004
	O0005
	O0006	2019-07-11
	O0007		2019-07-12
	O0008
		O0009			2019-08-13
		O0010
	O0011
	O0012	2019-08-14
		O0013		2019-09-14
	O0014
	O0015
					O0016	2019-09-16
	O0017		2019-10-16
		O0018
	O0019				2019-10-17
		O0020
		O0021
	O0022
				O0023		2019-10-18
	O0024
	O0025		2019-10-19
	O0026
			O0027	2019-11-19
	O0028	2019-11-20
	O0029	2019-12-20
	O0030		2019-12-21
	O0031
	O0032		2019-12-22
	O0033

OrderID

Qty

SKU
mSysRowId

O0001
1.0
15.0

1314615876

O0001
2.0

1314015876

O0002
1.0
2.0

1314655876

O0003
1.0
15.0

1314855876

O0004
1.0
14.0

1314045876

O0005
1.0
15.0

1314255876

O0006
1.0
9.0

1314445876

O0007
1.0
5.0

1314845876

O0008
1.0
9.0

1314015876

O0009
1.0

1314855876

O0009
2.0
10.0

1314685876

O0010
1.0
9.0
323.91
1314445876

O0010
2.0
4.0

1314045876

O0011
1.0
1.0
24.99
1314735876

O0012
1.0
4.0

1314775876

O0013
1.0
14.0

1314325876

O0013
2.0
9.0
323.91
1314445876

O0014
1.0
9.0

1314645876

O0015
1.0
15.0
29.85
1314855876

O0016
1.0
5.0

1314815876

O0016
2.0
15.0

1314285876

O0016
3.0
5.0

1314015876

O0016
4.0
13.0

1314455876

O0016
5.0
10.0

1314975876

O0017
1.0
13.0

1314645876

O0018
1.0
6.0

1314445876

O0018
2.0
1.0
31.99
1314015876

O0019
1.0
7.0

1314245876

O0020
1.0
3.0

1314445876

O0020
2.0
12.0

1314495876

O0021
1.0
5.0
159.95
1314375876

O0021
2.0
9.0

1314805876

O0022
1.0
14.0

1314205876

O0023
1.0
15.0

1314605876

O0023
2.0
13.0

1314685876

O0023
3.0
10.0

1314695876

O0023
4.0
6.0

1314135876

O0024
1.0
13.0

1314535876

O0025
1.0
10.0

1314175876

O0026
1.0
13.0

1314855876

O0027
1.0
11.0

1314445876

O0027
2.0
12.0

1314695876

O0027
3.0
11.0

1314575876

O0028
1.0
12.0
491.88
1314655876

O0029
1.0
8.0

1314815876

O0030
1.0
15.0

1314445876

O0031
1.0
5.0

1314175876

O0032
1.0
14.0

1314735876

O0033
1.0
1.0
39.99
1314325876

LineNum	Price
224.85
		11.0	351.89
81.98
	29.85
629.86
209.85
		323.91
94.94999999999999
287.90999999999997
			12.0	23.88
479.90000000000003
179.96
87.96
559.86
341.91
229.95000000000002
44.85
	159.95
519.87
459.90000000000003
493.87
215.94
300.93
107.97
	491.88
53.910000000000004
27.86
614.85
623.87
299.9
101.94
259.87
239.89999999999998
25.87
395.89000000000004
359.88
65.89
367.92
539.85
119.94999999999999
349.85999999999996

SELECT Inventory.SKU, Inventory.ItemName, Inventory.InventoryQty, Inventory.Retail
FROM Inventory;
SELECT [Order Data].OrderDate, Sum([Order Item].[Price]) AS OrderLineCost
FROM [Order Data] INNER JOIN [Order Item] ON [Order Data].OrderID = [Order Item].OrderID
GROUP BY [Order Data].OrderDate;
SELECT Employees.EmployeeName, Employees.DateOfLastReview
FROM Employees
ORDER BY Employees.EmployeeName;
SELECT Inventory.SKU, Inventory.ItemName, Inventory.InventoryQty, Inventory.Retail
FROM Inventory;

Grader – Instructions Access

2

0

1

9

Project

Exp19_Access_Ch0

5

_Cap – Varmel Studio Toys 1.2

Project Description:

You work as the database manager at Varmel Studio Toys, located in Lansing, Michigan. Varmel Studio Toys has the world’s largest selection of collectible superhero posters and action figures. Your task is to add validation rules, create a form that data entry associates can use to add new items to the inventory, and create a new table to classify items as a poster or action figure. You will also use queries to analyze existing data.

Steps to Perform:

8

6

6

8

8

12

12

12

12

0

Step	Instructions	Points Possible
1	Start Access. Open the file named Exp19_Access_Ch05_Cap_Varmel_Studio_Toys.accdb. Grader has automatically added your last name to the beginning of the filename.		0
2	You will save the database file with a new name and create a new table that will be the source for a lookup. Save the database file as Exp19_Access_Ch05_Cap_Varmel_Studio_Toys_LastFirst.accdb. Use Design view to create a new table. Add ItemTypeID as the first field name, with data type AutoNumber; add ItemTypeDescription as the second field name, with data type Short Text and field size 15.				8
3	Ensure ItemTypeID is set as the primary key. Save the table and name it Item Types. Add two records: Action Figure and Poster. Close the table.
4	You will edit the Inventory table design to validate data. You will make two fields required and add a validation rule to a field. You will also make sure you test the validation to make sure the rules work as intended. Open the Inventory table in Design view. Set the InventoryQty and ItemTypeID fields to Required.			6
5	Establish a validation rule for the InventoryQty field that requires the value to be greater than or equal to zero. Create validation text for the InventoryQty: The value of this field must be 0 or greater. (include the period). Save the table. Switch to Datasheet view. Change the InventoryQty in the first record to -2. The validation text appears. Close the message box, then press Esc to restore the original InventoryQty value. Close the Inventory table.
To help keep data input consistent, you will add input masks to the Phone fields in the Employees table. Open the Employees table in Design view. Add a phone number input mask for the Phone field, storing with the symbols. Save and close the table.	16
7	You will convert the ItemTypeID field in the Inventory table to a lookup field, using the new table you created previously as the source for the values in the lookup field. Open the Inventory table in Design view. Change the Data Type of the ItemTypeID field to Lookup Wizard. Use the Item Types table for the values in the lookup field, select both fields in the table, accept the default sort, hide the key field from the user, and then accept the default name ItemTypeID. Save the table. Switch to Datasheet view. Change the item type to Poster in the first record and click the second record. If the record updates successfully, change the first record back to Action Figure. Close the table.
You will modify an existing query to add a parameter so employees doing data entry can quickly get a list of inventories below a certain level. Open the Find Low Inventory query in Design view. Add criteria for the InventoryQty field. The user should be prompted to Enter Threshold. The query should display all results that are less than or equal to the threshold but greater than or equal to 1. Run the query. Enter 2 when prompted to Enter Threshold. You should have two results. Save and close the query.					12
9	You will modify the Rounded Item Prices query to round retail values for items in the inventory. Open the Rounded Item Prices query in Design view. Create a new column to round the Retail price of each item to the nearest dollar. Name the field RoundedRetail. Save the query. Create a new column to display Premium for all items that have a RoundedRetail value of $35 or more and Standard for items that are less than $35. Name the field Class. Run the query. Save and close the query.
10	You will also create a query to display employees who are in line for a performance review. Open the Overdue Employee Reviews query in Design view. Add a new column to determine if an employee’s performance review is overdue. If the employee’s DateOfLastReview is null, it should display Overdue. If not, it should display nothing. Name the column ReviewStatus. Add criteria of Overdue to the column you just created, so only the employees who are Overdue display. Run the query. Ensure only employees with null DateOfLastReview display. Save and close the query.
11	You will modify an existing query displaying daily totals to instead display monthly totals. Open the Order Totals By Month query in Design view. Change the first column so that instead of grouping by the order date, you group by the month. Use the DatePart function to extract the month from the date. Name the column MonthNumber. Run the query. The first line should read 5 (as the month, representing May), with a total of $658.72. Save and close the query.
Save the database. Close the database, and then exit Access. Submit the database as directed.

Total Points

100

Created On: 07/11/2019 1 Exp19_Access_Ch05_Cap – Varmel Studio Toys 1.2