Newbie Database Query

[dougers1]

Hi i am new to access and usually build my data on excel but was thinking access may be a better option for my new task, let me give you some details of what i am trying to do.

i am trying to create a database that will allow for a choice of 1st 2nd and 3rd choice for there favourite place to work. for example i am a nurse and my 3 choices could be 1st choice hospital 1 ward 5
2nd choice hospital 1 ward 2
3rd choice hospital 3 ward 10

this would be for around 11,000 nurses so its a big database and it would be used by several staff at the same time so it needs to be able to work from a shared area.

my aim is if hospital 1 ward 5 need a nurse i can obtain a list of staff who prefer to work in that area

Is this possible. please help i am new to access

 

[Ranman256]

yes, you want an access db.
Table , tStaff
StaffID (autonum)
FirstN
LastN
etc

table: tHospitals
-------------
hospID (auto)
hospName
...

tWards
--------
wardID (auto)
HospID (long)
WardName

tChoices
---------------
ChoiceID (auto)
StaffID (long)
Choice (integer) 1st choice, 2nd, 3rd
HospID (long)
WardID (long)

once build, spit the database, so many users can access on a server.

 

[dougers1]

great i will work on this striaght away , as i said i am new and are currently looking at videos how to. is it possible for you to create a example for me so i can see what it looks like

Thanks

 

[Ranman256]

I just did. Above.

 

[dougers1]

can you explain a little more please what is auto ect

 

[Alvarogue]

can you explain a little more please what is auto ect

Dougers1;

When you create a new table in design mode, it gives you which colums of information you want to put. an Autonumber is what makes each table to be unique, so for example, Ward 1, Ward 2, Ward 3, will have autonumbers that will be collected for each. I do recommend you to get a small tutorial bases so you kind of embrace al that information.

 

[Uncle Gizmo]

can you explain a little more please what is auto ect

Ranman256 has described the table structures you need to construct in MS Access.

Where he has used the term "auto" he means for you to make that field an auto number field.