What are you looking for?

"I’m pleased to recommend Jack Jaeger after being a client of his firm and working with him over the past several years. Jack has always taken a special interest in understanding our technology requirements and our project needs, and he always ensured we receive excellent service and quick responses. Jack’s team of technical and experienced designers was always a pleasure to work with and his personnel provided great supplemental support to our users who sometimes had special requests to meet their own local needs. I look forward to opportunities to work with Jack in the future."

- Caren Ambrose-Allen, Pepsi

Microsoft Access Richmond provided by Data Control, LLC
Microsoft Access Programming in Richmond, Virginia

Fixing Databases:

Sure, we fix other people's databases all of the time. For instance, we've recently done that for the following clients:

  • New World Pasta, St. Louis
  • Richmond Redevelopment and Housing Authority (VA State Government) (Subcontracted through SyCom Technologies)
  • Republic Services Corporation (Fortune 500)
  • Circuit City (Fortune 500) (Subcontracted Sapphire Technologies)
  • And more.  Give us a call and we'll discuss with you.


What you should be looking for in a developer if you want to fix your database:

1 - Can the developer look at my database and quickly ascertain what's going on?  That is, is the database normallized, are naming conventions enforced?  Was the database created by someone new to Access?

2 - Can the developer help me make the strategic decision to A) Add onto current database, B) Fix data structure and live with the rest of the database and make desired changes, or C) Scrap the database and build a new one.

3 - Will the developer provide me a free, fixed price quote detailing what is to be done on a line item basis to help me make my decision easier?

4 - Can the developer earn my trust so I feel comfortable that they know what they're doing, will come in on budget and on time, and make me look good?


Adding Features:

Yes, we add features to other people's existing databases (and our own!)

We've done this recently for:

  • Circuit City (Fortune 500) (Subcontracted UDIG Technologies) - different project than one listed above!
  • Apex Systems, Inc. (Interacting with Accounting system)
  • Pepsi Bottling Group (adding DB2 connection)
  • Give us a call and we'll discuss with you.

What you should be looking for in a developer if you want to add features:

1 - Does the developer understand how my current stuff works so that when adding a feature, the old stuff doesn't break?

2 - Does the developer advise me on pros/cons of a variety of features?  They should keep me in the decision making loop.

3 - Do I feel comfortable that the developer will consider my changes a priority among their other projects.  And do they have the know-how to get the job done?


Excel to Access Conversions

We've got great experience doing this!  And have we done some doosies!

  • Pepsi Bottling Group (Fortune 500) - Major Success Story!
  • GenWorth Financial (Fortune 500)
  • Colonial Mechanical

Look for the following in a developer that converts spreadsheets to databases:

1 - Thorough understanding of spreadsheets and what their good for.  You don't want to turn Access into a spreadsheet application!

2 - If your spreadsheet heavily uses pivot tables, then your developer better have a great knowledge of A) Crosstab Queries, B) Building reports on the fly for Crosstab Queries, C) Creating and Automating SQL statement actions queries (built on the fly in code)

