Database Apps

Microsoft Access Database Apps
Get the database you want

Organised Information for
SMBs and Teams

Part of the MS Office Suite of products, MS Access is the next step above MS Excel for data entry, management, and reporting. Suitable for teams up to about 10 people, this is a powerful  and versatile application.

Challenge

What happens when you need to manage and control large and frequent data entry projects? Add to that, the need to produce consistent, attractive reports for all your team members, or even just yourself? At some point, MS Excel, as good as it is, will not provide the data entry and reporting options you need.

Solution

Microsoft Access is an easy-to-use tool for creating business applications, in minimal time. Custom apps controlled by smart programming using, if necessary, Visual Basic for Applications (VBA) to automate systems and processes. Connect your app to external data sources such as Excel or MS SQL to produce professional reports, graphs, and even dashboards to help you monitor your daily business activities.

Some benefits of using Access:
  • talks to Office
  • easy to control for consistent data entry
  • a single source of truth
  • prevents duplicate values
  • prevents missing values
  • simple yet powerful reporting and insights
MS Access is used by:
  • small business
  • departments
  • corporate wide, or for
  • personal applications
We discuss, design, build, then test a custom product for your requirements.


Application Portfolio

  • Soft Drink Manufacturer – Specialist application for customer orders, quotes and invoices. Reports included orders by date or by location.
  • Finance Broker – Management System for Customers, Staff, Quotes, Commissions, Referrals and Products. Reports were built for each of the aforementioned areas including detailed lists, summary lists, graphs and pivots tables.
  • Building Services – Management Tracker for building certification and compliance, equipment testing and audits. Reports included client details requiring managers, certification dates, invoicing, also certification due dates per location or per month.
  • Health Care - Quality and Risk Management solution to manage, track and evaluate project tasks for individuals, teams and committees, multiple accreditation and compliance frameworks.  Task mangement included progress notes and linking supporting documentation. Specialised reports were required for certification agencies in required formats and layouts. Gap analysis reports showed which outcomes and standards were over/under allocated.
  • Training Organisations - Event Management application to create training 'templates' and from those, setup bookings for single or recurring dates for set groups or different participants for each date.
  • Staff Certification – related to the above application for training organisations, the system tracked professional development points, due dates and alerts for certification. Also tracking for certification such as Police Checks, Working With Vulenrable People (WWVP) checks,, interviews, and anniversaries. Reports included training certficates and transcripts, departmental summaries for staff showing due and overdue dates.
  • Incident, Accident and Hazards – all information regarding time and place, people involved, details and resolutions, progress notes, notifications to managers and other stakeholders. Reports included analyses of locations, departments, change of shift, property in both text and graph format.
  • Customer Relationship Management – various incarnations and varieties for small home businesses, agencies, professional offices eg doctors and dentists.
  • Sport Clubs – built specifically for members to record fees and membership status. Also for training schedules, outcomes and progress notes, game and match results.
  • Feedback Management – designed to track and manage all compliments, complaints and feedback from both internal and external sources to assist managers and committees resolve and address issues raised in the correspondences. Reports include both detailed and summary lists and graphs of information by topic, nature, date range, people involved, outcomes, comparisons and analysis.
  • Talent Agency – this database application kept all clients and actors/freelancers and their skills, along with the bookings, contracts, job descriptions and requirements. Details were merged into MS Word and  emailed as required. 


  • Newsletter and Book Publisher – this database contained a mailing list and subscription information including plan for publication quantities along with actual production and distribution details.
  • Property and Building Cleaning Company – an specialist application to record and report on cleaning schedules and the individual requirements for each building, department, floor, and section. Setup of audit schedule requiring question and rating (scoring) mechanism and various follow-up process based on the success or failure of the audit. This application also required both the scheduling and the audits to be cloned for future use and user customisation.
  • Franchise Management System – This application was built for the master franchise owner to manage and report all details and specifics about each franchisee including fees, territories, responsibilities, contracts, and training.
  • Medical Product Testing – built to record world-wide product trials including regional variations eg currency and units of measurement, manual and automatic data checks, procedures, cross check procedures and external validators, double-blind test results and reports, alerts for discrepancies, variations, and outliers. 
  • Tertiary College – developed and expanded over several years to record student enquiries and the transition of each through to student applications and finally student status. Individual details were stored along with correspondence records, history of prior learning, relevant medical history, course and subject enrolments, progress notes, and academic records. The application also required the setup and management of semesters, terms, streams, subjects, electives, lecturers, and learning outcomes. The final product featured a large array of reports such checklist, letters, labels, statements of attainment and transcripts, statistics on enquiries, appllcations and enrolments, stuent results, and analyses of college changes and growth.
  • Food Manaufacturer – monitoring procedures and recording and analysing system audits.
  • Legal Practice – a dabase to manage clients and history and portfolio, contracts and agreements, plus the mail merge of clients details into documents.
  • Church Database – to record member details, manage conferences, meetings and bookings. Reports included lists and labels.
  • Consultant Management – purpose built application to manage consultant bookings and related project tasks and progress notes in order to generate booking sheets and customer invoices. reports included invoice history and overdue invoices, work history, client list. We built this for ourselves before accounting programs could handle what we needed to manage our business.
  • Work Health and Safety Systems – multiple systems for various businesses to record incidents, accidents and hazards, risk analysis, progress notes, investigation results, and incident outcomes.
Share by: