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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I make an activity calendar for 3 months?
So could someone help me please
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|