do this in microsoft access

add screenshots in answer

microsoft access required

After successfully completing this assignment, you will be able to: Join tables to include information only found on specific tables Display all records from one table, each joined to a record from another table, if related Create parameterized queries that can be reused Summarize/count records containing a specific characteristic This is a group assignment comprising groups of students. Please enroll into the groups and submit a single database to the Assignments folder for evaluation. Submissions should include a Word document indicating the work done by each group member. Group members will be automatically assigned if not enrolled by noon of the next day assignments are released. No changes to group membership will be made once assigned. Total: 35 marks The Student Database stores class data for all courses in AcSiT and related data for students and instructors. Download the database Student.accdb and populate its tables: Add at least 5 records to the Instructor table. [1 mark] Add at least 10 records to the Class table. [1 mark] Add at least 10 records to the Student table. [1 mark] Ensure that there are multiple classes enrolled by some students. [2 marks] Ensure that there are multiple students enrolled in classes. [2 marks] Ensure that some instructors teach multiple classes [2 marks] Ensure that some instructors are not assigned to a class. im 1 mark) Develop the following queries. All queries should sort the data in a meaningful order. 1. A query listing all classes taught by each instructor a show the Instructorld, FirstName, LastName, EducationLevel, Position, Name, Section, StartDate. [3 marks b. Format the StartDate as dd mmmyyy, for example: 23 Jan 2022 [3 marks] Sort the records by StartDate in descending order. [1 mark] 2. A query listing all instructors who are not assigned to a class. a. Show the FirstName, LastName, EducationLevel, Position [2 marks] b. Sort by FirstName, LastName in ascending order [1 mark! 3. A query counting the number of students per class a for each class display the Classid, Name, Section, StartDate, and count of students. [3 marks) b. Include classes without assigned students, specifically showing a count of 0 (zero) for these. [3 marks) 4. A query of all activities for a given student. 2. At run time, the user is to enter the following parameters: The StudentNo [3 marks) b. Filter the records for the specified studentno. (2 marks] PROGIR25 - ASSIGNMENT 1: COURSE INFORMATION QUERIES Show the StudentNo, Student Name. Program, Class Name, Section, StartDate (formatted 23 Jan 2022), Instructor First and LastName [3 marks] d. Sort the results by Start Date in ascending order. [1 mark]