Develop a Windows application for the projectdeveloped in Homework #3. You should use the Access solution file IEE 305, Homework#4 IEE305_HW4_.docxHW3_Proj

IEE 305, Homework#4

1. (100 Points) Develop a Windows application for the projectdeveloped in Homework #3. You should use the Access solution file IEE 305, Homework#4

IEE 305, Homework#4

1. (100 Points) Develop a Windows application for the project developed in Homework #3. You should use the Access solution file given ‘HW3_Project_Solution.accdb’ to complete this homework. Do not use your own developed Access file. For this part of the project, you will need to incorporate all the ACCESS tables and queries into a Windows application. Students should submit the following,

· The design view, the code view, and the execution view of each Windows form in the Windows application for your project. If a Windows form displays the query, give the SQL statement view or the Query Builder view of the query.

Students should follow the example of the Windows application for the healthcare database shown in the textbook and lectures to develop the Windows application.

When submitting, you only need to submit a Word document with all the required screenshots (design view, the code view, and the execution view of each Windows form). You must order your screenshots with FormMain being first, then in alphabetical order based on the table name. E.g., FormMain, FormAssign, FormCourse, etc. Or points will be deducted.

Extra Help:

For the FormMain, it should have a list of radio buttons that can lead a user to all the sub forms. Each of the sub forms represents a table in the solution database. As we have 7 tables in the database, we will have 7 sub forms for this HW.

In each sub form of the tables, the data of the corresponding table should be presented on top. If there are any queries related to the table, you should also create a separate form for each query and handle the transitions between the forms. An example of the design view is given below:

Windows Form for the Queries:

As we have learned from the class that the built-in functions or commands of Access are different from that of Visual Studio. Therefore, if any queries in the solution implement the features given in p.10 of Lecture Notes 4.5, you should build the query in Visual Studio and provide screenshot(s) of your Query Builder. If any of the queries require grouping of records, the “Group By” field of Query Builder can be found by right clicking the table pane and you will then find the “Add Group By” option.

image1.png

image2.png

,

