Microsoft Access 2019 Skill Review 5-1

I am looking for someone to complete the Microsoft Access assignment.

1

1

11

0

-201

2

ACC-201

3

100 ACC-201

1

100

2

100 ACC-202

1 MWF 9:00-9:50

-201

2 MWF 9:00-9:50

199

3 MWF 10:00-10:50

199 CIS-201

2

-210

1

-210

1 MWF 8:00-8:50

199

1 MWF 9:00-9:50 SBS200 199

1 TTh 2:30-3:45 SBS252 199

1 MWF 10:00-10:50

199

1 Th 6:00-8:40 DON252 199

1 MWF 9:00-9:50 SBS209 199

1 MWF 9:00-9:50 SBS211 199

1 MWF 10:00-10:50 DON209

-101

1

SBS521 205

1 TTH 11:30-12:45 SBS508 205

1 MWF 8:00-8:50 SBS311 205

1 MWF 9:00-9:50 SBS200

-101

1 TTh 2:30-3:45 SBS252 228

1 MWF 10:00-10:50 DONS311 230 FIN-210

1 Th 6:00-8:40 DON252 311

-101

1 MWF 9:00-9:50 SBS209 311

1 MWF 9:00-9:50 SBS211 311

1 MWF 10:00-10:50 DON209 311

1 TTH 10:00-11:15 SBS521 325

1 TTH 11:30-12:45 SBS508 325

1 TTH 10:00-11:15 SBS521 325

1 TTH 11:30-12:45 SBS508 325

2 MWF 9:00-9:50 DON209 205 ECN-101

2 MWF 10:00-10:50 SBS200 228 ENG-101

3 TTH 10:00-11:15 DONS311 230 FIN-210

ClassCode	Section	Time	Room	Professor		CourseNumber
																										1					0						2			MWF 8:00-8:50	SBS			3						10								ACC
1013										MWF 9:00-9:50				SBS200	100
1014			TTh 2:30-3:45			SBS252
1015							MWF 10:00-10:50			DONS											311			ACC-202
101	6			Th 6:00-8:40			DON252
1017			SBS209															199													CIS
1018			SBS211	CIS-201
1019				DON209
1020	TTH 8:30-9:45				SBS521										230							FIN
1021				TTH 11:30-12:45				SBS508						325								MKT
1022		SBS311		CIS-	120
1023		CIS-212
1024		CIS-244
1025	DONS311		CIS-310
1026		CIS-414
1027		CIS-423
1028		CIS-445
1029														205									ECN
1030				TTH 10:00-11:15		ECN-102
1031		ECN-122
1032		ECN-402
1033												228							ENG
10				34		ENG-102
1035
1036								MGT
1037		MGT-200
1038		MGT-313
1039		MGT-317
1040		MKT-101
1041		MKT-317
1042		MKT-420
1043		MKT-423
1050
1051
1052

CourseNumber

ACC-201

I

ACC

ACC-202

3.0 ACC

CIS-120

3.0 CIS

CIS-201

3.0 CIS

CIS-212

3.0 CIS

CIS-244

3.0 CIS

CIS-310

Information Systems

3.0 CIS

CIS-414

3.0 CIS

CIS-423

3.0 CIS

CIS-445

3.0 CIS

ECN-101

ECN

ECN-102

3.0 ECN

ECN-122

4.0 ECN

ECN-402

4.0 ECN

ENG-101

eshman

I

4.0 ENG

ENG-102

4.0 ENG

FIN-210

3.0 FIN

MGT-101

3.0 MGT

MGT-200

cial Responsibility

3.0 MGT

MGT-313

3.0 MGT

MGT-317

3.0 MGT

MKT-101

eting

Foundations

3.0 MKT

3.0 MKT

MKT-317

3.0 MKT

MKT-420

3.0 MKT

MKT-423

3.0 MKT

CourseDescription			Credits			DeptCode
	Accounting																								3.0
Accounting II
Information Technology and Productivity Tools
Data and Decision Analysis
Web Design
Web Application Development
	Management
Object-Oriented Programming
Database Management Systems
Data Mining and Business Intelligence
Principles of Micro	Economics									4.0
Principles of Macro Economics
Poverty and Inequality
Mathematical Economics
											Fr	English
