Business database software programming using Microsoft Access

The ACCESS GURU
   Melbourne, Australia

Contact:
Email:
Phone:

Tim Pryor
[email protected]
0414 228 974

   

Some Recent Projects

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.     VIEW SCREEN SHOTS

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.     VIEW SCREEN SHOTS
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.     VIEW SCREEN SHOTS

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.     VIEW SCREEN SHOTS

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.     VIEW SCREEN SHOTS

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.     VIEW SCREEN SHOTS

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 (SAP) 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 ...