|
|
|
|
Systems have been developed in a wide range of office and business environments:
Government Sector
§ A state government department training agency multi-user (13 workstations) Participant Records System that keeps track of courses, training staff and venues, participants, enrolments, attendance, course programs and participant progress in programs. System outputs include participant correspondence and certificates, course participant lists, and management summary reports. The system was originally implemented in Microsoft® Access 2 (50 tables) and has been operational since 1997. The system was upgraded to Access 2000 in 2002 and Access 2003 in 2005. Private Sector
§ A mortgage broking office multi-user (10 workstations) Client Database that keeps track of brokers, clients, both lenders and borrowers and their various financial entities, the mortgage contract details, and referral sources. The system input is largely via an ODBC link to the mortgage accounting system. System outputs include lists of available funds, requested mortgages, and expiring mortgages. The system was implemented in Microsoft® Access 8 (12 tables), and was operational from 1998 to 2001. § A waste-oil recycling company single-user Client Database that keeps track of clients, their waste-oil tanks and processing contracts, liquid waste transporters, waste-oil pick-up schedules and processing details, including costs. The system input is largely via a data file link with a waste-oil delivery logger. System outputs include pickup schedules, invoice data files for importing into accounting system, and summary lists of processed oil for government regulator. The system was implemented in Microsoft® Access 8 (16 tables), and has been operational from 1998 to 2005. § A collections agent’s existing multi-user (4 workstations) Debt Collection System and associated accounting system (both implemented in Microsoft® Access 2) upgraded to meet Y2K compliance in 2000 and GST compliance in 2001. § In 2004 an environmental project management company required replacement of a user-developed staff leave database and major overhaul to a user-developed mine site rehabilitation database that keeps track of revegetation of the site. Both systems were implemented in Access 2000. Non-Profit Sector
§ A non-government residential drug and alcohol rehabilitation agency single-user Client Records System that keeps track of client demographic and medical details, and participation in the treatment program. System outputs include client lists, and summary reports for management and government funding bodies. The system was implemented in Microsoft® Access 2 (34 tables) and has been operational from 1996 to 2003. § A large inner-city church office single-user Contacts Database that keeps track of parishioners in 2 parishes, including their baptisms and weddings, parish committees and members, donors, including local businesses and donations, and function attendees. System outputs include contact lists, appeal donation lists, and function attendance lists. The system was originally implemented in Microsoft® Access 7 and later upgraded to Version 9 (20 tables), and has been operational since 1998. § A 100-voice choir single-user Member Records System that keeps track of choir members, membership fees, concerts, concert singers, and member roles. System outputs include section rolls, member contact details lists, name badges and address labels. The system was implemented in Microsoft® Access 8 and later upgraded to Version 9 (24 tables) and has been operational since 1997. § A single-user Concert Box-Office System that keeps track of patrons, concert performances, concert venues, venue seating plans, ticket prices, ticket bookings and banking of payments. System outputs include seating plans, banking summaries, ticket sales reports, and address labels. The system was implemented in Microsoft® Access 2 and later upgraded to Version 9 (23 tables) and has been operational since 1999. ® Microsoft and Microsoft Access are registered trademarks of Microsoft Corporation. |
Send mail to
webmaster@accentdata.com.au with
questions or comments about this web site.
|