Freshman English II
Personal	Finance
Business Foundations
Leadership and								So
Human Resource Management
Organizational Behavior
			Mark
MKT-210	Principles of Marketing
Consumer Behavior
Marketing for Entrepreneurs
Retail Strategy

DeptCode

ACC Accounting
CIS

ECN Economics
ENG English
FIN Finance
MGT Management
MKT Marketing

DeptName
Computer Information Systems
BIO	Biology
CHM	Chemistry
HST	History
MTH	Mathematics
PSY	Psychology

Credits

0 Fr

0 Fr

0 Fr

0 Fr

e

10 Fr

0 Fr

6 Fr

	StudentID			LastName			FirstName		DOB		Classification
1099	Penna	Jeffrey	5/29/03
1199	George	Adrianna	6/3/03
1299	Stone	David	11/30/03
1799	Chan		William	2/8/03
1800	Rodriguez		Martin	4/14/02
1801	Zhu	Jim	11/30/02
1802	Anderson	Felix	8/23/03

LastName FirstName DeptCode

100

ACC

199

CIS

205

ECN

228

ENG

230

FIN

311

MGT

325 Stick

MKT

EmployeeID
Eagle		Arnold
Marple	Susan
Kane	Stephen
	Stick	Leslie
Grahma	James
Ornstin	Kenneth
		Anthony

StudentID LastName FirstName DOB Credits Classification

205

So

228

90 Jr

230

Mark

3.0 199

na

Sr 4.0 228

Sr 3.5 311

34 Fr

230

eb

Mark

90 Jr 3.5 205

68 So

228

120

4.0 311

124 Sr

199

126 Sr 3.0 228

Brian

127 Sr 2.8 311

Smith

34 Fr

230

Anthony

So

205

64 So

205

3.8 205

68 So 3.5 228

90 Jr 2.5 230

124 Sr

199

126 Sr 4.0 228

127 Sr 2.8 311

34 Fr

230

Cell Anthony

64 So 3.6 205

64 So 3.6 205

Martin

90 Jr

205

68 So 3.5 228

90 Jr 2.5 311

124 Sr 3.0 199

126 Sr 4.0 228

Arnold

127 Sr 3.9 311

William

34 Fr 2.9 230

GPA	Advisor
3157	Fine	Ellen	10/24/99						90						Jr	3.2
3158	Coyne	Jack	9/1/01				68					3.5
3169	Hunt	Christine	6/24/00			2.5
3173	Carlman	1/1/97				124												Sr
3174	Davis		Brian	8/30/97				126
3191	Phillipo	Ryan	2/16/97				127
3199	Auger	Amanda	6/2/02	2.7
4257		Cell	11/13/00
4258		Smith	Julie	8/22/02			2.8
4269	Zeer	Glen	9/14/98	SR
4273	Marraz	Arthur	12/29/98		3.9
4274	Harrington	Rachel	10/19/96
4291	Flagg	4/6/97
4299	John	11/29/02		2.9
4452	Bow	2/11/00				64			3.6
4463	Goulet	Dahlia	11/17/01		3.8
5257	Faris	Ann	10/13/00	65	SO
5258	Allen	Mike	7/31/01
5269	Gold	Katie	2/14/97
5273	Park	Megan	1/2/95	2.0
5274	Smalls	Taylor	12/30/97
5291	Flood	Laura	12/13/99
5299	Della	Angelo	5/28/02	3.7
5452	5/20/01
5463	Graham	Janice	10/31/00
6357	Vittum	12/24/98	2.3
6358	Cahill	Regina	7/24/97
6369	Haddeed	Eileen	7/5/99
6373	Faddil	Kathleen	7/18/98
6374	McDonald	Tyler	3/17/95
6391	Marks	5/23/99
6399	Chin	2/7/02

SELECT Classes.ClassCode, Classes.CourseNumber, Classes.Section, Classes.Time, Classes.Room, Classes.Professor
FROM Classes
WHERE ((([Classes].[CourseNumber]) Like “*-1*”));
SELECT [Courses].CourseNumber, [Courses].CourseDescription, Departments.DeptName, Classes.ClassCode
FROM Departments INNER JOIN (Courses INNER JOIN Classes ON [Courses].CourseNumber=Classes.CourseNumber) ON Departments.DeptCode=[Courses].DeptCode;