Access Course/Student Database

50 pts.
Tags:
Access 2007
Access Database
Access Tables
Microsoft Access
I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see their courses and the certificate they are in. My question is: I need to create a form with drop-down's that will select a course then return a report with students that have not taken that course within that certificate. I have tried queries, macros, etc. I'm not as competent on Access 2007 as I was with the earlier versions. But I've been working on this for some time and can't figure it out. I don't know much about the codes. Could someone help walk me through this? I'm taking courses later this summer, but we need this information now! Thanks,

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • AccessFlunky
    I guess that a simple query may do the job but we need at least the table structure and relations to help you.
    0 pointsBadges:
    report
  • AccessFlunky
    The relationship is that the student is related to the course that is related to the certificate. Example: A Smith has taken 3 courses; Public Speaking, Early Vocal Development, and Speaking the Easy Way; and these courses are under the Certificate - Speaking. So the relationship is the in the table Certificate; Speaking would be a record. When you expand Speaking (the + sign on the left) the 3 courses would drop-down along with anyother course that might be offered under the Speaking Certificate. Then the same with students. Under all three courses, A Smith would be in that course. I need to retrieve, A Smith's complete address, phone number, email address to send him upcoming course information. We could be offering a new course under Speaking (How to Correct Lisping), and I want A Smith to be included in the new advertising campaign. But maybe J. Loves has already had that course and I don't want to include him. But J Loves has had Public Speaking also. When I do a simply query, I would still get J Loves because he has also taking Public Speaking. And I will get 3 A. Smith's because he has taken 3 course prior. I thought a query with a subquery would work, but it doesn't give me the data I need. I created a query for FullName then a query for Course asking for the course number then a query for FullName and Course to show only Full Names that are not equal in the 2 queries. Well that doesn't work. I get all the names listed twice. I've tried a union query also. Can't seem to make that work either.
    50 pointsBadges:
    report
  • AccessFlunky
    Thanks for your help. I figured it out.
    50 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following