Access 2007 advice needed. Do I need a Form? Query? Both?

[ClareLou80]

Ok, so with some support and advice from this forum, the internet and various online tutorials, i have come so far with my first database, but now i need some more advice please.

1. I need to be able to enroll students on classes.
2. I need to see all the students that are enrolled on a specific class.
3. How do i get the Instructor ID to populate in the TblPEClasses? When i use the form, it doesn't update the table, even if i hit refresh?

What thought process should i be going through? What do i need to do this?

I have tried solving this myself, but getting nowhere fast.

My database feels like it is getting a bit out of control and i am getting a bit lost. I want to know HOW I do this as opposed to someone doing it for me, so please talk to me like I know nothing!

I know there are other issues with my database, but i feel i need to tackle them in manageable chunks, so if i can get my head around things...perhaps some zen will hit me like enlightenment.

Thanks for taking the time to read my post. Database attached to help it make more sense!

 

[ClareLou80]

ok, stressful day! NOW it's attached!

 

[JamesMcS]

Hi Clare - just had a quick look at this and your database structure seems OK, except the relationships look a bit complicated - they're all automatically created around the primary keys but there looks to be a few many to me, might be worth having a think about.

Anyway the PE Classes problem you're having is because the combo box you use to select the instructor is unbound - it needs to be bound to a field in your table so the field gets updated.

As far as seeing who's enrolled in what class, you'd be best off creating a query for that. Are you OK with that part of it?

 

[ClareLou80]

Firstly, thanks James!

Secondly, I can create a query, but i was only able to create one specific one, eg. show me all of the students in the golf class. Eventually there will be many classes, so i'd rather not create a specific query for each class. Is there a way to do it so as that when the query is about to run, it will ask you which specific PE Class you are enquiring about?

Also, the relationships do look complicated!!!! muh! if you have a simpler way to do it, please let me know.

thanks again

 

[JamesMcS]

You should be able to use the same query, but without putting any criteria in.

Let me have a quick look after lunch and I'll upload something for you to have a look at and understand how it works.

 

[JamesMcS]

Right then. Have a look at the query in this DB, and also a look at the relationships. You'll see there aren't any criteria in the query so it brings everything back. You can specify a course name, or use a parameter by putting something like

[Enter Course Name]

in the criteria for course name