468,117 Members | 2,007 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,117 developers. It's quick & easy.

Need a little guidance (beginner)

I'm quite new with Access so please bare with me. I'm pretty sure what
I'm looking for will require the integration with VB to function
properly.

Here's what I have:
Portfolios for inviduals who have taken part in courses at this
department.

Information includes:
Name (First/Last)
Phone (Work/Home/Cell)
Address (#, street, postal code, city)
Position/Classification
Exercises completed

What I need to accomplish:
I need to create a front-end/database whereby an individual can input
searches based on: Name, location (city) or exercises(preferably a
drop-down menu for the last two).

The output for Name would result in thier contact information/position
being displayed as well as the exercises they have completed. It
doesn't have to use 'Like' to acheive this because I can specify that
the exact first/last names be inputed.

The output for Location (again preferably a drop down list).. would in
theory optimally give me a list of individuals from that location by
name. The names could then be selectable leading to the output from
the name search criteria above.

The output for Exercises (drop down selection) would give a list of
names of individuals who have completed that exercise. This would work
as above and be a selectable interface.

I know this sounds like a daunting task for a beginner, but I have had
some experience with VB/Access in the past and I'm sure I'd pick up on
it quickly. There's no real deadline for this database, just something
we've been wanting to do for a while.

If you could point me to where I can find resources or examples
similiar to what I'm requesting that would be great.

Thanks,
Nate

Nov 13 '05 #1
3 1351
I should probably also note that there are no distinct primary key
references I can assign for each individual (ie. no course reference
#s, no personal id numbers). All I have is the text information I
listed in the first post.

Thanks,
Nate

Nov 13 '05 #2

I might do this as a standard students-classes database.

student--(1,M)--ClassRoster--(m,1)--Class

Exercise--(1,M)---ClassRoster(you may need an alternate PK for that)

Daunting for a beginner, yeah, but surf around for schemas for this. I
am almost positive there's one in Elmasri & Navathe's book if you're
doing this in school or something. Either that or search this NG or
the web for a students-classes schema. Once your db is set up right,
the rest of the stuff you describe is a walk.

Nov 13 '05 #3
well, that's a BAD thing. No PK's mean no really easily maintainable
relationships and why use a DB without tables and relationships? I
mean, you *can* query Excel. for some stuff it's great, but for a
database, it aint.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by new_GUY | last post: by
17 posts views Thread by EkteGjetost | last post: by
2 posts views Thread by Jamie | last post: by
3 posts views Thread by vijaykokate | last post: by
4 posts views Thread by GW | last post: by
6 posts views Thread by PythonBiter | last post: by
3 posts views Thread by trfilmographer | last post: by
6 posts views Thread by lgerhardx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.