I designed and maintained a database used to track my organizations projects. Access frontend with a SQL backend. I have a table for all the scheduling events. Task, Start, Finish, duration etc. Really basic. I am looking to create a form or report that displays a Gantt chart.
At the same time I'd also like to create what we call a Bird on Wire Chart. Not sure it that is a term unique to my group.
Microsoft Access Help Database Forums and Wiki by UtterAccess.com.
It is a line divided up in months with triangles associated with events and dates. Project managers use power point to move the triangles around to show major milestones for their project. I'd like to automate this somehow using the data from the schedule table.
First is it possible to do these things? And second and example would be great.
Hi, I've recently decided to revamp my company's method of tracking current projects. The current methods is an excel based spreadsheet that has tabs for employees, holidays, training, (about 90 tabs of calculations) and one final sheet that brings it all together to show what projects people are on, when they are on holiday on those jobs and when these jobs are, an example of what this looks like is attached: I've so far created a database with all the relevant information, however i'm completely confused now as how to or even if it is possible to collate all this data into a format like the screenshot, similar to a gantt chart. I've also attached a screenshot of my relationships to show how I've got everything connected. Mostly the way that each of the tables are connected are via query's and drop down boxes in case that helps. Good luck to anyone who can help me out with this, and thank you. I've so far created a database with all the relevant information, however i'm completely confused now as how to or even if it is possible to collate all this data into a format like the screenshot, similar to a gantt chart. As plog wrote, it is a pain to make that in MS-Access, because there are some limits, one of them is the width, forms/reports can only be 57.79 cm width, which is reached fast, when data is displayed horizontal like you wish it.