Recent Projects

Recent Microsoft Access Programming Projects

 

Government and NGOs: Project Tracking System

Many government departments and NGOs run programs in which there are sources of funding being distributed in the form of grants towards projects. A typical project tracking system records a great deal of information about each project, including briefing and background, team and responsibilities, budget and forecast, outcomes and deliverables, milestones and variations, associated contacts and stakeholders, action log, and linked documents. There are usually also a variety of reports.

VMS Scheduling Tool

VMS Scheduling Tool The VMS Scheduling Tool is an application that was developed for the Venue Management School, a specialist business school that runs a one-week course once per year. Students are enrolled in either 1st Year or 2nd Year, or the optional Graduate Institute program if they have completed 2nd Year. The school uses guest lecturers from all over the world, and hires a venue for the week.

Tutoring Agency – Booking and Scheduling System

Tutoring Agency – Booking and Scheduling System This application was developed for a tutoring agency that operates nationally. Tutors are assigned to students through the agency, and tutors pay the agency a commission from their tutoring fee. Typically the client (usually the student’s parent) pays the first lesson fee directly to the agency, and thereafter the tutor pays a percentage of the fee as a commission to the agency, eg. 50% for lessons 2, 3, and 4, and 25% for all subsequent lessons. The commission payments are scheduled to be received every four weeks, and where a tutor has more than one student, their scheduled payment is aggregated.

Clothing Importing Company: Sales Orders, Purchase Orders, Inventory

A database application to track sales and purchase orders, as well as recording inventory levels of all stock. Despatch and invoicing are also taken care of, and a wide variety of reports is available. A barcode scanner may be used for entering orders and producing pick-slips. A second application, for use on reps’ portable computers, enables reps to enter sales and have access to the latest customer, sales and inventory data. Information collected while with a client is submitted to head office via email and recorded in the main system.

Mortgage Broking Company: Client Management, Loan/Commission Tracking, Loan Quotations

A database application which records details of clients and their loans, and keeps track of lender commission payments and how those payments are split between the various interested parties, eg. brokers, managers, agents, franchisees. A great variety of reports have been developed and the system includes many functions to streamline staff work-flow processes.
A second application, for use on brokers’ portable computers, enables brokers to assess client loan applications and provide loan quotations. Information collected while with a client is submitted to head office via email and recorded in the main system.

Personnel Supply Company: Casual Staff Placement System

A database application to manage the placement of casual and emergency staff servicing the medical sector and catering industry. The application matches client placement requirements to the availability and suitability of the listed personnel. A great variety of reports have been developed and the system includes many functions to streamline staff work-flow processes.

Network of Marketing Companies: Comprehensive Sales Reporting and Inventory Control System

An extensive database application to manage the entire company operations for each company within the network. It includes a vast range of functions and reports that effectively and efficiently fulfil the week to week operational requirements.

Educational Institution: Student Enrolment Database

A database application to record details of students, courses, classes, enrolments and results. It produces class lists, timetables, invoices, results statements, and many other reports.

Industrial Laundry: Client Management, Invoicing/Accounts, Inventory Control

A database application to manage all the administrative processes of the laundry. It records customer information including scheduled delivery and stock requirements, it generates orders and invoices, records receipts, and tracks all inventory movement, as well as producing a great variety of reports.

Large National Retail Company: Management Reporting Tool

A database application to receive data from the company’s main enterprise system and provide a variety of useful and essential reports not otherwise available.

Roof Truss Company: Quotation System

A database application to assist sales personnel in preparing detailed quotations, including costing and scheduling of a job.

Hotel Chain: Customer Loyalty Program

A database application which enables effective record-keeping of all necessary components of the customer loyalty program – members, point balances, hotel stays, room values, points earned, redemptions, rewards, suppliers, etc – and the presentation of this information in a user-friendly format which simplifies administrative processes and allows member queries to be answered easily. Daily or weekly data files of hotel stay information are received from the hotels and uploaded into the database. A great variety of reports have been developed for analysis of the data, including quarterly statements for members.

Large National Union: Membership Records, Accounts, Reporting

Development and extension of an existing database application consisting of an Access front-end over a SQL Server database. The database records all membership details including employment, membership terms, membership history, accounts and statistics. A great variety of reports have been developed and the system includes many functions to streamline the work-flow processes of union staff.

and many more…