I have been a professional Access developer since 1996. I'm skilled in all aspects of Access development, including relational design, forms, queries, and VBA. I will make an effort to understand your needs and deliver precisely what is requested, or more. Let's make a connection. Note - I am not a fan of social media, so you will not find me on FB or LinkedIn.
Read More »
Sep 30, 2015|Database Administration|$344|Completed
Sep 30, 2015|Database Administration|$0|Completed
Aug 13, 2015|Database Development|$504|Completed
View All »
Aug 12, 2015|Database Administration|$150|Working
This is a functional specification I created for Phase 2 of a project at a large...
A simple Access VBA function to determine whether an Excel pathname can be opened, and...
A firm wanted to know how many Access databases they had (over a thousand, it turned...
These are form / report samples from a system to allow a nonprofit to track donations....
Microsoft Access Programming
Microsoft Access Administration
SHAMBHALA MEDITATION CENTER Brookline MA
2013 - 2014
Adapted Access database to use Quickbooks extracts rather than bank ACH records as source of donation transactions. Added a donations detail page to the 501c(3) annual letter. (Access 2007 &...
SHECHEN TENNYI DARGYELING
2013 - 2013
Advised on moving monastic sponsorship donations / mailing Access database to a cloud based solution.
(Access 2003, DonorPerfect).
SHAMBHALA MEDITATION CENTER
2012 - 2013
Adapted Access database for tracking donations to a nonprofit to a new bank / ACH record format and new accounting procedures. Redesigned 501c(3) annual donations acknowledgement letter....
CITYWIDE FRIENDS OF THE BOSTON PUBLIC LIBRARY
2012 - 2013
Analyzed computer resources and systems of nonprofit group, researched / recommended upgrades. Provided advice on moving member database from Access database to a cloud based membership...
2011 - 2012
Analyzed and enhanced an existing Contract Management database for Caremark MinuteClinic, a national network of walk-in clinics. The existing (incomplete) database was designed to support a...
2011 - 2011
Assessed a 75 user Access application used to manage corporate Internal Audit projects over a WAN (Wide Area Network). (Windows XP, Access 2007, VBA)
SUN LIFE FINANCIAL
2010 - 2011
Developed prototype for automating monthly financial close reporting for division with $1.6 billion annual revenue and $393 billion business in force. The original system comprised 17 Access...
ST JUDE MEDICAL
2010 - 2010
Migrated a large (400 table, 75 form, 8000 lines of code) Access- based Manufacturing Resource Planning (MRP) system from a design using a Great Plains MRP back end to one based on SAP MRP...
2010 - 2010
Analyzed migration of corporate usersí MS Office 2003 files in Windows XP to MS Office 2007 / Windows 7. Determined that conversion of most files to Office 2007 format was unnecessary. Assessed...
BANK OF AMERICA
2009 - 2009
Oversaw two corporate auditing applications (Access/SQL Server) while their creator was on vacation. Enhanced the Access front end; wrote stored procedures for SQL Server back end. (Windows XP;...
FISH & RICHARDSON
2008 - 2009
Enhanced/maintained billing system for law firmís European office. Worked with Access forms and reports, maintained SQL Server back end. Shifted logic from Access/VBA to T-SQL stored procedures...
HARVARD SCHOOL OF PUBLIC HEALTH
2001 - 2008
Developed and enhanced over 7 years a system to identify candidates for cancer studies. The system acted as a conduit for candidates' medical records between local hospitals and research study...
PUBLIC SECTOR PARTNERS
2006 - 2007
Member of team that developed & maintained Access/Excel applications for paying monthly premium subsidies for 60,000 Massachusetts participants in Medicare Plan D. The system calculated payments...