Professional Access Programmers - building and fixing databases.
We remotely support Access databases in Tulsa and throughout the country. We hold shared view sessions to discuss and document database needs, then work against this scope of work to satisfy our clients. These are Access Databases the require advanced knowledge of Access, VBA programming and best practices.
Here are some clients we have helped in Harrisonburg
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