A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I make an activity calendar for 3 months?



 
 
Thread Tools Display Modes
  #1  
Old May 15th, 2010, 12:09 AM posted to microsoft.public.access
emma dillon[_2_]
external usenet poster
 
Posts: 1
Default How can I make an activity calendar for 3 months?

So could someone help me please
  #2  
Old May 15th, 2010, 01:01 AM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default How can I make an activity calendar for 3 months?

On Fri, 14 May 2010 16:09:01 -0700, emma dillon
wrote:

So could someone help me please


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.
--

John W. Vinson [MVP]
  #3  
Old May 15th, 2010, 02:08 AM posted to microsoft.public.access
GP George[_2_]
external usenet poster
 
Posts: 49
Default How can I make an activity calendar for 3 months?

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

"emma dillon" wrote in message
news
So could someone help me please


  #4  
Old May 15th, 2010, 06:23 AM posted to microsoft.public.access
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default How can I make an activity calendar for 3 months?

What are you starting with for tables and data? What format do you want?
Please use the large white space below the Subject line to add some
specifications.

You may want to review the calendar reports available at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP


"emma dillon" wrote in message
news
So could someone help me please


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.