Schedule projects in Access

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Hi All: I wrote a database that I use in my company for construction. Anyone
have any ideas on using the info like start date and working days or finish
date to print calanders or ghant charts to display schedules.
Or can the data be exported to an exel sheet or Act contact manager to
display their. Thanks, Ed
 
Ed,
I feel very strongly that you are a point where you need to consider
Microsoft Project!
 
Ok, I have microsoft project 95. Can I import data from access xp to it?
I thought excel would be the choice but seems clunkie. Would like to use
access and have it print report with calander.
Thanks, Ed
 
Ok! I cant remember the import capabilities of Project 95 - Run Project and
search Help for 'import'. However, I strongly recommend the following 3-step
process:

Run Project
View>More Views>Task Sheet
Note the six columns you will try to fill!

Run Excel
From within Excel run MS Query on your database. Generate the Query to
match the column order in Project.
Run the Query, and return the data to Excel
Save as needed.
Leave Excel Open

Run Project
View>More Views>Task Sheet
Since your Excel Columns match those you see here,
you can copy and paste from Excel*. This will allow you to view and
print:
Gant Chart View
Calendar View
and ALL task-related Reports!

*You MUST lay out as shown in Project
You MAY leave columns blank
The data (Duration, Start & Finish dates) MUST be consistent (unless
1 column is blank)
If your links are not overly complex, or the predecessor/successor
information
is difficult to extract, they can be formed quickly in Project by
'linking tasks'

That addresses your direct question.

Be aware that Project has a native capability to save projects in an Access
Compatible Database (there are no relationships defined) - multiple projects
at that. You could use MS Project to manage your projects, and all the
features of access for special queries (creating links in the query) and
reporting. It will be a fair bit of work to absorb and document the details,
but may well be worth it.

At least one multi-national uses the following schema:
|--- Project Control --|--Tech Support--|--Personnel
Control--|
Proj Mgrs <->MS Project<->ProjectDB<-><ResourceDB>Personnel Mgmt
Tech support have set it up, and it works seamlessly!
 
Back
Top