Modify an Access Database Application to eliminate the bugs.
The application already exists but the following modifications are required:
1. We need to change the nocontact column in v_volunteer to a numeric field. In the volunteer entry form, currently it is a check box, this needs to be changed to a drop down having the following information - Contact Allowed, Do Not Contact, Address Changed. Based on what is selected, numbers 0,1or 2 should be stored in this field, with 0 (Contact Allowed) being the default.
2. There exists a main database and a second database. I need a small script to go through all the records in second database, and find a corresponding entry in first database. If an entry is not found, then that record must be copied from the second database to the first database but the nocontact field should be changed to 2
3. In the scheduler report, the shift selection should be multi-select option.