Relational database with MS Access.
Assignment:
Create a list that holds the student grade (A, A-, B+, ...), modify the appropriate table to accept only the grades in the list (you need to explain why you selected the above table record to the student grade).
- The name of each Object should start with Week6.
- Create a form that will update the student grade
- Create a query using "List of values Match" using the "In" operator
- Create a query using "Not Logical operator" using the "Not In" operator
- Create a form with 2 buttons to run the above 2 queries
Attachment:- Database14INFO261_WK5 (1).accdb