MS Access Database Design / Development

Depolo Design offer 11 years experience in MS Access database design/development. Clients have included:

• Civil Defence, Dunedin City Council.
• Natural History.
• Otago Youth Wellness Trust.
• Citilab.
• St John.
• PGG Wrightson Ltd (Irrigation).

Experience has included:

• Resources database, including wildcard search screen and extensive reporting with multiple output options.
• Significant modifications to a personnel database: changes to screen design; new reporting process, which includes multiple output options (MS Access, MS Excel, MS Outlook Email) and multi-select criteria lists.
• Questionnaire database, including statistical and exception reporting (MS Excel spreadsheets, charts and 'drill-down' data lists).
• Incident report database, including recording accidents/incidents, search screen and extensive reporting (MS Access reports and MS Excel 'drill-down' data lists and charts.)
• Film footage database, including ordering footage process, and rights and log management.
• Film rights management database.
• Enquiry / job database.
• Client assessment database (including extensive statistical reporting and user-level security) for a community / non-profit organisation.
• For a local training provider, automating the process to submit unit standard credits data to NZQA in Wellington.
• Regional client database, including subscription and donation components, and automated letter processing.
• Converting an existing soil testing system from MS Excel to MS Access, which included importing data from 1500 spreadsheets.
• For a local corporate, automating the processing of the monthly Telecom account data - outputting a journal summary grouped into ledger code order for importing into the client's accounting system.

The Process

To discuss the requirements of your proposed MS Access database contact Lorraine Harris . Alternatively, complete and submit an enquiry form. An appointment would be arranged to review the requirements, after which, a proposal document would be provided outlining the understanding of the project and database scope.

Top of Page