3 - If your spreadsheet has charts (and what great spreadsheet doesn't!), your developer needs to know how to recreate (or import!) those charts into the database.

4 - Make sure you feel comfortable that the developer is giving you professional guidance on WHY database functionality will improve your spreadsheet application.


Connecting MS Access to data sources:

Wow, we've seen a bunch of these!  Here are some of the clients we've done this for:

CCA Financial (Oracle connection) (Subcontracted through Core Consulting)

Who We Are | Our Process | Our Blog | Clients | Partners | Documentation & Training
Ask a Question | Web, SQL | .NET, PHP, SQL Server | Contact Us

Data Control - Access and Database DevelopmentData Blade - Website Development

About Data Control:

Microsoft Access Richmond provided by Data Control, LLC

Microsoft Access Programming in Richmond, Virginia, Microsoft Access Washington, DC Microsoft Access Raleigh-Durham, NC Microsoft Access Virginia Beach, VA Microsoft Access Baltimore, Maryland Microsoft Access Hampton Roads, VA Microsoft Access Chapel Hill, NC Microsoft Access Charlotte, NC Microsoft Access Charlottesville, VA

Data Control, LLC builds advanced Microsoft Access database applications for business clients in Richmond VA Area. Fifty percent of our applications are brand new databases for the client; the other 50% are changes to an existing database the client had before meeting Data Control, LLC.

We specialize in Microsoft Access in Richmond, which accounts for 90% of all of our projects. We also provide services in ASP (Active Server Pages—web applications), SQL Server, Excel and Word. These other software applications often tie into an Access database as well.

Data Control, LLC takes pride in tailoring each application to the customer's unique need. We have been fulfilling the Microsoft Access programming needs of 100+ clients in the Richmond community for five years. Our Process for Microsoft Access Programming in Richmond. The majority of our business for Microsoft Access in Richmond is project-based development. Our projects range in size from five-hour patch jobs to 1,000 hour Web/SQL Server-integrated solutions. 90% of our development is performed off-site: that is, we develop in our offices and send you the results for review. Your time is usually spent meeting with us initially to describe your needs, meeting with us once again during implementation of the rough draft, and then a final meeting for production rollout. We strive to provide the best client communication in the industry.Data Control, LLC, Service Plans for Microsoft Access in Richmond. Each individual proposal agreement for a project includes 12 months of free support. This includes fixing (debugging) anything wrong with that application (anything covered in the scope of the agreement). We offer annual service agreements for continued debugging support and additional development. Full payment of the plan is due upon receipt of the signed plan agreement. A single plan may cover multiple databases.Contact Data Control, LLC, for Microsoft Access Richmond Services

Microsoft Access Richmond, Microsoft Access Washington, Microsoft Access Raleigh-Durham, Microsoft Access Virginia Beach, Microsoft Access Maryland, Microsoft Access Hampton Roads

Contact Jack Jaeger,Principal, at jjaeger@datacontrolllc.com or by telephone at 804.928.4111 for a quote for your Microsoft Access custom database in Richmond, Virginia.
Critical Web Databases .Net & PHP .Net, PHP, MySQL Programming

Web Databases .Net, PHP, & MySQL Baltimore MD Raleigh Durham Chapel Hill NC MS Excel Integration - Fixed Pricing Looking To Integrate Your Excel Forms? Excel Integration Looking For PHP or .Net Programming? PHP & .NET - Professional - Fixed Pricing Available Professional MS Access Database Development

Web Databases - .Net, PHP, SQL Server Turn Excel Into Fully Functional Forms Charlottesville VA Fredericksburg VA Richmond VA Integrate Your Excel Into Forms Microsoft Excel Integration Mission Critical Databases - .Net PHP SQL Server Wed Based Databases - .NET, PHP SQL Server

Need Excel Intregration? Professional Access Databases - Fixed Pricing Need MS Access Help? Richmond Virginia Baltimore Maryland Raleigh Durham North Carolina Professional Access Development Microsoft Access Database Development Professional PHP, . NET, and SQL Server Programming - Fixed Pricing PHP, .NET, & SQL Server Programming Web Applications - Professional - PHP .NET & SQL Server Excel Functional Applications Microsoft SQL Server MySQL Databases XML Technologies Database Script Library sql server 2005 yukon

ms sql 2000 script copy data from one database to another what is xml sql script Correctly Calculating Datetime Differences database tutorial arithmetic expression compute SQL Server 2005 cannot index some 2007 Office document formats SQL Server Rebuild indexes online with SQL Server 2005 Troubleshooting SQL Server 2005 CLR Problems SQL Server 2008 Troubleshooting SQL Server 2005 Bulk Copy Problems The 900 byte index limitation in SQL Server

Convert XLS,Convert Excel,Converter XLS,Converter Excel,Conversion XLS,Conversion Excel,Automate Excel,Automate XLS,Move Excel,Move XLS,Manipulate XLS,Manipulate Excel  How Do I take the contents of a CSV file and place it into a pre-formatted Excel (XLS) file?

Excel 5.0 Excel 7.0 Excel 95 BIFF7 Excel 8.0 Excel 97  Excel 9.0 Excel 2000 Excel 10.0 Excel XP Excel 11.0 Excel 2003 Microsoft  Excel Add In (*.XLA)  Comma Delimited (*.CSV)  Comma Delimited DOS (*.CSV) Comma Delimited Windows (*.CSV) dBase II (*.DBF) dBase III (*.DBF) dBase IV (*.DBF) Data Interchange Format (*.DIF)

Microsoft Excel 2.0 Worksheet (*.XLS)  Microsoft Excel 2.0 Worksheet Far East (*.XLS)  Microsoft Excel 3.0 Worksheet (*.XLS)  Microsoft Excel 4.0 Worksheet (*.XLS)  Microsoft Excel 4.0 Workbook (*.XLW) Microsoft Excel 5.0/95 Workbook (*.XLW)  Microsoft Excel 7.0/95 Workbook (*.XLW) Microsoft Excel 97-2000 & 5.0/95 Workbook (*.XLS)  Web Page (*.HTM, *.HTML)  SYLK  (Symbolik Link) (*.SLK) Template (*.XLT) Text Macintosh (*.TXT)

Text (MS-DOS) (*.TXT) Text Windows (*.TXT)  Unicode Text (*.TXT)  WK1 (1-2-3) *.WK1  WK1 All (1-2-3) *.WK1  WK1 FMT (1-2-3) *.WK1  WK3 (1-2-3) *.WK3  WK4 (1-2-3) *.WK4  WK3 FM3 (1-2-3) *.WK3WKS (1-2-3) *.WKS  Microsoft Excel Workbook (*.XLS)

Word File Conversion Formats As  Word Doc (*.DOC)  Dos  Text (*.TXT) Dos Text - Line Breaks (*.TXT) Encoded  Text (*.TXT)  HTML (*.HTM, *.HTML)  Rich Text Format (RTF)") Text  Text Line Breaks  Unicode Text Microsoft Office Word, Excel, PowerPoint, and OneNote on Windows Vista.

2007 SP1 2004 Service Microsoft Office Microsoft Office for Windows Office system Microsoft Word, Microsoft Excel, and Microsoft PowerPoint  Microsoft Access and Schedule Plus Microsoft Visual Basic for Applications scripting language Component Object Model add-ins Office 2007 for Windows XML-based Core Desktop Applications Word Excel Outlook/Entourage

Server Applications DOC .DOCX Office Open XML Microsoft Works  DOS operating Word 97-2004 Word 2007 Word 2008 .dot Word 97-2004 Template .dotx Word 2007/2008 XML Template Microsoft Excel Lotus 1-2-3 .xls Excel 97-2004 .xlsx Excel 2007/2008 Microsoft Outlook and Microsoft Entourage Outlook Express Windows Messaging Microsoft Mail Schedule+ (Plus) starting in Office 97  e-mail client, calendar, task manager and address book .msg, .pst Outlook 97-2007 Entourage 2004 .ppt PowerPoint 97-2004 pptx PowerPoint 2007/2008 .pot, .pps PowerPoint 97-2004 .ppsx PowerPoint 2007/2008

Food Processing Quality Safety Training/Tracking Database Application

Jack Jaeger
Principal, Data Control

Innsbrook Rotary
Richmond Chamber of Commerce
Henrico Business Council
Phi Kappa Psi Central - Virginia Alumni Chapter