Access Skills Approach

Jiawei.Yu-AC2016-ChallengeYourself-3-3.accdb

Home >Computer Science homework help >Access Skills Approach

EmployeeID	FirstName	LastName	Position	WeeklyHours	MobilePhone
11782741	Gary	Miller	Greenhouse Tech 2	20	202-555-1234
23605379	Jasmin	Singleton	Greenhouse Tech 2	20	301-555-1045
31269314	Paola	Rojas	Greenhouse Tech 1	30	301-555-2430
59267312	Tracy	Morber	Supervisor	20	703-555-8899
68023812	Dale	Barnes	Greenhouse Tech 1	35	202-555-4455
77813350	George	Russell	Greenhouse Tech 3	15	703-555-4456

MaintenanceID	MaintenanceDate	Employee	Watered	Inspected	Pruned	Plant
1	9/15/16	11782741	false	false	true	ALFA2
2	9/18/16	31269314	true	true	true	ASTU
3	9/18/16	31269314	true	true	false	RUHI2
4	9/18/16	31269314	true	true	false	AMTA2
5	9/18/16	31269314	false	true	false	ASTU
6	9/18/16	31269314	false	true	true	MOPU
7	9/21/16	59267312	true	false	false	YUFI
8	9/21/16	59267312	true	false	false	HEDE4
9	9/21/16	59267312	false	true	true	RUHI2
10	9/21/16	59267312	false	true	false	COGL2
11	9/21/16	59267312	false	true	false	AGPU5
12	9/22/16	31269314	true	false	false	ALFA2
13	9/22/16	31269314	false	true	false	ASTU
14	9/22/16	31269314	true	true	false	RUHI2
15	9/22/15	59267312	false	true	false	HEDE4
16	9/25/16	11782741	true	true	false	RHVI
17	9/25/16	11782741	false	true	false	ALFA2
18	9/25/16	11782741	false	true	true	MOPU
19	9/25/16	31269314	false	true	true	RHCA7
20	9/25/16	31269314	true	false	false	PECO4
21	9/26/16	11782741	true	true	false	MOFI
22	9/30/16	11782741	false	true	false	COER
23	9/30/16	59267312	true	true	false	ALFA2

CommonName	ScientificName	PrimaryColor	DatePlanted	PurchasePrice	PlantID
Gerardia	Agalinis purpurea	Violet	4/11/13	¤ 4.50	AGPU5
White colicroot	Aletris farinosa	White	4/9/14	¤ 7.50	ALFA2
Eastern bluestar	Amsonia tabernaemontana	Blue	5/1/09	¤ 7.50	AMTA2
Wind-flower	Anemone berlandieri	Violet	4/11/13	¤ 4.00	ANBE
Eastern red columbine	Aquilegia canadensis	Red	3/29/10	¤ 8.25	AQCA
Butterflyweed	Asclepias tuberosa	Orange	3/31/12	¤ 11.50	ASTU
White wild indigo	Baptisia alba	White	4/15/04	¤ 6.25	BAAL
Blue wild indigo	Baptisia australis	Blue	5/6/15	¤ 6.25	BAAU
Widow's tears	Commelina erecta	Blue	5/6/15	¤ 4.95	COER
Coastal tickseed	Coreopsis gladiata	Yellow	4/21/13	¤ 3.15	COGL2
Lanceleaf tickseed	Coreopsis lanceolata	Yellow	5/12/13	¤ 5.25	COLA5
Georgia tickseed	Coreopsis nudata	Pink	3/31/12	¤ 3.15	CONU5
Firewheel	Gaillardia pulchella	Red	3/31/12	¤ 5.50	GAPU
Spotted geranium	Geranium maculatum	Violet	9/15/12	¤ 4.50	GEMA
Beach sunflower	Helianthus debilis	Yellow	4/19/13	¤ 3.50	HEDE4
Standing cypress	Ipomopsis rubra	Red	4/21/13	¤ 6.50	IPRU2
Seashore mallow	Kosteletzkya virginica	White	4/30/16	¤ 8.25	KOVI
Cardinal flower	Lobelia cardinalis	Red	4/30/16	¤ 9.50	LOCA2
Wild lupine	Lupinus perennis	Blue	4/30/16	¤ 5.85	LUPE3
Wild bergamot	Monarda fistulosa	Pink	4/30/16	¤ 3.50	MOFI
Horsemint	Monarda punctata	White	4/21/13	¤ 4.90	MOPU
Wild foxglove	Penstemon cobaea	White	5/12/13	¤ 2.90	PECO4
Trailing phlox	Phlox nivalis	Pink	3/30/06	¤ 2.50	PHNI
Savannah meadowbeauty	Rhexia alifanus	Pink	3/31/12	¤ 1.90	RHAL4
Wild azalea	Rhododendron canescens	White	4/11/13	¤ 10.50	RHCA7
Handsome Harry	Rhexia virginica	Pink	4/9/14	¤ 6.80	RHVI
Black-eyed Susan	Rudbeckia hirta	Yellow	4/21/13	¤ 3.15	RUHI2
Scarlet sage	Salvia coccinea	Red	4/9/14	¤ 8.20	SACO5
Adam's needle	Yucca filamentosa	White	5/6/15	¤ 10.90	YUFI

SELECT [Plants].[PlantID], [Plants].[CommonName] FROM Plants ORDER BY [CommonName];

SELECT [Employees].[EmployeeID], [Employees].[LastName], [Employees].[FirstName] FROM Employees ORDER BY [LastName];

SELECT MaintenanceLog.MaintenanceDate, MaintenanceLog.Employee, MaintenanceLog.Plant, MaintenanceLog.Watered FROM MaintenanceLog;

SELECT DISTINCTROW * FROM Plants;