RoomNo CourseNo PeriodNo
CDN-60 IEE300 P04
COORL1-74 IEE376 P01
COOR170 IEE385 P05
BA241 ACC232 P11
BA365 ACC340 P02
CLCC107 STP315 P06
CLCC238 STP421 P07
ISTB2175 CEE351 P10
ISTB2175 CEE486 P03
BAC116 ECN211 P08
ED216 ECN453 P09
InstructorID CourseTitle Prerequisites CreditHours CoureLevel CourseNo NewOffer
In01 Economic Analysis for Engineers 200-level 3 Junior IEE300 false
In02 Operations Research 200-level 3 Junior IEE376 true
In03 Engineering statistics and probability 200-level 3 Junior IEE385 false
In04 Financial Accounting 100-level 3 Sophomore ACC232 true
In05 External Reporting 200-level 3 Junior ACC340 false
In06 Statistical Computing 200-level 3 Junior STP315 false
In07 Probability 300-level 3 Senior STP421 false
In08 Geotechnical Engineering 200-level 3 Junior CEE351 false
In09 Concrete Structure 300-level 3 Senior CEE486 false
In10 Macroeconomic Priciples 100-level 3 Sophomore ECN211 true
IN10 Industrial Organization 300-level 3 Senior ECN453 false
WER101 false
Name Address Department College specialty InstructorID
Jennings 121 Mill Ave. IEE Eng In01
Clough 32 College Ave. IEE Eng In02
Chattin 219 Oragne St. IEE Eng In03
Rasono 738 Rural Rd. ACC Bus In04
Huston 1975 University Dr. ACC Bus In05
Shanno 439 Forest Ave. STP Sci In06
Wang 24 Vista Del Cerro Rd. STP Sci In07
Lawrence 321 Hardon Dr. CEE Eng In08
Fox 178 101 Loop Dr. CEE Eng In09
Geogan 123 Apache Blvd. ECN Bus In10
StartTime PeriodNo Days EndTime Assigned
1899-12-30 P01 M W 1899-12-30 true
1899-12-30 P02 M W 1899-12-30 true
1899-12-30 P03 M W 1899-12-30 true
1899-12-30 P04 T Th 1899-12-30 true
1899-12-30 P05 T Th 1899-12-30 true
1899-12-30 P06 T Th 1899-12-30 true
1899-12-30 P07 T Th 1899-12-30 true
1899-12-30 P08 T Th 1899-12-30 true
1899-12-30 P09 T Th 1899-12-30 true
1899-12-30 P10 F 1899-12-30 true
1899-12-30 P11 F 1899-12-30 true
1899-12-30 P12 M W 1899-12-30 false
1899-12-30 P13 F 1899-12-30 false
StudentID CourseNo
S01 IEE300
S01 STP315
S02 ACC232
S02 IEE376
S03 ACC340
S03 STP315
S04 IEE300
S04 IEE385
S05 STP315
S05 STP421
S06 STP421
S06 IEE376
S07 CEE351
S07 IEE376
S08 CEE486
S08 IEE385
S09 IEE376
S09 STP421
S10 ECN211
S10 IEE300
S11 ECN453
S11 STP315
S12 STP315
S12 IEE300
S13 ACC340
S13 STP315
S14 IEE300
S14 CEE351
S15 CEE351
S15 IEE376
S16 CEE486
S16 STP315
S17 IEE385
S17 ACC340
S18 IEE376
S18 IEE385
S19 ECN453
S19 ECN211
S20 STP421
S20 IEE385
S21 CEE486
S21 CEE351
S22 CEE351
S22 CEE486
Location Capacity FeasureDescription RoomNo
Design North 810 S. Forest Mall 6 Normal CDN-60
976 S. Forest Mall 7 Normal COORL1-74
976 S. Forest Mall 6 Normal COOR170
300 E. Lemon St. 1 Multi-Media BA241
300 E. Lemon St. 4 Multi-Media BA365
13493 N. 47th Ave. 8 Multi-Media CLCC107
13493 N. 47th Ave. 5 Multi-Media CLCC238
850 S. McAllister Ave. 5 Multi-Media ISTB2175
400 E. Lemon St. 2 Normal BAC116
1050 S. Forest Mall 2 Normal ED216
Name Address Birthday StudentID Gender Department College
James S01 M IEE Eng
Margaret S02 F ACC Bus
Robert S03 M ACC Bus
Karen S04 F IEE Eng
William S05 M STP Sci
Dorothy S06 F STP Sci
Richard S07 M CEE Eng
Sandra S08 F CEE Eng
Thomas S09 M IEE Eng
Ashley S10 F ECN Bus
Christopher S11 M ECN Bus
Kimberly S12 F STP Sci
Matthew S13 M ACC Bus
Donna S14 F IEE Eng
Donald S15 M CEE Eng
Michelle S16 F CEE Eng
Paul S17 M IEE Eng
Amanda S18 F IEE Eng
George S19 M ECN Bus
Melissa S20 F STP Sci
Curry S21 M CEE Eng
Emily S22 F CEE Eng
SELECT Period.Days, Period.StartTime, Period.EndTime, Instructor.Name FROM Period INNER JOIN (Instructor INNER JOIN (Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) ON Instructor.InstructorID = Course.InstructorID) ON Period.PeriodNo = Assign.PeriodNo WHERE (((Instructor.Name)=[Enter a professor's name]));
SELECT Course.CourseNo, Period.Days, Period.StartTime, Period.EndTime, Student.StudentID FROM Student INNER JOIN (Period INNER JOIN ((Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) INNER JOIN Register ON Course.CourseNo = Register.CourseNo) ON Period.PeriodNo = Assign.PeriodNo) ON Student.StudentID = Register.StudentID WHERE (((Student.StudentID)=[Please enter students ID]));
SELECT Period.Days, Period.StartTime, Period.EndTime, Course.CourseTitle FROM Period INNER JOIN (Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) ON Period.PeriodNo = Assign.PeriodNo WHERE (((Course.CourseTitle)=[Please enter course name]));
SELECT Register.CourseNo, Count(Register.StudentID) AS [Total Register# of Students], Room.RoomNo, Room.Capacity, Room.FeasureDescription FROM Room INNER JOIN ((Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) INNER JOIN Register ON Course.CourseNo = Register.CourseNo) ON Room.RoomNo = Assign.RoomNo GROUP BY Register.CourseNo, Room.RoomNo, Room.Capacity, Room.FeasureDescription ORDER BY Count(Register.StudentID);
SELECT Course.CourseNo, Course.CourseTitle, Course.NewOffer FROM Course WHERE (((Course.NewOffer)=Yes));
SELECT Course.CourseNo, Period.Days, Period.StartTime, Period.EndTime, Instructor.Department, Course.CoureLevel FROM Period INNER JOIN (Instructor INNER JOIN (Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) ON Instructor.InstructorID = Course.InstructorID) ON Period.PeriodNo = Assign.PeriodNo WHERE (((Instructor.Department)=[Please enter department name]) AND ((Course.CoureLevel)=[Please enter course level]));
SELECT Room.RoomNo, Period.PeriodNo, Period.Days, Period.StartTime, Period.EndTime FROM Room, Period GROUP BY Room.RoomNo, Period.PeriodNo, Period.Days, Period.StartTime, Period.EndTime, Period.Assigned HAVING (((Period.Assigned)=No)) ORDER BY Period.Days;

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018