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.

    We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting
  • Harris, Williams & Co.
    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.

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
    The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
  • Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
    Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database