Can someone help me conceptualize what Im trying to do here? Our organization keeps track (for grant funding purposes) of statistical information. In this particular instance we track the number of telephone calls we receive requesting assistance that we are unable to provide. These calls need to be tracked by the following: date of call, callers sex and county of origin (one of five), which agency(s) the caller was referred to (22 different possibilities) and what services the caller requested. This information is compiled at the end of each quarter, grouped by month and totaled by number of callers per sex per each county and by the total number of calls to any particular referral agency (can be one of 22).
This is currently being tracked on a large Excel spreadsheet. The receptionist completes information by hand on a tracking sheet and I am expected to compile and enter the data on the spreadsheet each month. At the end of the quarter, results are totaled and the spreadsheet is forwarded to the requesting grant provider.
I would like to set this up in a little Access database so the receptionist could enter the information (once) on a pop-up form. At the end of the quarter, I want to be able to produce a report that provides the same results weve been getting by using the spreadsheet. Initially, this seemed pretty simple until I realized that each call could be referred to as few as none or as many as 22 different agencies! (Typically, callers are referred to an average of 2-3 different agencies.) Am I trying to reinvent the wheel or would I be better off continuing to do what we are doing with the Excel spreadsheet?
Please keep in mind that I am not a programmer and my skills with Access 2000 are intermediate, at best.
Thanks!
This is currently being tracked on a large Excel spreadsheet. The receptionist completes information by hand on a tracking sheet and I am expected to compile and enter the data on the spreadsheet each month. At the end of the quarter, results are totaled and the spreadsheet is forwarded to the requesting grant provider.
I would like to set this up in a little Access database so the receptionist could enter the information (once) on a pop-up form. At the end of the quarter, I want to be able to produce a report that provides the same results weve been getting by using the spreadsheet. Initially, this seemed pretty simple until I realized that each call could be referred to as few as none or as many as 22 different agencies! (Typically, callers are referred to an average of 2-3 different agencies.) Am I trying to reinvent the wheel or would I be better off continuing to do what we are doing with the Excel spreadsheet?
Please keep in mind that I am not a programmer and my skills with Access 2000 are intermediate, at best.
Thanks!