Hi! Im really sorry but im new to Access and have been going through the forum to try and figure out how to create a database to solve our problem, but to no avail. I hope this is the right place to put my question.
We are facing the following problem:
The warehouse manager is in charge of checking the validity of "screens" (which are filled forms with details of the person being screened). Every morning he has to look at each form one by one, see the postcode of the person on the form and ensure that the postcode belongs to a region that can be accepted by the company. If it belongs to a region acceptable he then matches the address on the form by checking for the address of the post-code via the royal mail site. If the address matches the one on the form, then the form is considered valid. When it is valid, he adds a tally to valid screens for the day by region. If it does not belong to a region which can be accepted or the address does not match, it is considered invalid, he then makes a tally to the number of invalid screens, and has to write a reason for it being invalid (while postcode is the primary issue, sometimes its possible the form doesnt belong to the age group which is being targetted). Once he has completed this entire process for all the forms, he compiles his tally marks to see the number of valid and invalid screens by region (along with their reason for invalidity)
We are looking to create a validity-checker database that will function as follows:
- The program will prompt him to enter a postcode
- On entering the postcode it will check that the postcode belongs to a region in the database
- If it does not belong to a region then it will display the message "Invalid postcode" and add to the tally of invalids
- If it is acceptable it will run the royal mail website to display the address to him
- The form will then ask him if the form is valid or invalid
- If he clicks valid, it will automatically tally the postcode under the respective region. It will also keep a monthly tally to which it adds onto
- If he clicks invalid it will prompt for a reason why (text entry), following which it will tally it under invalids
- It will give him the option to say "Compile report"
The 'Compile report' function will tally all the valids and invalids and present the tally. The presentation of the report would look something like this:
------------------------------------------------------------------------------------------------
Validity - check report
<date>
<Region name 1>:
Valid screens: X
Total valid screens for the month (till date):X
Invalid screens: X
Total invalid screens for the month (till date): X
Reasons for invalid:
1. <postcode> <reason>
2. <postcode> <reason>
3. <postcode> <reason>
<Region name 2>:
Valid screens: X
Total valid screens for the month (till date):X
Invalid screens: X
Total invalid screens for the month (till date): X
Reasons for invalid:
1. <postcode> <reason>
2. <postcode> <reason>
3. <postcode> <reason>
<Region name X>:
Valid screens: X
Total valid screens for the month (till date):X
Invalid screens: X
Total invalid screens for the month (till date): X
Reasons for invalid:
1. <postcode> <reason>
2. <postcode> <reason>
3. <postcode> <reason>
------------------------------------------------------------------------------------------------
Do you'll think it is possible to create such a program in Access?? If so, I'd really appreciate any help/guidance that you'll could give me in creating it.
Thanks!