Function
Database to track the performance of the company. The front end, Access 95, uses pass-through queries to link to ORACLE tables. CMIS is divided into functional areas (accounts, debts, complaints, etc.) of separate MDB files; these reference an additional MDB file that contains common code.

Function
Database to maintain Cost Centres, Teams, and Agents. These details are used by the CMIS database to track workflow items.

Function
Database to keep an inventory of the company's computers.

Function
The database is a billing system for the printing department, recording charges to other departments for colour photocopies.
Output
Monthly and Quarterly reports show the charges made to departments.
Features
Reports are output digitally to eliminate re-keying the data into the General Ledger, saving staff hours.

Function
The database is a resource for contacting relatives of employees in the event of an emergency.
Output
Reports display the details for a single employee or a group of employees.
Features
The database imports a DATAEASE text file containing personal employee information.

A redesign of import file reduced import time from over an hour to less than a minute.

Function
The database holds order information for equipment and supplies. Each order is displayed with the payments made/outstanding.
Output
The following are some report examples: orders by user/supplier; orders with outstanding amounts by user/supply code.
Features
The database uses API Function calls and user defined types.

The database uses auditing to associate an order to a user's NT login ID.

Function
The database holds information for employee loans such as car, education, house purchase, home improvement and season ticket.

Two departments can access the database. The loans department has primary access and can lock the database to carry out monthly processing for the employee payroll.

The database provides flexibility through the following:

- The number or amount of monthly repayments can be changed.

- Repayment of a loan can be suspended. The length of suspension can be increased or decreased.

- One-off payments can be made any time.

The database allows users to override a rejected loan request and audits all user transactions.

Output
Database outputs text file to the mainframe with repayment details.

The following are some report examples: outstanding loans, suspended loans, new loans, letters to employees, loan statements, tax statements.

Features
The database was migrated from a 12-year-old FoxPro (DOS) system; the data had to be manipulated into normalised tables.

The database imports a mainframe text file containing employee information

The database imports a mainframe text file showing the repayment deductions made from the employees' pay cheque.

The database uses API Function calls and user defined types.

The database has complex coding to provide the required flexibility in functionality.

User tracking shows which users are logged into the system.

The database provides multiple user access with record locking and displays which user has locked the record.

A timestamp shows the date/time of the last data transfer to prevent users from making multiple transfers.

The database has extensive error trapping, rolling back changes in the event of an error.

Database uses e-mail to send the letters and statements to the employees; this greatly reduces the internal mail.

Function
The database records employee location details to be printed on distribution lists, envelopes, preprinted flyers, or labels for other circulars.

The data for the printouts is filtered on a report criteria form where the user can select specific categories, salary bands, groups, or departments.

The database contains details of employee subscriptions to company publications and produces a printout for the required number of copies.
Output
The reports provide the required format for the address details; users can select specific address fields and media type e.g. labels or a range of envelope sizes.

Features
A mainframe text file is imported, containing employee location and payroll information.

A timestamp shows the date/time of the last data transfer to prevent users from making multiple transfers.

The post room prints over 20,000 labels, taking over 6 hours on their existing printer; the new system specified a laser printer, bringing the printing time to 50 minutes and freeing up resources and staff hours.

The database exports a text file to the mainframe to allow employee location information to be printed on the salary payslips for ease of delivery.

Function
The database holds details of employees whose performance is above the call of duty.

Prize Drawings are held once a month with twenty employees receiving awards; the top three employees are put forward for an annual draw.
Output
The following are some report examples: Certificates, letters of award, tracking to see which stores provide nominations.