February 20, 2023
  • Home
  • Hey Wendy Watch This
  • Heart of London Video Tour
  • Mostly Roman and Early Christian Tour
    • Campidoglio
    • The Forum
    • Trajan's Forum
    • Cosma and Damiano
    • Arch of Constantine
    • Colosseum
    • San Clemente
    • Santa Maria Maggiore
    • Santa Prassede
    • Santa Pudenziana
    • What Next?
    • Rome Walkabout Tours >
      • App Help
  • Renaissance, Mannerist & Baroque Tour
    • Piazza del Popolo
    • Pincio Hill
    • Spanish Steps
    • Trevi Fountain
    • Piazza Colonna
    • Sant' Ignazio
    • Pantheon
    • San Luigi dei Francesi
    • Piazza Navona
    • Santa Maria sopra Minerva
    • What now?
  • Blogs & Things
    • Keith Bantock
    • Italy 2014 Blog
    • Photography >
      • Beck 74 Reunion
      • Carmelo
      • Monreale
      • Siena
    • Gloria Browne
    • Touchy - Feely Section
    • Deb's Blog
    • Deb's Background
  • Ruggiero
  • Corniglia
  • Mothers
  • Oh Look a Castle
  • Lorne Avenue School Demolition
  • David's View
  • Unbeleev
  • Burano
  • Keith Painting
  • Vernazza from the Cliffs
  • Delia
Picture

Community Treatment Order Database

The Community Treatment Order multi-user database was developed to meet the recall and tracking needs for three hospitals in Southwestern Ontario. Mental Health Directors, Managers and Co-ordinators worked closely with me to be sure the database was exactly what they needed to efficiently manage their patients. Input from three hospital teams was most helpful to provide different perspectives for management and development.

The design is based on the Ministry of Health Community Treatment Order Information Record. It is menu-driven, which means that it is easy to use and very straightforward. You do not need to know how to use Microsoft Access to use this database. However, it is built in Microsoft Access 2016, which means Access 2016 must be installed on your computer for it to be used. Older versions of Access will not work with this database as the structure uses new features of 2016.

A button is built-in which will export all data to an Excel spreadsheet where you may manipulate it using filters and pivot tables.   In Excel, you may also build graphs to display specific information. 

The videos below present an introduction and overview to the two main sections of the database. 

Introduction and Data Input

Reports

Picture