Urgent

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.