The project is based on Database design. We have to Find a problem and basically work on the problem. A template is attached for better understanding.
In this project we have to:
1. System analysis and problem formulation- Problem Definition [200 to 300 words], Scope
2. Client Requirements- Background of the problem, Detailed requirements list, Possible Solutions
3. Database Design- Selected Solution, Entity Relationship Diagrams, Design of data Validation rules, Field types well chosen and explained, Test Plans
4. Implementation- Creation of tables, Creation and use of forms for data entry, Creation and display of reports, Use of macros, Creation of switchboard, Use of Pivot Table and charts for reporting
5. Testing- Implementation of Test Plan, Screen shots of forms, report and all modules
6. Evaluation of Complete System- System Evaluation, Future Enhancements, Skills Acquired
I have done it partly, although I am not sure if the idea is good enough. You can change and have your own idea as well if you wish to. On completion of project I would also require the Access document along with the Completed Word document Template attached.