- 1- Open and save the Access database on your machine
- 2- Create the Relationships between the tables.
Queries:
Using the Access Query design option, run all the following 7 queries (questions 3 to 9):
Save the queries as Query(q.no.).
(Example: Query3 for question 3 below).
Hint:
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
- Create a Student form
- 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.
- 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).
- Create two sub-forms to show the Course and Advisor information for each student on the Student form.
Looking for solution of this Assignment?
WHY CHOOSE US?
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 |