Access Database Consultants, Programmers
- VBA Programming
- Fixing Advanced Databases
- Migrating Access to Web
- Connecting Access to SQL Server and MySQL
Strategic Technology Systems
Adam Mears, owner of STS contacted me to build an Access database for his client, The Snead Company, a commercial window supplier to the commercial construction industry.
This Access database is web enabled with a SQL Server back end. Additionally it interacts with Sharepoint, providing light document management services. The Snead Company creates proposals for their clients using this Access database and then tracks the progress of those proposals to winning status (or dead status).
Strategic Technology Systems is a full service IT company that provides consulting and support to their clients that need hardware, networks, servers, etc. running smoothly for their companies.
Network Engineering Firm in Columbia, Maryland.
They subcontracted us to Fix an Access database for determining hospital emergency room time differentials for their client Bon Secours in Baltimore, MD.
This Access database was developed to track efficiency of the emergency room operation at Hospitals for Bon Secours. The various stages of a patient's visit are tracked and the minutes recorded for moving through each stage of the emergency room visit.
This database uses extensive Forms that have built to provide the quickest data entry possible for the user.
UpTime Solutions Professional Services Group
Network Engineering Firm in Richmond, Virginia.
This is a Quality tracking and improvement Access database for a manufacturing firm: Greystone in Toano, VA (near Westpoint and Williamsburg).
This application receives multiple excel files throughout the day that are produced from quality control machiney in the plant. The excel files are imported to the Access database automatically.
The Access database scrolls through the excel files, parsing out the relevant information from the excel file and appends the relevant data points to a table that is then used to run monthly and quarterly quality control reports.
The data is pertinent to the automobile manufacturing process and determines which production batches should or should not be accepted for Greystones automobile manufacturing clients.
We built this database through our strategic partner: Uptime Solutions, a premier network integration and engineering firm in Richmond, VA and Tampa, FL.
Networking Technologies and Support
Yorktown - This Access database for a conveyor manufacturing company tracks is a project management database with multiple dates for the completion of manufacturing and engineering tasks with advanced calendaring.
Strategic Technology Systems
An Access database with a SQL Server back end was already in place at CeMark, STS's client. We were asked to migrate the data file to a new version of SQL Server and modify the existing Access database with a bunch of punch list items.
ActivSupport contacted us to fix various Access, SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA.
Active Support needed an expert database consulting company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. By supplying professional database developers to ActivSupport and their clients, we kept both our partner and their client happy
B to B - DuPont
We were hired by BtoB, a SQL Server development and administration company to help their client: DuPont to provide administration support to their SQL Server Databases
The Chemical giant, DuPont, has a SQL Server farm that provides databases to the company's offices around the world.
We provided this service at the DuPont Chemical plant in Richmond, Virginia.
DuPont is a Fortune 500 Chemical Company headquartered in Wilmington, Delaware.
From their website: See what makes DuPont one of the most successful science and engineering companies in the world.
Our core values govern our internal business practices and partnerships, and guide our innovations.
Meet our Chair and CEO, board of directors, corporate executives, and regional and functional leaders.
Subcontract to build Access databases for their clients Fire Life Safety America (Mechanical Engineering), Henrico County public utilities, and Arcet Welding Supply & CO2 distributors in Richmond, VA
For Fire Life Safety America we modified a SQL Server database and an Access database for tracking sales commissions
For Henrico County Public Schools, we modified their Access database
For Arcet (now Arc3) we supported a CO2 distribution database that tracked routes for their people to maintain customer accounts
Subcontracted to build a web application/SQL Server database for their Military client: Camp Peary, Department of Defense, CIA training in Williamsburg, VA.
This database tracks the hazardous materials brought onto the military base, the current inventory levels of those hazardous materials, and the disposal of the hazardous materials.
The Access database produces the annual reports required by the Environmental Protection Agency including Form R and Tier I and Tier II reports.
We were the Microsoft Access Database consultants for this project
Partner to fix Access database for their Police Client: Tulelake Police Department, OR. We provided them with this quote:
1. Asp.net application that can be run from any computer using a web browser. this will be used on any and all PCs used by the department
2. 3 tables plus asp.net log in tables
a. Crime Report (currently 130 +/- fields)
b. Officers (currently 9 fields); add user name field from asp.net for correlation
c. State Abbreviations (currently 1 field)
3. Forms for data input
a. Log in to asp.net app
b. New user to asp.net app
c. Edit/Add officer to SQL database (there will be an association of New user to asp.net using user name from asp.net)
d. Edit/Add State Abbreviations to SQL database
e. Edit/Add Crime Report to SQL database
a. Crime Report
5. Search feature on Crime Report form
6. Record navigation feature on Crime Report
7. Print Button on Crime Report
8. Sync Button on log in to asp.net for - requires password
9. Sync new records to SQL Server Express
10. Update modified records to SQL Server Express
11. At present a sync from SQL Server Express to the asp.net application is not included
12. At present migrating old data from MS Access to SQL Server Express is not included
Old Dominion Controls, LLC
Old Dominion Controls: Over 25 years of serving the natural gas industries of Virginia and Tennessee. We provide instrumentation and control equipment from the wellhead to the end user in the natural gas world.
Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
Virginia Association for Home Care and Hospice
Fixed and modifed an exiting Access database for an Association. This client manages their client invoicing and payments with an Access Database. They desired to share the database from home and work, so we migrated the data tables to a MySQL database in the cloud (Data Control Servers)
Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.
Creating and modifying Access database for marketing purposes
PepsiCo Global Concentrate Solutions
In Atlanta, we are working with PepsiCo Global Concentrate Solutions to implement a Plant Picking database we built for Pepsi's Carlisle, PA plant. Pepsi Bottling approached us 20 years ago to build a Plant Efficiency tracking database that was rolled out nationwide. The other divisions within Pepsi then contacted and contracted us to build other professional Access database solutions.
Volcafe - TaylorWinch
Volcafe is a worldwide Coffee Manufacturer involved in Purchasing, Collection, Processing and Import/Export
Fix Access database. About American Mechanical: Our Virginia Beach climate is temperate for the most part, but it’s most enjoyed with the modern conveniences that we’ve become accustomed to, such as your heating and air conditioning, plumbing, and electrical systems. When either of these fail, you need fast and effective relief performed by professionals who actually know what they’re doing. American Mechanical is just that team.
Our staff is comprised of Master Licensed Contractors and NATE Certified technicians with decades and decades of combined experience in the industry. We’re the organized and efficient answer you’ve been looking for to install, repair, and maintain any of your home or business’s most important features of operation. Our Virginia Beach technicians can deliver these services same-day and on
Pepsi Bottling - Los Angeles
Trained Pepsi on an Access Database we built tracking plant efficiency. We worked in Los Angeles (Riverside plant) and also created a training manual for the plant.
Chase, Inc - HVAC
Build Access database to track heating/air conditioning clients and deliveries and installations. This is a Mechanical Engineering Firm in Chesterfield, Virginia (a suburb of Richmond, Virginia). About Chase HVAC: Mike Burton has been with Chase, Inc. in Richmond since 1982 and is the sole owner. Unlike many heating/air and plumbing companies, at Chase, you will not be treated like “just another customer.” Chase strives to keep its “Mom and Pop” reputation in Richmond over the years. If you’d like to speak directly with Mike when you call, it’s no problem. He is never too busy to speak with you. Otherwise, our office staff is more than glad to take your call and schedule an appointment to meet your heating/air and plumbing needs.
We appreciate your business and look forward to continuing to serve you and your family for many more years to come.
Precision measurement and tool calibration for manufacturing clients, we built an Access database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This application connects to SQL Server which is hosted on Data Control's Web Server.
This is a backoffice application that runs the expense side of a company with geographically dispersed employees. They track their billable time and expenses, assigning both to projects/clients.
Hospital Hospitality House
Developed Access database for charity hotel organization. This hotel management application interacts with both a Topaz Signature pad for capturing hotel guest signatures as well as Adobe Acrobat and for producing .pdf files.
Nufarm Americas Inc.
NuFarm is a pesticide chemical manufacturer based in Australia. They're office in Raleigh North Carolina initially engaged us to build an Access Database to track Environmentl Protection Agency (EPA) forms. They have over 2,000 EPA forms on file with the US Government.
Upon further conversation and discovering the intent of this chemical/pesticide client, we decided that an Access Database WAS NOT the proper solution.
They desired people AROUND THE WORLD to enter and query their application. So we built this database using PHP web pages and a SQL Server data file. You may find more information about this application at www.data-blade.com
From their website: We know that growing is about more than just crops and cultivation. It's about sunshine and rain, early mornings and hard work. It can be frustratingly unpredictable, but also wonderfully uplifting. More than anything, it's about people.
Nufarm is the dependable partner behind thousands of agricultural success stories. Every day, growers around the world turn to our products and our people to help with the challenges of fighting disease, weeds and pests, and to increase crop yields.
Distributor of Vibration Analysis equipment to manufacturing firms. Access database connects to outlook to schedule training and equipment deliveries for that training. Connects to Navision to retrieve customer and contact information.
This Access database also integrates heavily with Microsoft Outlook, providing both calendaring and email functionality
VibraAlign is in Richmond VA and has clients across the country including Texas, California, Utah, Colorado, New York, Florida and Illinois.
DEKRA Certification, Inc.
DEKRA Consulting is a Germany based company. Their Phildelphia office uses an Access Database as the backbone of their USA practice. It tracks clients, consultants, and the status of consulting project/engagements.
We took their back end Access tables and converted them to MySQL tables. We then migrated the data from the current Access database to the MySQL tables.
Now DEKRA's employees may easily use the database across the country and the world.
We provided a free Microsoft Access quote for this project and then did the work
We did this work for the DEKRA office in Philadelphia, PA.
From the Dekra Website (https://www.dekra-consulting.com/en/process-optimisation): We have a proven track record improving quality, business performance, people skills, workflows and processes of our global clients. Today our team serves a variety of industrial clients, but the core of our expertise was built in the role of preferred partner to the global automotive industry. Our strong international presence, industry expertise and close ties with the automotive trade result in high recognition amongst manufacturers, importers, dealers, independent repairer chains, suppliers and automotive service providers.
We built France Environmental and Access database for importing leads from Peachtree And Outlook to generate sales/marketing emails that come from the Access Database and Integrate with Outlook.
We developed and programmed this Access database to manages the environmental compliance training classes that France Environmental offers their clients.
We've built Outlook import processes for both inbox and contacts. We've also built email functionality with attachments from within the Access Database.
France Environmental is an Environmental Engineering Firm in Chesterfield, Virgiia. From their website: France Environmental, Inc. (FEI) is a small minority owned/operated company based in Richmond, Virginia staffed by personnel that have worked in the Asbestos and Lead-based Paint industries for many years. Asbestos and lead-based paint consulting services are the main focus of our business. Our clients include Federal, State, and Local Government agencies as well as private industrial, commercial, and residential entities. FEI offers a direct response and service at a reasonable price compared to many larger firms due to our low overhead expenses and simple management structure. Our employees provide a level of quality that is above the typical industry standard.
Manufacturing Firm in Toano, Virginia.
We built a Quality tracking database that imports 1000s text files output from manufacturing machinery.
This microsoft access database reports defects during the manufacturing process for this automotive parts manufacturer
From Greystone website: Greystone is a global leader in the production of high volume precision machined and plated components for the automotive, aerospace, defense and industrial markets. Specializing in safety critical machining, hard chrome plating, and anodizing, we take pride in developing innovative engineering solutions to difficult problems.
HORWITZ, RICHARDSON & BAKER, LLC
Chicago Law Firm that used an Access database to manage their cases. We migrated their Access tables to MySQL tables in the cloud: Our Server.
Routt County Alcohol Council
The Council contacted us to upgrade their Access 97 database to the current version of Access. We have to first move the database into Access 2003, and then into Access 2019 (365). The was further complicated due to a workgroup information file protecting the Access 97 database and then advanced vba code that needed modification.
We are frustrated that Microsoft does not provide a transparent upgrade path from Access 97 directly to Access 365 (or whatever current version of Access is out today). We are further frustrated that Access discontinues support of features such as workgroup information files, pivot tables/report, Access Data Projects. So clients are forced to contact consultants like Data Control. We realize the importance of your database and the dilemma you are in. So we try to fairly price the upgrade to the new version of Access hoping that we can get future development work from you.
To get around the Workgroup Information File issue (the client had no documentation of this which is understandable considering the database is 20 years old and the original developer long gone), we opened a new Access 2003 database and imported all of the objects. This then allowed us to open the Access 2003 database in Access 2007 and perform the final upgrade steps.
This particular database uses advanced VBA code and expected the data file to be in a particular position on the server. If the data file wasn't there, the reports didn't work. So we searched through the code removing this requirement. We also had to modify a few of the libraries
Routt County Alcohol Board is a non-profit serving the city of Steam Boat in Colorado. Their database is a case management and reporting vehicle for their operations.
This Access Database application also integrates with a barcode scanner and the FedEx software for creating shipping labels.
Selma Cookies is an Orlando Cookie Manufacturing whose largest client is Disney Corporation.
Selma found us on the internet about 10 years ago. We've been modifying and supporting her Access database since then.
This is a customer order management database that helps Selma keep track and fulfill Yahoo orders.
This database imports from Excel derived spreadsheets that are produced by Yahoo and stages these orders to fulfillment and shipping.
From Selma's website:In 1990, Selma Sayin began as a passionate baker
whose secret recipes warmed the hearts and satisfied
the sweet tooth of friends, clients and family.