It it possible to create a database in Access for this:

[sea_minerals]

Hi,

Im trying to create a database, but not having much luck. Im new to MS
Access.

I would like to use a switchboard that people open - it will be used
by at least 6 people - so when they open it they have 3 or 4 options
to choose from - nice a simple - not confusing for anyone on where to
go or what to do.

On that i was going to add a form to fill in details on clients. Then
from the information that is added in that goes to a table.

Such as Name, Number, DOB, location will be filled out for each
client. Under that - 10 drop down menus to click on different jobs.
Each job goes into a seperate table aswell as one that includes
everything.

It sounds complicated - but if from the drop down menu, Child Care,
Retail and Admin are selected, the clients details automatically go
into a table for each one. Then from the switchboard, users can select
certain occupations and view all clients with that particular one
listed.

Is this possible to do or will it be too much of a hassel to create.
Its for work, we've been using something in Excel but looks crappy and
theres so much scrolling etc to tick everything. Im looking to create
something that will be quick and easy to enter info and to see it in a
hurry etc.

Any help will be appreicated.

Thank You.

 

[scubadiver]

Taking a huge step backwards (and I mean huge) have you sorted out your
tables and relationships?

 

[sea_minerals]

Taking a huge step backwards (and I mean huge) have you sorted out your
tables and relationships?

--

http://www.ready4mainstream.ny911truth.org/index.html













- Show quoted text -

Nope, i dont think i have. Im really new at Access.

I am unable to add any information - on clients etc - other people
willl be doing that. I just need to get a layout/database design up
and running but its proving harder than i thought.

 

[Wayne-I-M]

Try this link

http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033

Good luck

 

[scubadiver]

What is the database for?

 

[sea_minerals]

What is the database for?

--

http://www.ready4mainstream.ny911truth.org/index.html







- Show quoted text -

The database is to keep a list of clients (i work at an employment
agency) to keep track of what type of work they are seeking.

So, in the end im hoping to be able to add an entry - add name, dob,
suburb, id, manager, licences and then have 10 drop down menus that
each have a list of about 50 jobs. People can select up to 10 jobs.
Then in a table for each of those occupations (there'd be over 50
tables) have a list of all clients that want that work. So client
names and details maybe in 10 records.

We can call up a table for a certain job and view all clients that are
interested in that work.

thank you.

 

[sea_minerals]

Try this link

http://office.microsoft.com/training/training.aspx?AssetID=RC06118138...

Good luck
--
Wayne
Manchester, England.







- Show quoted text -

Thanks! I'll give it a go!

 

[scubadiver]

So, in the end im hoping to be able to add an entry - add name, dob,
suburb, id, manager, licences and then have 10 drop down menus that each have
a list of about 50 jobs. People can select up to 10 jobs. Then in a table
for each of those occupations (there'd be over 50 tables) have a list of all
clients that want that work. So client names and details maybe in 10 records.

We can call up a table for a certain job and view all clients that are
interested in that work.

-----------------



As far as I can see you only need three tables (but you can include a fourth
table to categorise jobs by industry)


Table for jobs
Table for employers
Table for jobseekers

Each job seeker can have many employers
Each employer can be seeking for many job seekers

Jobseeker -> jobs <- Employers

tables:

tble_jobSeeker
JobseekerID (PK)
Name
Address
Telephone

tble_Job
JobseekerID (FK)
EmployerID (FK)
JobID (PK)
JobTitle
JobDesc

tble_employer
EmployerID (PK)
EmployerName
Address
Telephone

 

[scubadiver]

tell a lie! This is what I have.

tables:

tble_jobSeeker
JobseekerID (PK)
Name
Address
Telephone

tble_Junction
JobseekerID (FK)
EmployerID (FK)
JobID (FK)

tble_employer
EmployerID (PK)
EmployerName
Address
Telephone

tble_Job
JobID (PK)
JobTitle
JobDesc