Newbie: Designing a database in access

[Meli]

Hello,

Hoping some one could assist me? I am busy designing a database which I am going to put in access.

I have designed the tables and am now not sure how to link them. I was given an excell spreadsheet with headings and am now trying to make this into a database. Example : I was given Co-ordinator Name - Which I now split up into:

Co_First_Name
Co-Last_Name
Co_Initials
Co_Area_Code
Co_Tel_Number
Co_Mobile
Co_Email


Now there other fields like this , for example Regional Manager Name - which I have split up as above into a seperate table.

These fields all relate back to one Code - Called District

There are also a fields which needs to show the a fee required the fee paid and fee outstanding/balance .

The rest of the information required I can create check boxes for , I hope!
Anyway my question is how do a relate all these different tables together?
This is my mental block. And the check box tha information - is it stored a another table? I hope I am explaining my self correctly and I hope some one can make sense of my question

 

[Sammy B]

I suggest you do it this way:

PersonnelID (autonumber)
Last_Name
First_name
PositionID (tied to Position table)
DistrictID
Intials
Address
etc

PositionID (autonumber)
Position
etc

DistrictID
District
etc

 

[Meli]

Great thanks for the help! These are the fields that are currently being used in an excel spreadsheet which I wanted to put into a database.
Am I getting confused between excel and trying to fit this into a spreadsheet type database . Where is my thinking going wrong. Obviously I need primary keys and foriegn keys to tie all these tables together and I am not quite sure how to do that:

NEWWard - input eg.1
OLDWard - input eg.2
Voting District No-input eg.14562573(unique number)
SUBURB - input eg.Coloroda Springs
REGION NAME - input eg.Denver
COORDINATOR-Name , contact details
BRANCH / CLOSEST - input eg Denver
COORDINATOR -Name , contact details
NOMINEE 1-Name , contact details
NOMINEE 2 -Name , contact details
NOMINEE 3-Name , contact details
ID COPY - input field - Yes/No
NOMINATION -input - Yes/No
ACCEPTANCE-input - Yes/No
FEE REQUIRED - input eg.$4.00
FEE PD - Input eg.$2.00
FEE O/S Input eg$2.00
PR POS input eg 5
Meeting Name_ATTEND 1 input eg Branch Meeting
Meeting Date_Attend1 input eg 12/12/04
Meeting Name_ATTEND 2 input eg.Public meeting
MeetingDate_Attend2 input eg.10/10/04

these are the tables I created :

Old Ward – Data Input (nOt TABLE)

New Ward – Data Input(NOT A TABLE)


VD – Data input(NOT A TABLE)

Suburb –List Box(NOT A TABLE)

TABLE - Region Co-ordinator
Reg_Co_IDNumber
Reg_Co_First Name
Reg_Co_Initials
Reg_Co_Surname
Reg_Co_Contact Number Area code
Reg_Co_Contact Number
Reg_Co_Mobile
Reg_Co_Email

TABLE -
Branch Co-Ordinator
Bra_Co_IDNumber
Bra_Co_First Name
Bra_Co_Initials
Bra_Co_Surname
Bra_Co_Contact Number Area code
Bra_Co_Contact Number
Bra_Co_Mobile
Bra_Co_Email

Table - Nominee’s
Nom_IDNumber
Nom_First Name
Nom_Initials
Nom_Surname
Nom_Contact Number Area code
Nom_Contact Number
Nom_Mobile
Nom_ Email
Nom_Number



Table Fee
Fee_InvoiceNo(primary key)
Fee_Req -
Fee_Paid –
Fee_Balance –R0.00

PR Pos- List Box (NOT A TABLE)

Table Meeting's Attended
Meet_Date.
Meet_Date_Name

 

[Sammy B]

What you are trying to do with limited knowledge is probably going to drive you nuts. You had best find someone to help you or hire a programmer temporarily. I don't believe anyone here has the time to walk you through such a complicated database. Best get some good books and a warm fire!

Sam

 

[Meli]

so it is a complicated database then?Oh sad! ok will keep studying . Thanks anyway.