Sales and Orders Access Database

I need an Access database to auto generate a unique ID to manage projects and orders. The database should specifically track projects by category assigning a three-letter prefix then two-digit year and auto number for tracking purposes. Supporting data will be input manually.

Requirements:
- A user-friendly interface for manual data entry
- Ability to generate sales reports
- Secure access controls
- Backup and recovery options

Ideal skills and experience:
- Proficiency in Microsoft Access
- Experience in database design and implementation
- Strong understanding of data security measures
- Ability to create intuitive user interfaces

Please provide examples of similar work done and your approach to this project.