Question DataBase Overview

[TopherGeorge]

I was hoping someone could help me or refer me to the relevent tutorials as I am having some problems.

I am working on a databse for project managers to allow them to get a holistic overview of their projects. I am normally an Aircraft Engineerthe Royal Navy not a database expert!!! I have imported the main project data file, Project_Data.xmlx. as a table which is where all the info is stored for the 200 projects.

The primary key is the ProjectID and there are a further 30 fields. I need to create a form with cascading combo boxes to identify the following fields:

ChangeExecutive
ProgramManager
ProjectManager
ProjectProgram
ProjectID

Further fields include; FinancialForcast, ProjectStatus, ProjectRisks, ProjectDescription, GeographicalRegion, PrjStartDate, PrjEndDate, the list goes on. I am not breaking up this main table when first imported as it needs to be left together.


From these fields I need to refine the original Project_Data Tble (to include the remaining 30 fields) and bring up a new table based on the filtered fields above, and from there create differnt pivot charts based on ProjectStatus and Financial Data.

From that initial look up screen I need to go into a page that gives two main areas of options (again all based on the results just derived)

Section A: Canned Reports;
project status report, project health report, project overview, project financials, project descriptions

section B: Free form reports
This will be more pivot based and give the user the ability to derive their own reports

I am also looking at writing code to download and create a local copy of the source Project_Data file which is hosted on an intranet site. Is there a good way of doing this?

I have derived some storyboards of how this all needs to look, but need some tips and advice on what the best way of recreating it is. I can send these for someone to review.

 

[JamesMcS]

Hi! Sounds like an ambitious project! Have a google for cascading combo boxes and filtering forms from combo boxes, there's plenty on this site and even more on t'interweb...

You might consider a tab control for this - Tab 1 sets parameters, Tab 2 for your canned reports, and tab 3 for your pivotcharts.

To copy a database there's a command, docmd.transferdatabase or you can use Shell to copy it over as though you were using DOS.... but I would hesitate to do this as you'll probably end up with a load of unsynchronised databases all over the place and everyone singing from different hymn sheets. I would have the back end, with all the data you need, kept on the intranet and have a front end with linked tables that users can download. That way, data only gets update in the one place and everyone has the same info.