Table structure for workplan

[SF]

Can I use Access to store workplan that have the following structure? If yes
how?



N° Main Activities Year 2009 Lead (Support)
Jul Aug Sep
Objective 1: Build sustainable horizontal and vertical links between
citizens, local government and national government (increase demand)
Activity 1.1: Assisting citizens to engage in effecting change
Increase Support to CMCs (demand side of governance)
Continue training/technical support to NGOs (CC tool, concept,
principles) P P P P P P Retreat 18-21 P P P P P POs (Supported by SGMOs)
NGOs provide training/technical support to CCs P P P P P P P P P P
P PNGOs (supported by POs)
Observe and feedback to CMCs in actions P P P P P P P P P P P
PNGOs (supported by POs)
Reflection session: CMCs' progress, concept, principles (tbc
NGOs/POs) P P PNGO Director (POs)

CMC tool kit formulation and implementation
Finalise layout and pictures P P Retreat 18-21
Pshum Ben 18-21 Soktha (working group)
Pre-testing took kit P P Soktha (working group)
Finalise tool kit (printing) P Soktha (working
group)
Implementing the tool kit (training with CMCs) P P P P P P
POs (SPOs)
Review and improve the kit (following quarter - Dec09)
Soktha (working group)



SF

 

[Fred]

Access is a powerful toolbox. Once you restate all of what you described in
a more thorough and methodical manner, somebody will probably be able to
confirm that the answer to your first question is yes.

As far as how to do it, the first step would be to start learning Access.
Simultaneous with that I would start developing a methodical description and
list of the information entities that you want to store in the database, as
well as a list of the types of relationships between them that you want to
record. And post any specific questions that you have in these forums.