DBM 380 Week 4 Learning Team: SR-ht-003: Change Request 4 and 5

Continue working on Service Request SR-ht-003, due in Week Five, by completing Change Requests 4 and 5.

Change Request #4:

Create an input form in Access for each of the tables in your database. Your form should allow you to create, read, update, and delete data for the table. You need not worry about fancy design for these – the output of the Forms wizard will do the trick here – just make sure that each form can do all four of the above operations (create, read, update, delete).

Change Request #5:

Create 5 queries for your database. At least two of the queries should join two or more tables together. At least three of the queries should filter the rows (excluding these from the results) from one or more of the tables used in the query. These two requirements (joins and filtering) need not be satisfied by separate sets of queries – a single query could potentially count toward both requirements. Try to pick queries that seem useful or business relevant – none of your queries should be just a simple SELECT of all the columns and rows in a table.

Click the Assignment Files tab to submit your assignment. (All you will be submitting is your Access database with the additions described above.)

Here is the rubric I will use for this assignment: