Desktop Applications

Order Processing from Online Stores


PencilPartners.com needed a way for employees in different states to view and enter orders from their online store. Microsoft Access is the perfect solution.

  • Orders placed on the web site are pulled into the application automatically — no time wasting and error prone re-keying.
  • Phone and Purchase Orders are entered directly into the application. If a customer calls with a question, each employee has instant access to the information.
  • Orders are exported to QuickBooks on demand, again, avoiding re-keying and errors.
  • Invoices, quotes, and receipts are generated at the press of a button. They can also be emailed to the customer just as easily.
  • Every employee has fast desktop access to all aspects of the application.

This image shows a sample order processing form.

This image shows the product entry page. Prices are automatically shown based on quantity discounts.

This image shows the Invoice generated by pressing a single button. You can't get much easier than that!

This image shows the form for reporting on orders or generating sales reports by customer, product, or month. The reports can be filtered on virtually any criteria, for instance, to see how a single product has sold each month for the last 3 years, or to find all the orders that have not been paid.

This image shows the Ribbon Bar for navigating through forms. This makes it easy to find exactly what you need.


Integrated Credit Card Processing

Charge credit cards directly from your application. Credit cards can be processed through any Merchant Service Provider, and the responses can be stored directly in QuickBooks. Credit cards are encrypted using industry-standard 128-bit encryption for security.


Collect Measurements via Serial port

ASK Chemical, a filter manufactuer, needed a way to collect size and weight measurements from scales, calipers, rulers, or via user input. While few businesses need to read devices through serial ports, this application shows that Microsoft Access Pros can handle any request. And, Microsoft Access is perfect for storing the thousands of measurements collected for each part.