What kind of desktop applications?

We routinely develop desktop applications ranging from small single-user app to medium or large apps with tens to possible hundreds of users concurrently addressing the same database.

The project size and needs dictates the choise of the programming language and technologies. Nowadays there are many technologies to choose from.

MS Access, VBA

As an effective RAD (Rapid Application Development), MS Access was initially aimed for home and smaller offices, being part of the Office suite. It later became the tool of a larger audience, up to corporate entities. This is because in the right hands MS Access can become a powerful and versatile tool: it allows for fast development and integration with other platforms (APIs, databases) while being relatively easy to maintain and work with.

The problem with MS Access is the learning curve: basic concepts can be learned quickly, but for serious features a "real" developer with lots of VBA experience is needed.

We develop applications for MS Access (VBA) on a high level; our library of custom functions and classes is continuously growing to make the products competitive, fast and easy to use. Using VBA we have integrated online solutions and technologies such as Wordpress (WooCommerce), eBay, Amazon and many others.

We routinely integrate MS Access frontends rarely using the native MS Access database (for single-user apps) as a backend, but most often the backend is MySQL or MS SQL. These real DB engines can be used for remote connections, meaning all the data is stored in the cloud and it can be securely accessed by other applications.

We have lots of experience with integrations of business management software such as Sage Accounts 50 (invoice injection, special reports Sage can't produce using the Sage database via OBDC connection and others).

A large range of APIs can be integrated allowing the MS Access applications to send SMS, make calls, process emails, download/upload orders from Amazon/Ebay or online stores, hanle online stores, collect and process data, mine data and other such functionalities using the VBA language.

Java

Java has the advantage of being cross platform, so it can be compiled to run on other OS (Linux). It also allows the development of larger applications where a higher level of customization and lots of data manipulation is needed.

Some examples of our desktop applications

Funeral DB

Team size

2 people

Duration

5 months

Approach

Pricing model: Fixed

Methodology: Agile Scrum

The product

The client needed an application able to handle hundreds of thousands of clients, each client having up to ten documents (scanned or generated by the app).

Highlights

-a file server was setup; it contains over 10 Gb of files and its growing constantly.

-the application uses a dedicated mySQL server with live replication to avoid data loss.

Technologies

MS Access, mySQL, VBA

WooStore

Team size

2 people

Duration

7 months

Approach

Pricing model: Fixed
Methodology: Agile Scrum

The product

The client's business is a store selling pet-related products. The client already had an Access application that handled products and orders; a different company made a WooCommerce web store for the same client. The client wanted his current Access app to be enhanced and integrated with the wooCommerce shop as he didn't like the Wordpress interface and managing a large list of products was a tedious job, prone for errors job. Aditionally, the client setup several Amazon and eBay seller accounts in order to reach a wider client base so these orders were to be processed by the same app

Highlights

-WooCommerce, Amazon and eBay orders handling

-Ability to manage the WooCommerce platform (products, clients)

Technologies

WooCommerce, VBA

RISP

Team size

1 people

Duration

2 months

Approach

Pricing model: Fixed
Methodology: Agile Scrum

The product

The client used Sage 50 Accounts and wanted some reports that were impossible to create using the Sage Reports tool. In addition, the client had an online system that created orders he wanted to be integrated into Sage 50 Accounts.

Highlights

- Sage 50 accounts API and ODBC

- A DB mirroring technique was devised in order to overcome the native Sage DB speed issues

Technologies

MS Access, mySQL, VBA, Sage 50 Accounts API, Sage 50 Accounts ODBC