Simple Access Database for Currency Exchange Business
Budget: $10 – $30 AUD
I am looking for a freelancer to develop a mini database system in Microsoft Access to manage a small foreign currency exchange business. The system should be simple, efficient, and user-friendly, focusing on accurate recordkeeping, powerful search, and easy reporting.
Core Requirements:
Customer Database & Transaction Ledger
• Maintain a customer database with transaction history.
• Record all currency exchange operations clearly for auditing and business analysis.
On-Screen Search & Filtering (Highest Priority)
• Provide powerful, and intuitive search and filtering options.
• Users should be able to easily find transactions, customers, or summaries on-screen.
Receipts & Reports (Mandatory)
• Generate receipts for customers after each transaction.
• Provide fully printable reports, including:
• Daily transaction reports
• Customer statements
• Summary reports
Multiuser Access
• Support at least 3 users to start.
• Include access control with different user permissions.
Currency Exchange Calculator
• Allow cashier to manually input and update exchange rates.
• Automatically calculate exchanged amounts based on the input rates and currency values.
Demonstration/Guidance
• A walkthrough showing how to use the system effectively.
Deliverables:
• Microsoft Access database system meeting all requirements.
• Printable receipts and reports built into the system.
• User-friendly interface for cashiers and admins.
• Basic user guide or demonstration.
Core Requirements:
Customer Database & Transaction Ledger
• Maintain a customer database with transaction history.
• Record all currency exchange operations clearly for auditing and business analysis.
On-Screen Search & Filtering (Highest Priority)
• Provide powerful, and intuitive search and filtering options.
• Users should be able to easily find transactions, customers, or summaries on-screen.
Receipts & Reports (Mandatory)
• Generate receipts for customers after each transaction.
• Provide fully printable reports, including:
• Daily transaction reports
• Customer statements
• Summary reports
Multiuser Access
• Support at least 3 users to start.
• Include access control with different user permissions.
Currency Exchange Calculator
• Allow cashier to manually input and update exchange rates.
• Automatically calculate exchanged amounts based on the input rates and currency values.
Demonstration/Guidance
• A walkthrough showing how to use the system effectively.
Deliverables:
• Microsoft Access database system meeting all requirements.
• Printable receipts and reports built into the system.
• User-friendly interface for cashiers and admins.
• Basic user guide or demonstration.