Access Database Experts. We follow commonly accepted practices for database and VBA (Visual Basic for Applications) development. We employ naming conventions on our database objects. Upon request we will also emply naming conventions on field names. We limit the use of queries to be essential objects that are helpful in the query window. We place SQL Statements mostly in Form/Report record sources and drop down row sources. We make every effort to make forms single table based and rely on drop downs to bring in information from other tables (or dlookups) and subforms for entire tables of related information. We use Office automation regularly to connect access to Excel, Word, Outlook, Quickbooks and other programs. We have connected many databases to ERP and web databases such as MySQL, SQL Server, JD Edwards, SAP, Timberline and more. We support mission critical databases. Our clients rely on the day-to-day operations of their Access databases. And they retain us to be available on an as needed basis. Examples of these database include Ferrara Candy's Operation Equipment Effectiveness database, Pepsi Bottling's Plant Tracking System, The Naval Observatory's Inventory database, Isometric (Vendor the the US Army)'s equipment part inventory and use and future demand database, Sequoia Tax' client list database, Dekra Consulting's back office account, audit and certification management database, ADV's order processing and inventory database.
Here are some clients we have helped: