10-13-15, 11:30 #1Registered User
- Join Date
- Oct 2015
Unanswered: Newbie to Access 2013 needs help to design first database.
This is my first post and first steps to Access so please be gentle to newbie.
I don't want nor expect ready solutions, but guidance and help so I can understand the whole process of designing the databases in professional manner.
I want to create database to help a small non-profit organisation in assigning tasks to volunteers.
The organisation holds two 'meetings' weekly. On every meeting there is a list of 'speeches' given by speakers and some auxiliary tasks that need to be assigned (who operates PA equipment, who opens and closes the venue etc)
The volunteers have got different skills and 'level of access' so not every person can be a speaker or operate PA.
List of tasks is assigned on rota basis so in every week people assigned to certain tasks will change
What I try to achieve with database:
- I want to be able to assign volunteers to the tasks from the list that is showing only those being able to do it
- I want to check if they had not been chosen for the tasks that excludes each other (for example one person manning the gatehouse cannot be chosen for speaker on this meeting but can do speech on next one)
- I want to be able to print reports with 'schedule' of meetings
- I want to be able to send report to every volunteer with list of tasks assigned to him in next two months
What I have done so far:
- I watched many tutorials on YT
- I already created a table of Volunteers with
ID/Name/Task1/Task2/Task3etc fields (Task1/2/3 are Yes/No fields to be ticked if a volunteer can be assigned to certain task).
-I had created a very basic form to add/edit/remove Volunteers and their skills.
-I created a table Meetings with a list of tasks to be manned (each row is 1 meeting, each field is a task).
What I now need help with:
I want to create a frm to fill tblMeetings with names from tblVolunteers.
How can I relate these two tables to get combobox for Task1 looking up for only those names from tblVolunteers that got Task1 field ticked Yes.
How can I create query that will check and inform me that I assigned Volunteer1 to Task1 and Task2 (which excludes each other). How can I create list of tasks that exclude and not exclude each other (ie person opening the venue can be a speaker but a speaker cannot operate PA equipment).
10-13-15, 20:21 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
Question What happens when there more than 4 task
thats the Clue
create a Task Table
Adate Add date
so looking at the task table
you can join to the Person table and get there Fname
also linking it the the Meeting Table you can get the meeting discriptionhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON