Below is a small text explaining the projects Argeus provided to Bell IT.

Bell IT 2000 Ltd is an IT and telecom consultancy that began in 1999.
Summary of our role:
Design and development of various projects using Microsoft technologies and/or open source software: MS Windows, MS Office, MS Access, MS SQL Server, Linux, Apache, Firebird, PHP, MySQL and other standards like HTML, CSS, JavaScript, PDF. When needed investigate and help to prepare quotations (for software projects) technically. Design databases. Liaise with clients. Report progress to Bell IT 2000. Train and share knowledge with other colleagues, and allocate work. Prepare, import, export data when required. Write manuals. Train clients or assist training. Take usually help desk calls for software written; support and maintain usually remotely.

All the projects owned by Bell IT 2000 Ltd.

Bell IT 2000: Christmas dinner 2005

ERMTrack: Enterprise Resource Management Software for big international and UK based clients
Tools: IIS or Apache, MS SQL Server 2000/2005, PHP5, Javascript, HTML, CSS, Yahoo User Interface Library (YUI), PDF reports using FPDF, TCPDF
The system has been developed for Sun Systems Business/Accouting and Sage to export data related to:
* clients, suppliers, and accounts in general,
* cash sales invoices, credit sales invoices, credit notes,
* purchase invoices, purchases returned (or supplier debit notes),
* inventory of products and services,
* stock movements, despatch notes (delivery notes, waybills, gatepasses)
as well as for tracking
+ quotations,
+ purchase orders,
+ services regarding faults, maintenance repair services of the products sold or similar products clients have,
+ serial numbers of products bought, sold or moved between places,
+ personal tasks with a calendar,
+ approvals and all transactions awaiting a particular action
+ back orders (sales orders that could not be supplied straight away but need to be supplied when products are available)
+ regular customers who did not order for a while
+ minimum and maximum stock levels for identified products

LocumTrack for Desktop: Locum Recruitment Application
Tools: MS Access, VBA, SQL, Reports
Hospital records, vacancies (with requirements: skills, qualifications, etc.), locum records are kept. Matching is done quickly according to their skills, location preferences, CRB checks, etc. Detailed time sheets are saved, and locum payrolls and invoices to clients are created automatically. The database includes supplier invoices and payments, nominal codes, tax year related information. Many reports could be printed easily; e.g. list of filled/unfilled vacancies, financial statement, VAT return.

LocumTrack for Intranet: Locum Recruitment Application
Tools: Linux, Apache, PHP5, Firebird SQL Server, HTML, JavaScript, CSS, PDF
Visit www.locumtrack.com for more information. Similar to the desktop version, LocumTrack is designed for the net aimed to be user friendly, to speed up recruitment process efficient and to be platform independent. It has been improved a lot on the user interface and added more modules: letter templates with mail merge features, timesheets, payroll management, invoicing, CSV export, document attachment module, critical documents expiry reminders, personal reminders, message board, contact management module.

LocumTrack at the exhibition

CourierTrack: Courier Management Application
Tools: Apache, PHP5, Firebird SQL Server, HTML, JavaScript, CSS, PDF
Web-based courier management software with automatic invoice creation, PDF print-outs, batch emailing invoices as PDF attachments, issuing credit notes, tracking unpaid invoices, balances, etc.

CleanTrack: Cleaning Management Application
Tools: Apache, PHP 5, Firebird SQL Server, HTML, JavaScript, CSS, PDF
Web-based cleaning management software with a nice quotation system (including creation of quotation letters in PDF with enclosure documents, help on job specifications, pay rates and charge rates, job frequencies), tracking and allocation of cleaners, preparing job sheets, integrated personal and central calendars, and many reports in PDF format.

Some smaller projects:

* Management of contracts, inventory and cheques (3 Access databases for pawn brokers)
* Quotation tracking system with profit and loss analysis (Access)
* e-Newsletter generator (Access)
* MS Outlook templates
* MS Excel macros
* MS Word macros
* Maintenance and hosting of various websites of clients

Go back to sample solutions page..