Home Page     Contact Dave Thompson Consulting    Site Map

Microsoft® Access Programming and Consulting Services

 

 

Dave Thompson

Dave Thompson Consulting Home Page

Contact Information

Professional Services

Typical Application

Project Experience by Industry (See also: Project Examples)

Air Crew Duty Log. Track crew duty data of flight crew for FAA compliance and payroll tracking.

Commercial Real Estate. Import, clean-up, and build custom mail list with individualized comparison data. Dynamically build and execute SQL for comparison analysis of properties.

Communications. Circuit information and status database for communications center of national credit reporting agency (multi-user).

Employee Review Process. Annual employee review process with passwords and upstream supervisor access.

Home Building and Related Services - Corporate Tax Planning.   Using financial algorithms from old software, and report examples, develop a true rendition in MS Access with relational model and currency data types for accuracy.

Numbers shown as thousands, and rounding algorithm with VBA code procedures provide consolidated reports that can be reconciled with individual company reports. Increased functionality over legacy software to support multi-user and enhanced ad hoc reporting. 

Corporate structure is groups and companies. Reporting is available for individual companies and groups. Additionally, reports can be assembled by combining companies (either within a group or across groups) and printing ad hoc group reports for analysis. At the top level, groups can be selected to print consolidated reports, or any combination of companies can be selected to form an ad hoc, top level consolidated report.

Hotel Industry. Various group/department level multi-user applications for promotions and customer relationship tracking.

Legal. Client information, multi-user database for class action law firm. Access secure workgroup logon with users in several states updating (online) backend Access database in Dallas . A complex application with an extended development effort with most enhancements slip-streamed after the software was in daily use.

Management Consulting. Multi-part performance/goals questionnaire for management consulting firm. Project tracking software for consulting firm in joint development with major airline.

Manufacturers Rep Firm. Monthly commission reporting for multiple rep groups representing manufacturers' lines across multiple retail locations with commission structure by location. Import POS sales data from delimited, text source files.

Medical/Healthcare. Prescription lookup, print, and log file capture for E/R use. Provider (M.D.) credentialing program for medical industry consulting firm.

Quote Program for Electronics Company. Multi-user, quote program to assemble quotes from standard  products, outside purchase, and services. Allow setting of quote margins and present internal-use analysis of quote by line item. Print/export customer copy of quote. Maintain quote history.

 

Related Experience

Education