I am in the process of setting up a DB for my partners school.
I have student and class tables. I have these linked in a many to many with a junction table.
I am making a student data entry form and I cant work out how to add the student to the class.
Ideally I would have a combo box to select the class and then when one is selected a fresh empty combo box would appear beneath it.
I've been designing a database for a private school.
Every Student attends some Lessons in specific Classes.
To my knowledge I can meet the above requirement by using a join table
which holds StudentID, LessonID and ClassID,
or to have a join table StudentsandLessons which holds StudentID and LessonID
and another table with a one-to-one relation with StudentsandLessons which holds the ClassID for every Student-Lesson record.
The first way has the disadvantage of not allowing null values for records.
This is a problem for me, because in the school the want firstly to enter Lessons
and afterwards - when Schedule is ready to - enter Classes.
I thought a solution to the above restriction could be the Classes field to have a default value e.g. NoClassYet but this isn't aesthetically correct for me.
The second way overcomes the above restriction, but it doesn't seem "programmatically " correct to me.
Any ideas would be far more than just helpful.
Thank you in advance
I have two tables. The first one lists all of the courses that a student has taken. The second table list all available courses. I need a query that will tell me which courses the student has not taken. I tried using the find unmatched query to no success. Any help will be greatly appreciated.
View 5 Replies View RelatedFirst I want to thank everyone who sent me a response to my original problem. Unfortunately I still have not been able to get the results that I need. So for those new individuals who may have missed my original thread I will try again:
I have 1 table (Student Records) that looks like this:
Last Name, First Name, Class Title, Completion Date
And I have a 2nd Table (Course List) that looks like this:
Class ID, Class Title, Frequency
What I am looking for is a query to tell me which of the classes in the table Course List are not in Student Records Table. Basically I needto know which students haven't completed a course.
Any help will be appreciated. Thanks
I have a new scenario today! I have searched database design to try to figure this out and have an effective database as well as adding multiple records to one table that is linked to 1 record in the other table.I have a master student list with their information that has the fields
Student ID
LastName
FirstName
Address
City
Zip
Community
I have another table that has the fields
ClassName
Date
Community
Instructor
What I would like to do is be able to create a form that can add multiple classes for each student. For example, I have Student 1. Student 1 has attended class A, B, C, and D. I would like the form to have the student's name and ID with a way to add multiple classes linked to that student.
Hello everyone,
I tried to post this yesterday but it didn't go through for some reasons.
I've attached my database that contains student, classes, and couple other tables. I also created couples of forms and I wanted to register a single student to multiple classes at once.
For example: There're 3 classes (Math, English, History) on 1/3/2006. Student A wants to register 2 classes, Math and English. I should be able to check those two and submit and I'm done.
Currently, I have to select Math and assigns to student A, then select English. That's not good at all. What if there're 10 classes in one day and a student just want to register 8 classes? I have to do eight times.
It'd be great if you could help me. Thank you in advance.
Isabel
Hello,
I'm interested to know how I can select a (1) student and assigns to multiple classes.
Attached I have the database with some tables and forms. Please take a look. I can assign a student to a class, on a specific day but I couldn't figure out how to select multiple classes at once.
Thank you for your generous help.
Isabel
Ihave created a table that contains student name, last name address and GPA. THe instructor asked :You must find all the students that have a GPA of 3.0 or greater. Sort them so the highest GPA is the first student in the query.
View 1 Replies View RelatedHello gang!
I've read through many of the threads relating to sending Email from Access but can't seem to find quite what I'm looking for. I work as a Tutor Coordinator at a local college and I've set up Access to handle a lot of the day-to-day chores that our administrative assistant has to deal with.
One feature that would be absolutely wonderful would be to create and send Emails to students at the click of a button. I have several types of Email I'd like to be able to set up, but the one most needed (and probably most complex) is this:
Students come in to the office and request a tutor. If we have a tutor available, we assign them to an available tutor. If there is no tutor availabe, then every Friday we send out an Email to each individual student saying something like this:
"Dear John Doe - We currently do not have a tutor for MATH 101 at this time, but when one becomes available we will let you know... blah, blah, blah..."
I'd like to set it up so that the body of the message comes from a template - such as a text file (that is easily edited by a user) and populated with fields from a query.
Probably do something like this:
Query the Student_First_Name_field, Student_Last_Name_field, Department_Name_field, Course_Number_field, and Student_Email_field. Send an Email to each Email address pulled from the Student_Email_field and tell them the following - "Dear <first name, last name> we currently do not have a tutor for <department name, course number> at this time... blah, blah, blah..."
Currently the way the administrative assistant handles this is to send each student an Email individually - manually creating each Email with the specific data needed. As you can guess, this is quite time-consuming.
I'm rather new to Access but have been a RDMS programmer (in PICK) for several years. I know what it is I want to do, but don't know how to do it in Access.
Any help?
Would the best way be to use text files for templates?
Can text files be set up with field codes (Access recognizes "<LAST NAME>" to be Student_Master_Table.Last_Name_field)?
I'm guessing this will likely have to be a Visual Basic loop that works with data from a query.
Help? *grin*
I have a simple database with 2 tables, students and progress. I need to set up my database so that when I create a new record for a student (using a form I've created) it automatically creates 4 new entries in the progress table using the ID I have generated in the form and a task number (1-4) for each of these entries.
Additionally, once all tasks are set to complete = true, I need to set the field "all tasks complete" to true. I'd like to do this all without vba if possible.
Hello,
I can't quite get my head around this - any help is much appreciated.
I have (amongst others):
tblStudents (containing basic info. name etc)
tblClasses (containing a list of studentIDs with classes they are in, so, for example, there may be 3 entries of studentid "1", each with different classes next to them, to show that studentid 1 is in classes: a b and c for example.
tblGrades (containing studentID and masses of fields with different grades for different subjects in.)
What I would like to do, is select the class name from a list (which I can do, no problem).
Open up a form listing all the students in that class, with all their grades next to them.
This SOUNDS simple - but I don't think it really is! I could just be having a VERY simple moment though too - if so, I apologise!
Thanks in advance!
I have this formula for counting age groups
TOTAL 29 - 31: Count(IIf(DateDiff("yyyy";[DATE_OF_BIRTH];Date())>=29<=31;1))
But id does not work, if I use between 29 and 31 also do not work
I need to get count (number) of all students that have 29,30 and 31 year of age.
I have one table that has fields:
[ID]
[STUDENT_NAME]
[BIRTH_DATE]
[GENDER]
and I neet to get in qry where students will be counted by age and gender
For example:
younger then 15
tolal: 20
male: 5
female: 15
15-18 years
tolal: 34
male: 12
female: 22
Can this be done in single queri or should I do it in some other way?
How can I plot a line graph for each students to show their progress in a term and per session in a class, in a subject.
Something that can be visibly seen to know how a student is doing in a subject or in a class.
i have 3 tables one for student information second for Van information and third is payment.
I want to know how to get the list of students not paid based on specific month which need to mentioned may b through a form.
I am trying to create an individualized revision timetable for my students.
Each student does English(En), maths(Ma) and science(Sc) and four additional subjects (Sub1, SUb2, Sub3 and Sub4).
Each of the subjects has produced 16 revision tasks. (Task1, Task2 ...Task16)
I currently have a number of excel tables:
Student details Table:
Name En Ma Subj1 Subj2 Subj3 Subj4
Revision details Table
Subject Task1 Task2 Task3....Task16
I would like to produce something like this for each student:
In week 1
Mon EnTask1 Subj1Task1 MaTask1
Tue SubjTask1 Subj2Task2 EnTask1 etc
But I am stuck with the query and the reports.
I'm trying to return a list of students in a particular team who have not attended a certain number of sessions at a gym, between two dates. For some reason i get the error. At most one record can be returned by this subquery. (Error 3354).
SELECT [Student ID], Count(*) AS ["Number of Times Attended"]
FROM Gym_Attendance
WHERE [Gym Date] BETWEEN [Forms]![SV_Attendance]![txtStart].Value AND [Forms]![SV_Attendance]![txtEnd].Value
AND [Student ID] Like
(SELECT [Student ID]
FROM Student_Sports
WHERE [Sporting Team] = [Forms]![SV_Attendance]![lstTeam].Value)
GROUP BY [Student ID]
HAVING Count(*) < [Forms]![SV_Attendance]![txtNo].Value;
I have a large database of students and parents which charts their weight, waist circ., lifestyle etc. When I then create reports, is it possible to change the colour of the entry so that I can differentiate between students and parents results? In other words, can I have all student entries in red and all parents in black, for example? At the moment, when I try to change the colour of one of these, the entire column changes to that colour and I don't know how to amend my reports to do this. Please see attached.
View 2 Replies View RelatedI am working a database that manages student's Records including marks for various subjects, but i would like to do the following on each of the students' report cards:
a) Display the marks for all the 12 subjects .This one i have done.
b) Display a total for all marks of each student.Done as well.
c) The problem is, i don't know how to display the position of each student on the individual report cards.I want to base this grading on the total marks obtained by each student in the same class.
I prepared students details in access, but when i look the form view students particulars looks automatically (like name, age, weight and address). But what i need is students details has to come after I enter the name.
View 1 Replies View RelatedHey guys I'm developing a DB to input satisfaction surveys and compute satisfaction levels expressed as a percentage. I am setting up the DB with 1 record=1 satisfaction survey. The record would contain the fields:Survey Quarter and questions 1,2,3, etc. The responses to the questions are in pulldown menu form with Yes, No and N/A. I've already set Yes to be read as 1 and No as 0. Now I want to add across the row (Questions 1-11) so I can complete the math and get a percentage for each survey. So far I have had zero luck accomplishing this. Any suggestions?
View 4 Replies View RelatedThis seems really silly but I cannot get this query to work.
In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to reassign these.
What I want the query to do is add the total time spent holding and email to the total time spent reasssigning by category.
What my query keeps doing, as I thought it would be as simple as adding them together is instead of ie:
130+1 = 131 it gives me 1301?????
The query is joined using Agent id and Category.
Help Please:
I've made a button on my form which adds a booking ID into the listbox, but it doesn't seem to work. This is my code:
Private Sub Command18_Click()
Dim BoI As String
MsgBox "Booking successfully added!", vbInformation, "Booking"
If Month(Me.Date_1) = 1 Then
ListJ.AddItem Me.BoI
ElseIf Month(Me.Date_1) = 2 Then
ListF.AddItem Me.BoI
End If
End Sub
If someone could tell me the problem, I'd appreciate it. Thank you. :)
Another simple question
I have 2 fields income and expenditure
i have a 3rd field disposable income
how do I get disposable income to automatically change when I input income and expenditure in a form
many thanks
ive got a database for tickets for a school play. how can i create a query that adds up prices from multiple records? would the total be displayed in a form?
View 1 Replies View RelatedI Have a field that I need to manipulate the data in.
sample data follows [Field9]:
1 to 1 (cover page)
1 to 3 (no cover page)
etc..
this field identifies number of fax pages sent, eg
“1 to 1 (cover page)” is actually 2 pages, an attachment plus cover page
“1 to 3 (no cover page)” is actually 3 pages, 3 page attachment without cover page
What I want is just the total number of pages in this field.
I have written two expression that dissects the field in two, left hand side gives me a numeric number of attachments and right hand side a numeric value for the existence of a cover page or not.
Expr1: Mid([Field9],6,1)
Expr2: IIf(Right([Field9],15)="(no cover page)","0","1")
Each individual expression seems to do the right thing, but I have been unable to figure out how to add Expr1 and Expr2 to give me total pages.
Any help would be appreciated
J/