The database StudentData.mdb (located in the email sent and in Canvas/Files) is maintained by the University Registrar. There is one table (table name = Students) in the database…

Database Management, Active Data Objects (ADO.NET), DataGridView Control, Structured Query Language (SQL), VB Form 

The database StudentData.mdb (located in the email sent and in Canvas/Files) is maintained by the University Registrar. There is one table (table name = Students) in the database that contains student information such as first name, last name, number of classes and major. Develop a Visual BASIC Forms App that will connect to the database using Active Data Objects (ADO), load the table data into a DataGridView control and allow the app user to change/update records, search, sort, and filter for full time students.

1. Load the data from the StudentData database to a DataGridView control allowing a user to make edits within the DataGridView control.
2. Provide the ability to sort last names in ascending and descending order
3. Display in a DataGridView control students who are taking 4 or more classes
4. Display in a DataGridView control student names that were searched by Last Name
5. Provide the ability, for record changes made in the DataDridView control, to be saved back to the StudentData database

---