Tracking daily Bipolar Meds, Moods, Activities, Sleep?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

As my Bipolar condition progresses, it's become harder to provide meaningful
feedback to my psychiatrist during my monthly visits. I'd like to have a
simple form-based diary allowing multiple entries per day where I:
specify meds/dosing/possible side effects
specify sleep quality/amount
rate my mood
rate my energy level
log activities/events
record thoughts, side effects
As a result, I'd like to be able to view/print a chart showing how I've done
over time based on information I entered.
Any suggestions would be greatly appreciated.
 
I think a single Table, or maybe two, will handle most of what you have
in mind, plus a Form containing a Chart for the chartable fields.
As my Bipolar condition progresses, it's become harder to provide meaningful
feedback to my psychiatrist during my monthly visits. I'd like to have a
simple form-based diary allowing multiple entries per day where I:
specify meds/dosing/possible side effects
Click to expand...

Inclued a [Date] field for the day to which the record applies.

You might want to include a primary key field (Autonumber type) to keep
records unique, but it's not necessary unless you link multiple Tables.
If you're sure that you will never store more than one record per day,
the [Date] field will be good enough to use as a primary key.
specify sleep quality/amount
Click to expand...

- quality could be numeric scale, 1-3 or 1-9, which could be plotted
- amount: # of hours
rate my mood
Click to expand...

- numeric scale again, whatever's convenient/meaningful for you
rate my energy level
Click to expand...

- numeric scale
log activities/events
Click to expand...

- text field, unless you know of a way to categorize these. After a
few weeks, you'll have a better idea how to summarize this stuff.
record thoughts, side effects
Click to expand...

- text or memo field
As a result, I'd like to be able to view/print a chart showing how I've done
over time based on information I entered.
Any suggestions would be greatly appreciated.
Click to expand...

Concerning the medications, if you have more than 2 or 3, I suggest
splitting those fields out into a separate Table, in which each record
contains

- link to the day's record in your primary Table ([Date] field or
other primary key there)
- type; name of medicine (text field)
- dose (numeric value)
- side effects (text)

I don't expect that you can do much with the text fields, though it's
possible to define a Query that would examine a text field and return a
yes/no or numeric field value depending on what it finds there, and you
could plot the translated values.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top