-AC2019-SkillReview-5-1.accdb
| ClassCode | Section | Time | Room | Professor | CourseNumber |
| 1012 | 1 | MWF 8:00-8:50 | SBS311 | 100 | ACC-201 |
| 1013 | 2 | MWF 9:00-9:50 | SBS200 | 100 | ACC-201 |
| 1014 | 3 | TTh 2:30-3:45 | SBS252 | 100 | ACC-201 |
| 1015 | 1 | MWF 10:00-10:50 | DONS311 | 100 | ACC-202 |
| 1016 | 2 | Th 6:00-8:40 | DON252 | 100 | ACC-202 |
| 1017 | 1 | MWF 9:00-9:50 | SBS209 | 199 | CIS-201 |
| 1018 | 2 | MWF 9:00-9:50 | SBS211 | 199 | CIS-201 |
| 1019 | 3 | MWF 10:00-10:50 | DON209 | 199 | CIS-201 |
| 1020 | 2 | TTH 8:30-9:45 | SBS521 | 230 | FIN-210 |
| 1021 | 1 | TTH 11:30-12:45 | SBS508 | 325 | MKT-210 |
| 1022 | 1 | MWF 8:00-8:50 | SBS311 | 199 | CIS-120 |
| 1023 | 1 | MWF 9:00-9:50 | SBS200 | 199 | CIS-212 |
| 1024 | 1 | TTh 2:30-3:45 | SBS252 | 199 | CIS-244 |
| 1025 | 1 | MWF 10:00-10:50 | DONS311 | 199 | CIS-310 |
| 1026 | 1 | Th 6:00-8:40 | DON252 | 199 | CIS-414 |
| 1027 | 1 | MWF 9:00-9:50 | SBS209 | 199 | CIS-423 |
| 1028 | 1 | MWF 9:00-9:50 | SBS211 | 199 | CIS-445 |
| 1029 | 1 | MWF 10:00-10:50 | DON209 | 205 | ECN-101 |
| 1030 | 1 | TTH 10:00-11:15 | SBS521 | 205 | ECN-102 |
| 1031 | 1 | TTH 11:30-12:45 | SBS508 | 205 | ECN-122 |
| 1032 | 1 | MWF 8:00-8:50 | SBS311 | 205 | ECN-402 |
| 1033 | 1 | MWF 9:00-9:50 | SBS200 | 228 | ENG-101 |
| 1034 | 1 | TTh 2:30-3:45 | SBS252 | 228 | ENG-102 |
| 1035 | 1 | MWF 10:00-10:50 | DONS311 | 230 | FIN-210 |
| 1036 | 1 | Th 6:00-8:40 | DON252 | 311 | MGT-101 |
| 1037 | 1 | MWF 9:00-9:50 | SBS209 | 311 | MGT-200 |
| 1038 | 1 | MWF 9:00-9:50 | SBS211 | 311 | MGT-313 |
| 1039 | 1 | MWF 10:00-10:50 | DON209 | 311 | MGT-317 |
| 1040 | 1 | TTH 10:00-11:15 | SBS521 | 325 | MKT-101 |
| 1041 | 1 | TTH 11:30-12:45 | SBS508 | 325 | MKT-317 |
| 1042 | 1 | TTH 10:00-11:15 | SBS521 | 325 | MKT-420 |
| 1043 | 1 | TTH 11:30-12:45 | SBS508 | 325 | MKT-423 |
| 1050 | 2 | MWF 9:00-9:50 | DON209 | 205 | ECN-101 |
| 1051 | 2 | MWF 10:00-10:50 | SBS200 | 228 | ENG-101 |
| 1052 | 3 | TTH 10:00-11:15 | DONS311 | 230 | FIN-210 |
| CourseNumber | CourseDescription | Credits | DeptCode |
| ACC-201 | Accounting I | 3.0 | ACC |
| ACC-202 | Accounting II | 3.0 | ACC |
| CIS-120 | Information Technology and Productivity Tools | 3.0 | CIS |
| CIS-201 | Data and Decision Analysis | 3.0 | CIS |
| CIS-212 | Web Design | 3.0 | CIS |
| CIS-244 | Web Application Development | 3.0 | CIS |
| CIS-310 | Management Information Systems | 3.0 | CIS |
| CIS-414 | Object-Oriented Programming | 3.0 | CIS |
| CIS-423 | Database Management Systems | 3.0 | CIS |
| CIS-445 | Data Mining and Business Intelligence | 3.0 | CIS |
| ECN-101 | Principles of Micro Economics | 4.0 | ECN |
| ECN-102 | Principles of Macro Economics | 3.0 | ECN |
| ECN-122 | Poverty and Inequality | 4.0 | ECN |
| ECN-402 | Mathematical Economics | 4.0 | ECN |
| ENG-101 | Freshman English I | 4.0 | ENG |
| ENG-102 | Freshman English II | 4.0 | ENG |
| FIN-210 | Personal Finance | 3.0 | FIN |
| MGT-101 | Business Foundations | 3.0 | MGT |
| MGT-200 | Leadership and Social Responsibility | 3.0 | MGT |
| MGT-313 | Human Resource Management | 3.0 | MGT |
| MGT-317 | Organizational Behavior | 3.0 | MGT |
| MKT-101 | Marketing Foundations | 3.0 | MKT |
| MKT-210 | Principles of Marketing | 3.0 | MKT |
| MKT-317 | Consumer Behavior | 3.0 | MKT |
| MKT-420 | Marketing for Entrepreneurs | 3.0 | MKT |
| MKT-423 | Retail Strategy | 3.0 | MKT |
| DeptCode | DeptName |
| ACC | Accounting |
| CIS | Computer Information Systems |
| ECN | Economics |
| ENG | English |
| FIN | Finance |
| MGT | Management |
| MKT | Marketing |
| BIO | Biology |
| CHM | Chemistry |
| HST | History |
| MTH | Mathematics |
| PSY | Psychology |
| StudentID | LastName | FirstName | DOB | Credits | Classification |
| 1099 | Penna | Jeffrey | 5/29/03 | 0 | Fr |
| 1199 | George | Adrianna | 6/3/03 | 0 | Fr |
| 1299 | Stone | David | 11/30/03 | 0 | Fr |
| 1799 | Chan | William | 2/8/03 | 0 | Fr |
| 1800 | Rodriguez | Martine | 4/14/02 | 10 | Fr |
| 1801 | Zhu | Jim | 11/30/02 | 0 | Fr |
| 1802 | Anderson | Felix | 8/23/03 | 6 | Fr |
| EmployeeID | LastName | FirstName | DeptCode |
| 100 | Eagle | Arnold | ACC |
| 199 | Marple | Susan | CIS |
| 205 | Kane | Stephen | ECN |
| 228 | Stick | Leslie | ENG |
| 230 | Grahma | James | FIN |
| 311 | Ornstin | Kenneth | MGT |
| 325 | Stick | Anthony | MKT |
| StudentID | LastName | FirstName | DOB | Credits | Classification | GPA | Advisor |
| 3157 | Fine | Ellen | 10/24/99 | 90 | Jr | 3.2 | 205 |
| 3158 | Coyne | Jack | 9/1/01 | 68 | So | 3.5 | 228 |
| 3169 | Hunt | Christine | 6/24/00 | 90 | Jr | 2.5 | 230 |
| 3173 | Carlman | Mark | 1/1/97 | 124 | Sr | 3.0 | 199 |
| 3174 | Davis | Brianna | 8/30/97 | 126 | Sr | 4.0 | 228 |
| 3191 | Phillipo | Ryan | 2/16/97 | 127 | Sr | 3.5 | 311 |
| 3199 | Auger | Amanda | 6/2/02 | 34 | Fr | 2.7 | 230 |
| 4257 | Celleb | Mark | 11/13/00 | 90 | Jr | 3.5 | 205 |
| 4258 | Smith | Julie | 8/22/02 | 68 | So | 2.8 | 228 |
| 4269 | Zeer | Glen | 9/14/98 | 120 | SR | 4.0 | 311 |
| 4273 | Marraz | Arthur | 12/29/98 | 124 | Sr | 3.9 | 199 |
| 4274 | Harrington | Rachel | 10/19/96 | 126 | Sr | 3.0 | 228 |
| 4291 | Flagg | Brian | 4/6/97 | 127 | Sr | 2.8 | 311 |
| 4299 | Smith | John | 11/29/02 | 34 | Fr | 2.9 | 230 |
| 4452 | Bow | Anthony | 2/11/00 | 64 | So | 3.6 | 205 |
| 4463 | Goulet | Dahlia | 11/17/01 | 64 | So | 3.8 | 205 |
| 5257 | Faris | Ann | 10/13/00 | 65 | SO | 3.8 | 205 |
| 5258 | Allen | Mike | 7/31/01 | 68 | So | 3.5 | 228 |
| 5269 | Gold | Katie | 2/14/97 | 90 | Jr | 2.5 | 230 |
| 5273 | Park | Megan | 1/2/95 | 124 | Sr | 2.0 | 199 |
| 5274 | Smalls | Taylor | 12/30/97 | 126 | Sr | 4.0 | 228 |
| 5291 | Flood | Laura | 12/13/99 | 127 | Sr | 2.8 | 311 |
| 5299 | Della | Angelo | 5/28/02 | 34 | Fr | 3.7 | 230 |
| 5452 | Cell | Anthony | 5/20/01 | 64 | So | 3.6 | 205 |
| 5463 | Graham | Janice | 10/31/00 | 64 | So | 3.6 | 205 |
| 6357 | Vittum | Martin | 12/24/98 | 90 | Jr | 2.3 | 205 |
| 6358 | Cahill | Regina | 7/24/97 | 68 | So | 3.5 | 228 |
| 6369 | Haddeed | Eileen | 7/5/99 | 90 | Jr | 2.5 | 311 |
| 6373 | Faddil | Kathleen | 7/18/98 | 124 | Sr | 3.0 | 199 |
| 6374 | McDonald | Tyler | 3/17/95 | 126 | Sr | 4.0 | 228 |
| 6391 | Marks | Arnold | 5/23/99 | 127 | Sr | 3.9 | 311 |
| 6399 | Chin | William | 2/7/02 | 34 | Fr | 2.9 | 230 |
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;
Lazarus
