Develop MS Access database
- or -
Post a project like this5028
$$
- Posted:
- Proposals: 11
- Remote
- #26847
- Awarded
Web Developer, Web Designer, Mobile Optimisation, Graphic Designer, Email Marketing
Brisbane
MS Access/MS SQL/MS Excel/App Developer/DataBase Developer/Programer/Database Admin
Port-of-Spain
2833853488599047195976222768734050052266738517740277527
Description
Experience Level: Intermediate
To build the frame work for an Access database so that we can input info regarding licenses that we hold on behalf of our clients. We need to be able to interrogate the data and obtain reports based on a verity of instances. E.G: -
â�’¢ Live licenses, i.e. ones that we are currently holding.
â�’¢ Historical licenses, i.e. ones we have held in the past and now transferred.
â�’¢ Live licenses by bill cycle i.e. monthly Quarterly.
â�’¢ Sites that require visits/next visit due
â�’¢ Filter high, med, low risk sites
â�’¢ From the fee information, it will say who is due an invoice that month and how much it should be i.e. £200 for holding licence, £100 for providing DPS, 1 site visit £300 this month = £600. (If it were possible for the system to then turn the selected items into an invoice for printing then that would be even better!)
â�’¢ The ability to attach/link documents, (mainly pdfâ��s) associated with the corresponding licence.
â�’¢ A â��notesâ�� box for free text
â�’¢ The ability to print a template letter to the local authority when we have consented to transfer the licence.
I'm sure that to an expert this job is should be fairly basic but I would not have a clue where to star, hence putting it out to tender.
â�’¢ Live licenses, i.e. ones that we are currently holding.
â�’¢ Historical licenses, i.e. ones we have held in the past and now transferred.
â�’¢ Live licenses by bill cycle i.e. monthly Quarterly.
â�’¢ Sites that require visits/next visit due
â�’¢ Filter high, med, low risk sites
â�’¢ From the fee information, it will say who is due an invoice that month and how much it should be i.e. £200 for holding licence, £100 for providing DPS, 1 site visit £300 this month = £600. (If it were possible for the system to then turn the selected items into an invoice for printing then that would be even better!)
â�’¢ The ability to attach/link documents, (mainly pdfâ��s) associated with the corresponding licence.
â�’¢ A â��notesâ�� box for free text
â�’¢ The ability to print a template letter to the local authority when we have consented to transfer the licence.
I'm sure that to an expert this job is should be fairly basic but I would not have a clue where to star, hence putting it out to tender.
LSS Group
93% (16)Projects Completed
20
Freelancers worked with
18
Projects awarded
39%
Last project
10 May 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies