-
Planning a Access Database
I just joined the forum. I am a novice with MS Access version 9 i.e Access 2000.
I recently completed a beginner’s courseonline provided by Netg called MS Access Fundamentals. The course included topics like ,working with tables ,working with data ,and working with forms and presenting data. What I would like to do is set up a database that mental health users and carers can tap into for information about services available to them in my locality, London. I want to write a questionnaires , send them out and when the feedback arrives chase those who need to be chased for the data. I am currently unemployed so have a lot of time on my hands.
My initial thoughts are to draw up the categories as follows
Local Carers in the area
Employment agencies in the area
Day/drop in centres in the area
Support Groups in the area
Special Needs Schools
Doctors
Within the Support Groups category I would include
Community Mental Health Teams include:
Consultant psychiatrists
Social Workers
Mental health nurses
Occupational therapists
Psychologists
All these categories appear unrelated but tables will need to be prepared. I could for example prepare forms for the opening times of the Day/Drop In Centres ect…
Eventually when all database is complete I would like to transfer the database to a web page/website or CD like you have with Yellow pages diecrtory ?
What is the best plan for this mini project and what aspects of Access version 9 are most important know and use to complete this database?
Thanking you all in advance.
eastfield
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|