I have an Excel Spreadsheet of data and I have a group of auditors I need to validate data on the spreadsheet. I want to load the Excel Spreadsheet into the database and make each data point something the auditor will need to check each item as accurate or inaccurate.
There is a mixture of numbers, names, addresses, dollar figures and auditors and a category.
Loan Number Data Point 1 Name Data Point 2 Address Data Point 3 Address Data Point 4 Dollar Figure Data Point 5 Date Data Point 6 Date Data Point 7 Dollar Data Point 8 Dollar Data Point 9 Name Data Point 10 Name Data Point 11 Dollar Data Point 12 Date Data Point 13 Dollar Data Point 14 Name Data Point 15 Date Assigned to? Name Category Numeric and Alpha
I need each auditor to be able to access the Database and select loans assigned to them if possible as well as the category. They will work the loans and record their results for each data point by verifying accurate or in accurate. I prefer check boxes for each data point over drop down boxes. Several people will be using the database at one time. There should be a small notes section. 250 characters should be enough. After they work an account they can hit next and the next loan will appear to work.
I will need to be able to pull a report to show results and outstanding items.
Make sense?
Bookmarks