Access Database Consultants, Programmers
and Developers
- Web Enabling Access
- Migrating Access To Cloud
- Migrating Access to the Web
- Access and Excel Visual Basic for Applications (VBA) programming
BUILD
ACCESS DATABASE
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
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
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.
Virginia Beach Fire Department
For the Virginia Beach Fire department, we consulted and built a professional Microsoft Access truck inventory database. This database tracks the inventory on a fire truck, what is supposed to be on a fire truck, reports exceptions, and tracks inventory in the fire station.
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
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.
Burnstone Computer Services
Subcontract to build Access databases for associations and retirement home management: Masons of Virginia. This Access database keeps track of the membership for the Virginia Masons. It provides invoicing functions and tracks the current positions of each Mason within their lodges.
PROGRAM
ACCESS DATABASE
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.
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)
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.
Harris, Williams & Co contacted us to build a portfolio management database. They wanted expert Access Consultants to work for them. We built a professional Access Database application that match their clients' desired needs to their portfolio of companies for sale.
WestRock
Build Access database for Fortune 500 paper and packaging company. Database manages 1 Billion of Inventory
Advanced Communications
Advanced Communication Equipment
American Disabled Veteran Telecom (ADV) was founded in 2000 to serve the North American Telecom Service Provider industry. Our company specializes in the sale of new and quality refurbished telecommunication equipment. We carry a wide selection of products from the leading OEM’s.
Our trained technicians and staff provide a broad range of services which include De-Installation, Asset Recovery, Installation, and Test and Repair.
ADV contacted us to support their legacy Access .adp / SQL Server database. They required an exper consultant in Microsoft Access to continue making changes to this backbone Access database while upgrading the Access database to Office 365
https://advcommequip.com/
Maisonettes Apartments
Maisonnettes Apartments runs an apartment complex and a trailer park. We upgraded their previous DOS based monthly rent collection application into an Access Database. Now all functionality of tracking tenants monthly rent is handled in Access. This database also provide the lease agreements and tracks historical tenants (tenants that have previously lived at the property)
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.
PepsiCo Worldwide Flavours
Built Access Database for Concentrate portion of Bottling Business. This Access database is used for tracking productivity of resources within the manufacturing / bottling facility. We modified a previous Access database built for the Pepsi Pennsylvania plant and imported raw data from Excel.
UPGRADE
ACCESS DATABASE
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.
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.
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.
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.
Masonomics
Microsoft Access Database for a commercial mason that sends text messages, connects to SQL Server web database for mobile web pages, and retrieves Timberline project information for project resource scheduling.
This is one of the most complex Access Databases we've built considering the number of integrations with other systems.
Bravo Wine Imports
Bravo Wines is an importer from Harrisonburg, Virginia. They asked us to modify their Access database which integrates with Quickbooks
Bravo Imports Wine mostly from Italy and sells, through agents, to restaurants and markets including Kroger. This database application provides both a web page for entering orders as well as Quickbooks integration for creating invoices from those orders and updating current inventory and product lists. This is accomplished through an ODBC connection directly to Quickbooks.
Agents and Items are managed through the Access database which communicates with the Website via MySQL connection (attached tables in the Access database). When Agents place orders, those order are viewed in the Access database, massaged and approved. Again through the use of attached MySQL tables.
We provided the Microsoft Access help for this project
From their website:
"Wine is one of the most civilized things in the world and one of the most natural things of the world that has been brought to the greatest perfection, and it offers a greater range for enjoyment and appreciation than, possibly, any other purely sensory thing." Ernest Hemingway
Blue Ridge Operations
Blue Ridge Products, an internet storeplace to purchase products, hired us to perform FTP integration with Access 2013. Blue Ridge creates orders and FTPs those orders to various warehouses including Amazon's warehouses to further process those orders.
Blue Ridge is an import company in Richmond, Virginia that creates their own products, has them produced in China, imports those products to the United States and sells (mostly) through Amazon.
This Access database is the central backbone for the company. It details all of the products, sales of those products, forecasts of the product sales, tracks current inventor levels etc.
In addition to integrating with FTP software, this database has complex integration with Excel, both importing/massaging excel files as well as producing Excel files for both the company's internal personnel as well as the various warehouses used by the company.
We provided the Microsoft Access training and documentation
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.