Microsoft® Access Programming and Consulting Services
Dave Thompson
Dave Thompson Consulting408 Rose Drive
Allen, TX 75002
(Dallas - Ft. Worth Metroplex)
Contact Information
Voice: 972-727-5670 (days & evenings)
Email: davethompsonconsulting@msn.com
Internet: http://www.dave2001.com
Professional Services
Access programming (VBA – Visual Basic for Applications, DAO/ADO – dataset manipulation)
Database design
End-to-end Access database projects (define, design, program, implement)
MS Word automation projects - MS Access data sent to Word (mail merge, form letters)
Programming for fixes/modifications of existing Access applications
Self-help instruction
Data conversion and loading into Access MDB
Supporting these versions of Microsoft Access: Access 97, Access 2000, Access XP (2002), Access 2003
Typical Application
Multi-user, small workgroup (2-20 users) on a local area network with Access secure workgroup (user logon with password) implemented as split application (front-end/backend) model. Typical number of data records per table from 100 to 100,000+.
Project Experience by Industry
Air Crew Duty Log. Track crew duty data of flight crew for FAA compliance and payroll tracking.
Banking/Financial. Rewrite legacy program for desktops for private placements section of large bank. Client information system for financial planning firm.
Commercial Real Estate. Comparison analysis of business property appraisals. Search county-wide database of properties using expanding, dynamic SQL search algorithm, to generate comparison records both for analysis and as source for direct marketing process (build merge table for bulk merge to Word).
Communications. Circuit information and status database for communications center of national credit reporting agency. Extensive use of drill-down techniques to access underlying data for individual data records. Multiple navigation choices implemented to locate desired records for display or update. Time-stamped log files supported for record history keeping and issue resolution tracking.
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. Application is a multi-user implementation. 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.
Employee Review Process. Annual employee review process with passwords and upstream supervisor access.
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, multi-user 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.
Manufacturing. Multi-user, quote preparation, pricing, and printing application for electronics manufacturing company. Quote items are picked by classification from an inventory of several thousand parts. The program supports both sub-assembly pricing (pull top-level part and program prices all component parts) and miscellaneous installation/assembly parts (pull part program prices any related miscellaneous installation parts).
Manufacturers Rep Organization. Import monthly POS (point-of-sale) UPC (Uniform Product Code) line item sales by location. Compute monthly commissions for individual rep groups covering 2,000+ retail locations with a commission structure based on location and manufacturer's line. Maintain a sales history file for data analysis.
Medical/Healthcare
Related Experience
Authored five chapters for the book, Access 97 Programming Unleashed (SAMS Publishing) – Three chapters on VBA (Visual Basic for Applications) and two chapters on ActiveX controls for Access.
Previous PC industry experience: VAR for Informix ISQL (Unix and PC DOS), software development with IBM BASIC (BASCOM), Microsoft QuickBASIC and PDS (Professional Development System) BASIC.
Professional experience in telecommunications and manufacturing businesses.
Education
Georgia Tech (Atlanta, GA) – Bachelors in Engineering
UCLA (Los Angeles, CA) - Masters in Engineering
University of Dallas (Irving, TX) - MBA
Dave Thompson Consulting Home Page
Member number:5959
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2000 Dave Thompson and Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257