download ( Enrollment.accdb ) file from the link below :…

1- Open and save the Access database on your machine

2- Create the Relationships between the tables.


Using the Access Query design option, run all the following 7 queries (questions 3 to 9):

Save the queries as Query(

(Example: Query3 for question 3 below).


For queries 4,5 and 8 use comparison operators (research online if necessary): <, >, =, >=, <= in the criteria

Use the Sort attribute in query design for question 7

Use the Totals feature in the Show/Hide block in the query design view for question 6.

3- Output the names of all students taking Biology.

4- Output all Student_Ids whose Advisor_ID is not 3.

5- Output the names of all students whose ID is more than 3000.

6- Show the number of courses in the Course table.

7- Show the names of all courses in the Course table sorted by the Course name.

8- Output the names of all students whose ID is in between 3700 and 4000.

9- Show the names of all students whose advisor is Jones.

Forms and Reports

10- Create a Student form

11- Add 6 new student entries using the Student form and populate all the fields (including the State and Zip) in the form for the new students and the existing students.

12- Go to the datasheet view of the Student_Course and Student_Advisor table and add 2-3 entries in both these tables for the new students (Do not add new courses or advisors, use existing ones only). Populate the scores field in the Student_Course table as well (make up some scores).

13- Create two sub-forms to show the Course and Advisor information for each student on the Student form.

14- Create a report to show the individual scores obtained by each student in each course they took. The student_id and name should not be repeated with the scores. Show in the report the average score for each student (use the Report layout view) at the end of each student record and the average for all students at the bottom of the report.

15- Save the database and upload it. Make sure Access is not open when you upload it.

Looking for solution of this Assignment?


We deliver quality original papers

Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay