The project is to convert some Excel worksheets loaded with data into an Access database with interface screens and some reports.
1. Clarify requirements as necessary
2. Create suitable database structure based on suggested design in the attached database outline
3. Create user interface screens to enter new data and view existing data
4. Create reports as described in the attached outline
5. Implement basic user security
The project involves around 12-15 Excel worksheets with up to 800 rows to be converted in an Access database with around 6-8 tables, 10-12 user screens and 3 reports.
The database would be expected to use Access 2003 or a newer version running on Windows XP and Windows 7.
Thanks for your interest.