Solumac

>> Free initial no obligation consultation
>> You may receive up to 90% funding – see Funding Opportunities
>> 10 % discount on additional services * discounted value must be equal or less than original purchase value

Solumac can design both small and complex MS Access applications for your business. As your business grows, Solumac can upsize your applications smoothly to MS SQL Server Solutions to enable the handling of multiple transactions with ease.

To date Ms Access is the most common Relationship Database Management System (RDBMS) for the Windows environment. MS Access is used for storing and maintaining customer records, sales data or just about any other data that needs tracking. It is suitable for small/medium sized businesses – (single-user and multi-user applications) as well as within departments in larger organisations.

MS Access applications are data rich, with smooth business-like user interfaces. They facilitate the development of highly efficient and customisable applications that enable integration of data from various sources over networks, intranets and the Internet.

Solumac recommends no more than 15 simultaneous users interact with an MS Access database. However recent developments by Microsoft have enabled us to design robust highly scalable front-end MS Access applications that interact seamlessly with complex and larger databases, like MS SQL and Oracle. This Client/Server type architecture is common in most business environments. Clients can now benefit from rapid application development at lower costs as well as increased application security and productivity. These applications can also handle a higher number of simultaneous users.

C
A
S
E

S
T
U
D
Y

Contract Management System

Our client, LJJ Contractors one of the fastest growing companies in the North East, specialises in Personal Protective Equipment and offers exceptional customer service to new and existing clients.

The Project:
To build a Contracts Management System for Construction Industry. Includes the following modules

Sales
(a) Produce a contract Initiation form
(b) Produce Payment Application form

Materials Procurement
(a) Scan Quotation and attach them to Order information
(b) Match/Verify Invoices and credit notes against Purchase Orders

Plant Hire
(a) Raise Plant Purchase/Hire Orders with signatures embedded via user login
(b) Produce accurate hire costs for all items on hire

Sub Contractors
Develop a Sub Contractors Database Application with the following key features
(a) Raise/Print Pay Certificates with a breakdown showing any Discounts, Measured worked to date, variations and approved work.
(b) Produce various reminders letters (CIS - Pay Certificates - Insurance - VAT)

Labour
(a) Manage Direct and Agency Labour records on a week by week basis
(b) Calculate costs per job and summarised costs by contract

Microsoft Access

Benefits of Microsoft Access

Why Solumac?

Microsoft Access Explained

Microsoft Access Example

C
A
S
E

S
T
U
D
Y

Microsoft Access

Benefits of Microsoft Access

Why Solumac?

Microsoft Access Explained

Microsoft Access Example

CASESTUDY

C
A
S
E

S
T
U
D
Y