Partnering with Data Control
We've been partnering with professionals for 15 years.
Why do these folks partner with us to help their clients?
- Their client needs a professional Access database built or fixed
- They want to be a resource to their client
- They don't want their competition supplying a resource to their client
- We respect their client relationship
- We don't discuss pricing with their client
- We suggest a 25 - 50% margin on our services
- But most of all, they trust us
How partnering works:
- You ask us to conference call with your client to begin discovering the work necessary.
- We provide you a scope of work to accomplish the project. We provide you our price and we suggest your price to the client
- You get client approval and decide if you want to subcontract us or refer us
- We keep you in the loop during development
- If we are subcontracted, we send you monthly invoices to forward to the client on your letterhead
- If you referred us, we send you monthly find fee checks
About half of our business comes from strategic partners. We work with Network Engineering firms like ActivSupport (New York), Bear Technologies (Portland, OR), Fisk Information Technology (Pittsburgh), SyCom Technologies, and many more. We’ve also worked through Federal Contractors like ASCG, Goodwill, and MatlenSilver. Another group of folks partnering/subcontracting us is management consultants like Ritchie Consulting.
How does partnership work with us? Well first of all you should know that we take your client relationship very seriously and professionally. We will bring you into all conversations and protect your client relationship. We will work as transparently as you like, or you might hand a client off to us because you don’t wish to be a middle man and we’ll take great care of them for you (and take care of you as well!)
Here are some partners we have worked with in the past:
|Commonwealth Computer Training
||Commonwealth Computer Training has referred us and subcontracted us to a number of their clients including the French Insurance Giant: Allianz. We have provided Access database development and mentorship.
From Commonwealth's website: Commonwealth Computer Training (CCT) opened in 2001 as the technology training division of Commonwealth Personnel Consultants, Inc., Patricia W. Haynes, a Certified Personnel Consultant, co-founded Commonwealth Personnel Consultants in 1985. It is one of the first female owned and operated recruiting firms in the Richmond, Virginia area. CCT is a SWAM certified business.
Commonwealth Computer Training
|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
||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.
|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
|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.
|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.
||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.
|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
|Strategic Technology Systems
||An Access database with a SQL Server back end was already in place at CeMark, STS's client. We were asked to migrate the data file to a new version of SQL Server and modify the existing Access database with a bunch of punch list items.
|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
||Subcontract to build Access databases for their clients Fire Life Safety America (Mechanical Engineering), Henrico County public utilities, and Arcet Welding Supply & CO2 distributors in Richmond, VA
For Fire Life Safety America we modified a SQL Server database and an Access database for tracking sales commissions
For Henrico County Public Schools, we modified their Access database
For Arcet (now Arc3) we supported a CO2 distribution database that tracked routes for their people to maintain customer accounts
||Subcontracted to build a web application/SQL Server database for their Military client: Camp Peary, Department of Defense, CIA training in Williamsburg, VA.
This database tracks the hazardous materials brought onto the military base, the current inventory levels of those hazardous materials, and the disposal of the hazardous materials.
The Access database produces the annual reports required by the Environmental Protection Agency including Form R and Tier I and Tier II reports.
We were the Microsoft Access Database consultants for this project
||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.
|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.
|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
|B to B - DuPont
||We were hired by BtoB, a SQL Server development and administration company to help their client: DuPont to provide administration support to their SQL Server Databases
The Chemical giant, DuPont, has a SQL Server farm that provides databases to the company's offices around the world.
We provided this service at the DuPont Chemical plant in Richmond, Virginia.
DuPont is a Fortune 500 Chemical Company headquartered in Wilmington, Delaware.
From their website: See what makes DuPont one of the most successful science and engineering companies in the world.
Our core values govern our internal business practices and partnerships, and guide our innovations.
Meet our Chair and CEO, board of directors, corporate executives, and regional and functional leaders.
||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 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.
|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
||New York, NY
||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
||Jacksonville, North Carolina
||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.
||Klamath Falls, OR
||Partner to fix Access database for their Police Client: Tulelake Police Department, OR. We provided them with this quote:
1. Asp.net application that can be run from any computer using a web browser. this will be used on any and all PCs used by the department
2. 3 tables plus asp.net log in tables
a. Crime Report (currently 130 +/- fields)
b. Officers (currently 9 fields); add user name field from asp.net for correlation
c. State Abbreviations (currently 1 field)
3. Forms for data input
a. Log in to asp.net app
b. New user to asp.net app
c. Edit/Add officer to SQL database (there will be an association of New user to asp.net using user name from asp.net)
d. Edit/Add State Abbreviations to SQL database
e. Edit/Add Crime Report to SQL database
a. Crime Report
5. Search feature on Crime Report form
6. Record navigation feature on Crime Report
7. Print Button on Crime Report
8. Sync Button on log in to asp.net for - requires password
9. Sync new records to SQL Server Express
10. Update modified records to SQL Server Express
11. At present a sync from SQL Server Express to the asp.net application is not included
12. At present migrating old data from MS Access to SQL Server Express is not included
||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