Access Database Consultants, Programmers
and Developers
- Migrate Access to Sharepoint Solution
- Upsize Access to SQL Server
- Upsize Access to MySQL
- Migrate Access to the Web
BUILD
ACCESS DATABASE
WSI Web Strategies
Subcontract build Access & Web applications to Pack & Ride and Vatex and a Soccer Association. We subcontracted to WSI Web Strategies to help their clients. Both are in Richmond, Virginia
Food and Drug Administration
Dynamics Edge had a contract to Train the Food and Drug Administration. When they had an Advanced Access Class to train, they called us as Expert Access Consultants to perform the training in Silver Spring, MD
B to B Solutions
Partner / Subcontract to build Access, SQL Server, .NET applications for their clients: Chemical Engineering client DuPont, their staffing client Apex Systems, Their health industry client Result Performance, and their insurance client Affinity Group Underwriters in Richmond, VA
ACSG
Subcontractor to Build Access Database for tracking contract information for their Military client: Air Force Bases in Washington DC. ACSG is a Federal Prime Vendor and they went after a military contract that desired Access databases to manage contracts for the military bases in DC. This Access database we developed was identical but rolled out separately to manage the contracts that each Air Force base currently had in existence.
Networking Technologies and Solutions
Network Engineers in Richmond, Virginia. NTS has subcontracted us many times to build Access & SQL server databases to the Virginia Lottery, the Virginia Beach Fire Department, Townes Engineering, EHS Laboratories and more.
For the Lottery, we've built machine maintenance tracking databases and number tracking databases (historical record of the numbers that won)
For the Virginia Beach Fire department, we built a Microsoft Access truck inventory database.
For Townes Engineering, we modified their website
For EHS Laboratories we also modified their website
MatlenSilver Group ltd.
MatlenSilver Group, Inc subcontracted us to their Fortune 500 Tobacco /Food Manufacturing Philip Morris (now Altria) for Manufacturing Training Tracking in Richond, VA.
The Matlen Silver Group, Inc. provides information technology (IT) staffing services.
Altria desired to track which employees had what training in their plants and what certifications were going to expire. This Access database tracked that information and provided reports to help schedule future training of employees
Convergent Business Solutions LLC
Convergent is a consulting firm in Richmond, Virginia. We partnered to build an Access database for their Retirement Home client: Virginia Baptist Homes, a retirement community.
We modified this existing Access database for the IT manager of VA Baptist Homes. The database receives daily text files from the retirement home's phone systems (6 geographic retirement home locations). The 6 text files are imported, staged, scrubbed and processed into consolidated, individual invoices for the members of the retirement community. The receive monthly bills for the phone calls they make / receive.
We provided the Microsoft Access Database expertise for this project
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.
Values:
Our core values govern our internal business practices and partnerships, and guide our innovations.
Leadership:
Meet our Chair and CEO, board of directors, corporate executives, and regional and functional leaders.
URS Corporation
URS, a Fortune 500 Consulting Firm, contacted us to build an Access database for their client: United States Marine Corps: Camp Lejeune.
This Access Database tracks hunting on the Camp grounds through: Hunter Information Screen, License Screen, Violation Screen, and a Rank Maintenance screen. A Record of Sales Report can also be generated. Camp LeJeune is in North Carolina and is a Department of Defense, Military, Marine Corps
URS is a prime vendor to the Federal Government and the Military Branches. This Access database helped this US Marine Corps base successfuly manage the land use of the base.
AVB Solutions
We were subcontracted to build Access database for their healthcare client: Veteran's Hospital in Richmond, VA. This Access database helped hospitals run their operations as was rolled out to a consortium of healthcare operations in Virginia, Maryland, and DC.
PROGRAM
ACCESS DATABASE
Dominion Partners
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.
Holiday Signs
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.
Build Access database for Fortune 500 credit card company. Database tracks artwork throughout company. About Capital One: We are a Top 10 U.S. bank, with the strength and stability to meet the needs of your business. Our Commercial Banking group services a $65 billion loan portfolio and more than 6,100 clients. Let us show you the difference our partnership and proven experience can make.
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.
Shaheen & Shaheen
Creating and modifying Access database for marketing purposes
Capital One - MTR
Built Access database for Fortune 500 credit card company
American Mechanical
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
Carmax
Built a legal matter tracking database for this Fortune 500 company with headquarters in Richmond, VA but locations all across the nation including Orlando, FL
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.
UPGRADE
ACCESS DATABASE
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.
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.
Values:
Our core values govern our internal business practices and partnerships, and guide our innovations.
Leadership:
Meet our Chair and CEO, board of directors, corporate executives, and regional and functional leaders.
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.
VibrAlign
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.
API Services
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.
France Environmental
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.
Greystone
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.
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.
Selma's Cookies
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.