Adjusting and extending an existing Access Database
$30-250 USD
Completato
Pubblicato quasi 11 anni fa
$30-250 USD
Pagato al completamento
Dear Community,
I am currently working on an Access Database. I am quite far advanced with my work but need some help to finish my work, especially in VBA programming.
Its a database where various data sheets were imported as templates and and a quality check has to be performed on the entered data. After that it is possible to export the data in xls and csv for further processing.
What I've builld so far: Import tool, export tool, various forms, various queries, all templates are imported
What I need:
- Adjustments of the code of some forms
- Build up a quality check of imported tables (e.g. a column must consists of 5 numbers, check if the ID already exists in the database)
- The Access DB was build in Access 2003. The code has to be checked if it is ready for Access 2010 (if applicable)
- Create VBA that makes automatic backups of the database once a day in a defined folder.
- Create Mass import function of XLS files of a predefined folder
- Check and extend relationships between tables and forms.
For advanced persons with good VBA knowledge I think this task will consume ABOUT 5-7 HOURS OF WORK. The database is already set up and a lot of work was done so I just need you to get it finished :-)
Thanks for your support!
In addition, if the quality of the work is good I would like to ask you for further support after this project on an hourly basis.
Cheers Mat
Hi Mat, I have 12 years experience developing MS Access applications using VBA and feel confident that I could do this project for you. Please view my portfolio for some examples of my work. Kevin.
$250 USD in 5 giorni
4,9 (23 valutazioni)
5,5
5,5
9 freelance hanno fatto un'offerta media di $263 USD
I will bring very strong VBA skills to bear on your project plus over 19 years of technical programming experience.
I am available to begin immediately should you elect to award the bid to me.