Custom MS Access Database Solutions

Applications stored patient, billing, and insurance data, it also allowed a patient to sign documents on a tablet and the signature was stored in his record. 

There was a scheduling module and a separate form on the tablet which a patient would fill out on their first appointment. The data they entered would instantly be available in the application.

There was also an image/document storing screen where they can attach scanned patients’ test results and other documents.

Applications kept track of clients, services and prices, appointments, created mass mailings. 

We also created an automated invoicing module for a large loan provider, it printed 20,000 invoices every month.

Designed and developed an application with 2-way MS Access QuickBooks integration for an international logistics company. 

Accounting data was automatically imported into the application from QuickBooks and customer and order data was exported from the application into QuickBooks.

The application allowed the users to create complex quotes, import customer data automatically from website request emails, track routes, prices, and shipping companies, and pick the best option for each request. And, of course, create reports with various criteria and outputs.

Applications kept track of all available apartments and houses, allowed renters to submit repair requests, scheduled those requests for the maintenance crew, ran a roster with rent due dates for each property, stored renters’ information. 

It also ran a scheduling module for viewings and allowed a manager to reassign viewings from one employee to another.

Automated inventory management systems we developed kept track of clients, inventory, appointments, sales, created mass mailings and did some CRM. They also allowed for automated price setting and restocking, based on a predefined, complex algorithm custom designed for each business.

They also tracked suppliers, products they offer, and all costs associated with ordering from them, such as shipping costs, minimum order amount, products they carry. If they provided product lists, they were loaded automatically. 

We have developed custom inventory management software for many warehouses, each with their own quirks and requirements. We worked with one warehouse which had such a unique way of doing business that no mass market application would even come close to satisfying their requirements.

Applications stored a client listing, all their animals, services needed for each animal, a scheduling module, and it had a dashboard with upcoming tasks. It also stored a price list and did billing and invoicing.

There was a separate module for the training, where they tracked progress by the dog, described the issues they saw and wrote up suggestions for the clients. Pictures and videos were attached to each dog’s record and sent to clients automatically.

Applications tored materials, prices, clients, types of work performed, guarantees, ran schedules for each contractor, performed complex calculations.

It also tracked inventory and automatically subtracted items needed for the job from inventory. There was also a notification for each inventory item when it got past a certain number (different for each item).

Applications stored client data, had a scheduling module, and a dashboard with appointments. It also stored supplier information, allowed automated ordering from the suppliers, and did a little CRM in the form of tracking clients’ visits and setting automatic reminders to call those that haven’t visited in a while. 

It also stored hair coloring formulas, nail polish colors and a few other things for each client and kept track of each worker’s schedules.

Applications kept track of inventory, purchase orders, ran sales reports, prepared accounting reports, kept track of workers’ schedules.

Various confidential projects.

Developed a reporting dashboard that linked data files from various sources and combined them into various reports which can be ran based on custom, complex criteria.

Developed applications for tracking various services; scheduling and queue applications; budgeting and accounting applications.

Applications stored client data, appointments, allowed scheduling, kept track of the advertising budget, and analyzed the return on each advertising stream.