mitch s.

Access/VBA developer

For the past 20+ years, I have been developing MS Access applications with all versions of Access (starting with the '95 version). I specialize in Access, and do not split my time on other disciplines (such as websites). During my 10+ years on Upwork (and elance and oDesk), I've successfully completed 80+ projects, totaling more than 1900 hours (1300+ hours on 'hourly' jobs & 600+ hrs on fixed-price jobs). 33% of these projects have been with repeat clients. Because of this experience, I have accumulated a toolbox of forms, queries, functions & subroutines that I can re-use on new applications. This enables me to keep the client costs down when developing new, or enhancing existing, applications. I have a job success rate of upwards of 90%, which is clearly reflected in my verbal & numeric feedback. I offer the following types of services: 1. Create turnkey database applications using MS Access (conceptualization, design, development & deployment). 2. Design normalized database structures. 3. Convert Excel-based applications to Access. 4a. Convert dBase & Lotus Approach applications to Access. 4b. Convert ADP projects to accdb databases 4c. Convert legacy mdb databases to accdb 5. Use Access VBA to import data from, and export to, Excel, CSV, text files & other Access DBs 6. Use Access VBA to automate creation of documents with MS Word mail merge & templates. 7. Deploy applications to the Cloud (via Citrix & Sharepoint). 8. Create documentation: System Manuals and User Manuals. 9. Deploy applications to tablet computers. 10. Create macros in Excel, Word & Outlook to automate various actions 11. Use VBA to control the contents and printing of labels to DYMO printers. 12. Use VBA Automation to control Excel, Word & Outlook. 13. Use Zebra label Designer software to connect to Access database & automate printout of labels. 14. Specialize in cracking legacy applications whose life has expired, and which are passworded. This includes applications based on Access and Word.