Client & Commission Access Database
Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted42 minutes ago
I need a simple MS Access (.accdb) solution that lets me keep every client’s contact details (name, phone, email, address, etc.), account details (client ID, status, notes, etc.), and their commission history (date, rate, amount, payment status, etc.) in one place. Every commission amount will be entered manually; no percentage calculations or tier rules are required.
Inside the database I want easy-to-use forms for data entry plus the ability to search, filter, and sort on almost every field. When I’m ready to share information I should be able to pick which fields appear, preview the result, and either print it directly or save it as a PDF. A single combined client-and-commission report that totals the relevant amounts automatically is the primary output I’ll use day to day.
Deliverables:
• An Access file with tables, relationships, queries, forms, and a pre-built report that meets the requirements above.
• Any VBA or macro code required for automated totals, field selection, and one-click export to PDF.
• A brief README so I know where to add or edit fields in the future.
If you have questions about structure, naming conventions, or future scalability, let me know— suggestions are welcome, otherwise I’m ready to get started.
Inside the database I want easy-to-use forms for data entry plus the ability to search, filter, and sort on almost every field. When I’m ready to share information I should be able to pick which fields appear, preview the result, and either print it directly or save it as a PDF. A single combined client-and-commission report that totals the relevant amounts automatically is the primary output I’ll use day to day.
Deliverables:
• An Access file with tables, relationships, queries, forms, and a pre-built report that meets the requirements above.
• Any VBA or macro code required for automated totals, field selection, and one-click export to PDF.
• A brief README so I know where to add or edit fields in the future.
If you have questions about structure, naming conventions, or future scalability, let me know— suggestions are welcome, otherwise I’m ready to get started.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.