These are just a few of the clients that have used our databases.
Contact us for more database information.
Here are some clients we have helped in
Chase M. Adkins, Jr. CPA
We built an Access Database for Chase Adkins. Chase Adkins is located in Sandston, Virginia. This organization primarily operates in the Certified Public Accountant business / industry within the Engineering, Accounting, Research, and Management Services sector. This organization has been operating for approximately 27 years. Chase Adkins employs 1 people at this single location.
Burgess & Co.
Fix Access database for accounting firm
Glave Firm, The
A NATIONALLY RECOGNIZED ARCHITECTURE, interior design, and planning firm, Glavé & Holmes Architecture was founded in 1965 in Richmond, Virginia. The firm of 60 architects, interior designers, historic preservationists, and supporting staff, maintains a diverse and integrated portfolio demonstrating expertise in numerous market areas, including Higher Education, Cultural, Civic, Hospitality, and Residential. Clients are provided with comprehensive services whether projects involve new buildings, additions to buildings, renovations, or adaptive reuse.
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.
Virginia Hospital & Healthcare Association
This is an Association Management database that manages the entire organization. Virginia Hospital & Healthcare Association is a group of Hospitals that lobbys the Virginia State Government. This Access database produces an online directory of members, keeps track of which members are in which House and Senate districts, emails the members and invoices the members.
Shaheen & Shaheen
Creating and modifying Access database for marketing purposes
Partner to build Access databases for their Communications client Verizon Wireless in Denver Colorado.
This is a land use management for Verizon, tracking all of the land the wireless company owns.
Blake Law Firm
Fixed and modified Access Database for matter tracking for a Chicago Illinois attorney firm. We also host this database on our server for them.
Clingman & Hanger
Build multiple access database for attorney firm. Firm specializes in bankruptcy management. This Richmond Virginia based attorney firm specializes on managing the bankruptcies of retail operations. The databases we built tracked the various claimants, their amounts, their claim types and more. We disbursed funds from this database.
Shaheen Law Group
Modifying existing Access database that performs document mangement for the firm.
build Web Application managing scheduling of attorneys, coordinating meetings
Build Web Application - Referral network
Allen, Allen, Allen & Allen
Fix Access Database for Personal Injury Attorney Firm
Sands Anderson Marks & Miller
Fixed Access database for attorney firm's real estate division tracking property permits
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.
Build Access database for scheduling Truck Body work
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
Dealer Auto Direct
Build Web application that managed inventory flow among multiple dealers
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.
Children's Health Involving Parents
Fix Access database for charity organization
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.
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.
Hercules Chemical - Franklin
Supported their Access Database. Chemical Manufacturer. We built a batch tracking application for them
Fix Access database for water purification company. About Chemtreat: Headquartered in Richmond, Virginia, ChemTreat is one of the largest and fastest growing industrial water treatment companies in North and South America. Since 1968 our entrepreneurial spirit and emphasis on hiring the very best field engineers have driven our success as we continue to find new ways to demonstrate value for our customers. Dedicated to industrial water treatment, we offer world class products and process improvement services focused on building long term satisfaction and commitment. We help our customers save millions of dollars every year, enabling us to achieve unparalleled growth in the water treatment industry.
Hercules Chemical Corporation
Building Access Database program to track and report batch processing efficiency
E.I. DuPont - Nashville Payment Center
Delivery of MS Project file including timeline. Delivery of Proposal for completion of project. Delivery of Data Description and Application Navigation Excel File.
CSG Store is a Verizon Product Reseller. They were challenged with tracking 1000s of invoices against a series of multiple payments by their clients (various verticals in the chain). We converted their spreadsheet nightmare into an Access Database. They can now process a month's worth of invoices in literally 5 minutes whereas the process was previously taking 3 mandays. This is the type of efficiency you can receive by using Microsoft Access.
From the CSG Store website: CSG Store At Connected Solutions Group, we have a simple belief that every wireless hardware deployment has a sensible and significantly more affordable solution just waiting to be unearthed. With nearly a dozen years of experience directly inside the downstream trade of wireless technology, our ownership prides itself on problem-solving, cost-effective, and innovative ways to bring your hardware application to life.
Other Access Solutions for Communications clients:Expert Access Solutions for Communications
Verizon Wireless - Rockies
Real Estate Purchase tracking for cell phone towers. This database was built specifically for the Rocky Mountain division of Verizon for operations in Colorado, Nevada, Utah and Wyoming We provided the Free Microsoft Access quote for this project for this project. We then did the Access development as well.
Modern Foundations builds commercial foundations
Radon Testing Labs
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.
Boone Homes, Inc.
Build access database for residential home builder: Warranty Management
Roofing Consulting Services
Commercial Roof Consulting Firm. The Company sends crews across the country to photograph and notate deficiencies in commercial roofs. That data is centrally collected, entered into the Access Database we support, and generates complex, 70 page .pdf file reports. The database gives the user the options to manipulate the sections of the reports prior to creating the .pdfs. We use VBA code to automate the .pdf file creation process.
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.
Advanous a division of Enterbridge
Fix Access Database
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.
Build Access database for CO2 distributor to track orders and delivery schedule
We worked with Maxient to develop processes within their Access database to extract relevant data for their clients.
Maxient is the software of choice for managing behavior records at colleges and universities across North America. Our centralized reporting and recordkeeping helps institutions connect the dots and prevent students from falling through the cracks
University of Virginia
The University of Virginia asked us to build an Access Database to track the training of it's employees. We consulted with them and considered one of our previous training tracking databases. We built them an Access Database from scratch. The University of Virginia is in Charlottesville, Virginia.
We built a certification tracking Access database application for Progress Energy to keep help them stay in compliance. This application tracks employee certifications for nuclear power training and alerts them when certifications will expire.
We've worked on similar certification tracking applications for other clients like ClementPappas (food and beverage) and International Marine and Industrial Applicators (Military Subcontractor). The IMIA application is a PHP MySQL Application and more information may be found here: PHP and MySQL Development
From Wikipedia: Progress Energy, headquartered in Raleigh, North Carolina, is a subsidiary of Duke Energy and prior to its merger with Duke Energy was a Fortune 500 energy company with more than 21,000 megawatts of generation capacity and $9 billion in annual revenues. Progress Energy includes two major electric utilities that serve approximately 3.1 million customers in the Carolinas and Florida.
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
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.
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
Internal Time and Expenses data input and reporting for managing a nationwide staff of consultants and projects, all in an Access Database. The back end of this database is in MySQL and housed on the Data Control servers. About API Services: We provide high value solutions to customers nation and worldwide. Our team of engineers and technicians are the best in the industry and continually provide the best customer service through commitment, knowledge and diversity. We offer a wide variety of other services such as: laser tracker rentals, machine tool calibration equipment, laser tracker calibrations and certifications for all tracker models. We proudly service the following industries: BIM, Aerospace, Marine, Shipbuilding, Energy, Automotive and Petro-chemical and many more!
Build Access Database for Environmental Engineer
Build Access database to track environmental impact of construction projects
Group Dynamics Entertainment
This Entertainment Company needed an Access Database developed for them as a back end to their Horse Racing Movie Product. We developed the Access Database and project managed the movie development that interacts with the Access Database.
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.
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
Capital One - Poseidon's Chariot, CapEx
Build Access database for Fortune 500 credit card company.
Capital One - MTR
Built Access database for Fortune 500 credit card company
Capital One - Art
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.
Capital One - Poseidon's Chariot
Build Access database for Fortune 500 credit card company. Annual Budgeting tool
Capital One - Plass
Build Access database for Fortune 500 credit card company
Capital One - CRE Finance
Build Access database for Fortune 500 credit card company
Capital Investment Funding, LLC
Build Access database. Banking software that manages CD expiration and interest costs
Capital One - JLL.
Build Access database for Fortune 500 credit card company. Real estate project management for west creek buildout
Capital One - IT PMO
Developed an Access database for Fortune 500 credit card company. This Access database collects department budget data from department heads across the company and consolidates that information for a master annual budget. Capital One is a financial corporation for which we have built 14 Access Databases
Capital One - CVA PM
Build Access database for Fortune 500 credit card company. Database tracks projects
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.
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.
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.
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.
The Pancake Man
Fix Access Database to run Pancake catering business outside of Milwaukee, WI. Heavy interaction with Microsoft Outlook including customized calendar events. Mail Merge letters accomplished through Access Reports. Complex Data entry logic. We provided the free Microsoft Access quote for this project and did the development as well.
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.
Williamson Medical Center
Williamson Medical Center needed to modify their existing Access Database. They needed an Access Guru to understand the complex nature of a database previously designed by an expert. This database tracks janitorial supplies and projects across this huge hospital.
From their website: Williamson Medical Center Williamson Medical Center has been a pillar of our region for over 60 years, with an impressive tradition and commitment to not only providing exceptional healthcare services to hundreds of thousands of patients, but also an overall dedication to the wellbeing of our community.
We also build expert PHP and MySQL web application solutions for the manufacturing industry. More information here: PHP and MySQL web application solutions for the health care industry
If you need your Access database converted to a web solution, we can do this as well. For example: we have built an Overall Equipment Effectiveness Access Databases and similar efficiency tracking databases for Pepsi Bottling and Clement Pappas. We have converted these applications for general use and more information is available here: Overall Equipment Effectiveness for the manufacturing industry
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
Mulit Interest Services Group
MISC is a company that services the Import / Export industry. They specialize in getting your goods into the United States and out of the United states. The Access Database we've built tracks the process of containers coming in and out of the country including invoicing, transportation, payments, warehousing, etc.
Affinity Group Underwriters
Fix Access Database for Insurance Company
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.
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.
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.
The Select Group
One of our former Capital One clients moved to a staffing firm in Raleigh, North Carolina. As Chief Financial Officer at this new firm, he re engaged us to build an Access Database to track Purchase Orders and Timesheet information. Ease of use and quickness in handling large amounts of imported Excel data into this Access database is key for this finance/accounting department to generate their monthly invoices while staying within the budgets if each individual purchase order. This Access database imports Excel Spreadsheets full of monthly time. This time is then applied to existing, budgeted Purchase Orders. As the budget limits of the Purchase Order is reached, the user is notified that the PO is in jeopardy of being exceeded. At that point, individual time records may be split (internal access functionality that reduces and appends) amongst additional Pos. Furthermore, this mission critical Access Database also has a series of reports that allow the users to see which Pos are in Jeopardy of expiring based on the average billings/day and the number of days left in the Purchase Order contract. Lastly this administrative Access database runs Excel Exports for creating the actual invoice that is sent to this staffing firm's clients.
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
4. Reports 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
Gateway Global Delivery
Gateway provides logistics services to their clients. The Access database we modified for them imports data files from FedEx. This data is then manipulated into complex invoices to send to Gateway's clients. This access database improves the efficiency of the overall organization. We were the Access database consultants for this project.
Build Access database for Fortune 500 paper and packaging company. Database manages 1 Billion of Inventory
We were subcontracted to Ryson through our network engineering strategic partner Network Technologies and Solutions (NTS). Ryson's Chief Operating officer had been slowly putting together and Access Database to replace a series of complex Excel files in order to manage the process of building conveyor belts. We took over the Access database, enforced naming conventions, developed easy to use navigation forms and maintenance tables. Now this conveyor manufacturer has a backbone database application that provides completion timeline information to the engineering departments, the manufacturing departments, the finance departments and the sales department. A calendar is created for everyone to see. Huge printouts showing all current projects and the people needed to sign off are printed out and put up throughout the facility. We hope to replace these with direct feeds to monitors.
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
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.
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
Commonwealth Center for Advanced Manufacturing
CCAM contacted us to convert their Excel Spreadsheet into an Access Database. They needed expert Access programmers for this task. Their spreadsheet was calculating the SPI Index for ongoing projects. But not working due to the complex nature of the calculation. A database was necessary and Microsoft Access was the perfect solution for converting this spreadsheet to a database.
From the CCAM Website: THE COMMONWEALTH CENTER FOR ADVANCED MANUFACTURING "CCAM" IS WHERE THE BEST OF INDUSTRY, ACADEMIA AND GOVERNMENT COME TOGETHER TO SOLVE ADVANCED MANUFACTURING CHALLENGES.
We also build expert PHP and MySQL web application solutions for the manufacturing industry. More information here: PHP and MySQL web application solutions for the manufacturing industry
We have also built Overall Equipment Effectiveness Access Databases and similar efficiency tracking databases for Pepsi Bottling and Clement Pappas. We have converted these applications for general use and more information is available here: Overall Equipment Effectiveness for the manufacturing industry
Simpson Strong-Tie Co. Inc.
Built New Batch process tracking Access database to manage the production and shipping of batches. Simpson Strong Tie is a Fortune 500 company that strategically uses Access Database to manage department activities
About Tredegar: Deeply rooted in manufacturing, Tredegar Corporation is a global operating company with industry-leading businesses in the plastic films and aluminum extrusions markets. We were engaged through one of our strategic partners to help Tredegar manage a special bonus functionality in the Human Resource department. We've built many commission and bonus related Access databases in a variety of firms including Fortune 500 Altria and more, so we were well positioned to referred to Tredegar for this Microsoft Access database consulting engagement. Tredegar has a Lotus 123 spreadsheet (yes! Lotus 123) for keeping track of retired employees and the distributions those employees choose to take out of their retirement. Tredegar asked us to convert this Lotus 123 Spreadsheet into an Access Database. The new Access 2013 database will replace the Lotus 123 spreadsheet functionality of managing and administrating this human resource function of retired employee distributions. We were the Microsoft Access Database consultants for this project
Tower Steel, Inc.
This Steel Manufacturer in Houston Texas needed a remote Access database programmer to build them an Access Database. They also host their data on our Servers.
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
Ritchie & Associates
Ritchie is a management consulting firm headquartered outside of Los Angeles, California. They consult with Fortune 500 firm Meadwestvaco (now WestRock). They advised the paper and packaging firm to build an historical demand based Access Database. It incorporated not only ERP (SAP) sourced historical demand, but also provided advanced logistic support to this Paper and packaging corporation.
This Access database determined optimim supply levels in plants and warehouses throughout the US including Maine, North Carolina, Ohio, California, Texas, Colorado, Washington, Oregon, and Michigan.
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
Access Database to track Employee Stock Distributions. Sycom's client, Tredegar Industries, needed to get out of a Lotus 123 Spreadsheet and into an Access database. We converted they're advanced Lotus Macros and now they create distributions, deposits, etc. for their stock plan with the new Access database. We were the Microsoft Access Database programmers for this project
Pepsi Bottling - Tulsa
Build Access database - Manufacturing Process Efficiency Tracker
Fix Access database for Aluminum products manufacturer. Database tracks orders and shipments. Second database request to fix quality management database.
Atlantic Constructors, Inc.
Build a Microsoft Access database in Chesterfield Virginia to determine pricing for this Mechanical Engineering firm. Developing this Pricing Access database was critical for their operations. About Atlantic Constructors, Inc: ACI works across the spectrum of business and industry, from busy production facilities, power plants, and the many factories in the Mid-Atlantic, to commercial and government buildings, universities, hospitals and specialized laboratories. Our customers know we can be counted on not just to get the job done, but to get it done right, safe and on-time.
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.
Fix Access database for determining hospital emergency room time differentials
At Home Care
Build Web Application to manage Doctor sign off process
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
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.
The Naval Research Laboratory in Waldorf, MD contacted us to build an inventory database. This Access Database handles the entire process of purchasing and inventorying all items on the base including all test equipment used at the Naval Research Laboratory. We all use hand scanner so complete physical inventories on base that stores/forwards information to the Access Database.
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.
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.
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)
Perry Partners, Inc
Build Microsoft Access Sales Contact Database with advanced search features for Real Estate Brokerage/Development firm in Denver Colorado
Access Database Consulting, Design, Development, Installation and Training for Property Management Application in Sacramento, CA. This Access Database runs the office for a property management company.
Sequoia Tax Relief
Sequoia Tax Relief is a collections agency in Denver, Colorado that specializes in Government Tax collections. They contacted us to modify their Access Databases
Prairie Land Services, Inc
Developed an Access Database for Car Repossesion Company in Wichita, Kansas. This database manages the back office expense entry and reporting for the various employees and subcontractors that work at Prairie Land. The employees weekly payroll is determined from this Access database.
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
Build Web Application to manage registrations
Apex Systems, Inc.
Build SQL Server database for staffing company
Virginia Community Policing Institute
Virginia Community Policing Institute provides training material to police organization across the United States. We worked with them to build and Access database that would track which individuals received what training. This database also reminds VCPI that training is about to expire for certain individuals.
Pack & Ride
Build Web Application to manage logistics of container delivery to clients