How can I make an activity calendar for 3 months?

  • Thread starter Thread starter emma dillon
  • Start date Start date
So could someone help me please
Click to expand...

Certainly, Emma.

But you will have to help us help you.

We have no idea even what *computer program* you're using. Microsoft Access?
Word? Outlook? You can build a calendar in any of these three programs, but
they will be very different.

We also have no idea what you want it to look like or work like. Is this for
your personal use? for multiple employees of a company sharing a database? or
what? For how many people do you want to schedule events?

What do you want to do that the many available programs (Outlook's Calendar
for example) cannot do? How much time and effort do you want to put into this?
How strong are your Access relational database skills? Our answers will have
to be quite different if you're totally new to databases than if you're
already an experienced SQL and VBA programmer.

Please feel free to write a longer description of your project; we'll help if
we can.
 
Sure, but it will take SOME work on your part.

Start with an application like MS Outlook, MS Excel, or MS Word. You can
also do this in MS Access, which is the database program about which this
particular forum provides answers, but for a beginner, Access might be a bit
too advanced for just a simple three month calendar.

If you Choose Outlook, you'll find there are already Calendar functions
built right in, so all you really would need to there is start adding
activities to the right days. That's where I would do it, for sure.

If you choose Excel, or Word, you'll need to create a layout of rows for
the hours of each day and columns for the weeks (in the rows) and the days
of the week (in the columns). You will need at least three of these, one for
each month in your calendar. Of course, the way you decide to allocate time
to activities is going to have a big impact on how you design these
matrices, and how many you really need. The smaller the units of time you
need to track, the more cells you'll need, and the more pages you'll need to
handle them all.

Down the left hand side of each matrix, you'll probably want to add labels
to identify the hours of each day. Depending on which program you choose, of
course, the options available to you for this step are different. Across the
top, you'll want to add labels to identify the days of the week.

Now, in the "Cells" created by the intersections of the rows and columns,
you can start adding text to describe the activities being scheduled.

I'm repeating myself here, but the type of activity you are tracking will
have a big impact on the design decisions you make. If, for example, you
need to track every hour of every day, you'll need 24 cells per day * 7 days
per week * 12 weeks in three months!

Given the fact that this kind of task is already handled extremely well in
Outlook calendars, I'd probably just do it all right there.

And, of course, there are other on-line calendar options, such as Google
Mail, which work pretty well. I'm not sure what the costs are there, but you
might find that a reasonable alternative as well.

George
 
Back
Top