access and calendaring

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I need to track calendars for 25+ people. In addition I
need to track information on what they are doing and the
accounts that they are visiting. I then have to share
information through reports and calendars. I am a
beginner:)
Does access interface at all with Outlook or any type of
calendar scheduling?

Is this the correct program to do something like this?

Thank you in advance for your expertise.
 
This is not for the faint of heart!
Although tracking calendars seems a simple task, it quickly becomes a data
nightmare, as people want more and more functionality.

Best advice, decide how simple you can make your application, then work for
a week to make it simpler!

Now to the question.
1. Can I export outlook calendar to Access (Yes). From outlook
(file/export/export to file/access) . Problem is that each export creates a
database so you would then have to do a second import to get into your
application. See data structure below.

Your task then would require adding a field to identify the calendar source
from one of your 25 client/victum/subjects.
Some way to seperate out the Required and Optional Attendees, resources,
etc. then cross reference them.
Example.

Jon has a meeting with Joy in his calendar Jon -->meets --> Joy
One may want to add/verify that Joy has also scheduled this meeting and it
appears in Joy's calendar

now need to check for a Joy --> Meets--> Jon. (otherwise No Joy!)
(couldn't reist)

Anyway this is getting a bit long, and I think you get the picture. Work,
work, work to define the 'problem space' and what the program must do before
actually starting to do anything.

Best of luck.

Ed Warren


-----------------------------------------------------Outlook to Access data
structure
Columns
Name
Type Size

Subject
Text 255

StartDate
Text 255

StartTime
Text 255

EndDate
Text 255

EndTime
Text 255

Alldayevent
Yes/No 1

Reminderonoff
Yes/No 1

ReminderDate
Text 255

ReminderTime
Text 255

MeetingOrganizer
Text 255

RequiredAttendees
Text 255

OptionalAttendees
Text 255

MeetingResources
Text 255

BillingInformation
Text 255

Categories
Text 255

Description
Memo -

Location
Text 255

Mileage
Text 255

Priority
Text 255

Private
Yes/No 1

Sensitivity
Text 255

Showtimeas
Integer 2
 
Back
Top