Creating New Records For Students?
Jan 23, 2013
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.
View Replies
ADVERTISEMENT
Nov 8, 2013
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 Related
May 18, 2005
Hello 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*
View 3 Replies
View Related
Sep 2, 2015
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.
View 4 Replies
View Related
Jun 13, 2005
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!
View 1 Replies
View Related
Oct 31, 2006
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
View 6 Replies
View Related
Sep 17, 2013
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.
View 5 Replies
View Related
Sep 16, 2013
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?
View 2 Replies
View Related
Jan 7, 2014
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.
View 2 Replies
View Related
Jun 23, 2013
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.
View 1 Replies
View Related
Mar 11, 2014
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.
View 5 Replies
View Related
Sep 2, 2013
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;
View 1 Replies
View Related
Oct 7, 2011
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 Related
Sep 2, 2012
I 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.
View 3 Replies
View Related
Oct 25, 2014
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 Related
May 24, 2005
Hi
I wonder if anyone can help. I attach a table that is a material list (27000 records). When I add a new material I want to be able to see the last part code I created for a particular supplier.
For example C001, C002 and C003 are for a supplier company called Chapters so I would scroll through the combo box search list in the form for the last one and create a new record called C004. The problem is that E00001, E00002 for a company called Edwards supplies 20,000 items so it's a long way to scroll through to create a new part code called E20001. How can I show in the form what the last part code is for each Supplier?
I attach the form and table as I'm not very good at explaining this, although I have had to delete approx 20000 records as the database was too big to be posted. Any advice/help would be greatly appreciated, many thanks
View 1 Replies
View Related
Nov 23, 2005
I have a database in which i keep track of my books collection. Amongst my tables i three of them are:
tblBooks - main books table
tblKeywords - where i store keywords (such as "database", "programming", "web development" etc)
tblBooksKeywords - to create a many-to-many relationship between the above two tables.
Now in tblbooks i have about 270 records (1 per book). Now for each book in this table i would like to create a record in the tblBooksKeywords table to add a the keyword "Computers" to each book.
i.e.
Book1 - Computers
Book2 - Computers
and so on till Book 270
Now rather than i do this manually for 270 records is there a way in which i can create these 270 records automatically ?
Thanks
View 5 Replies
View Related
Sep 28, 2006
I think this is a pretty simple thing, but for some reason I'm lost.
I need to add a number of records to a table.
The user would input a starting record number and ending record number (ie 60000, 60003) and access would create those records with the record number field populated with all the values, in other words, it would create 4 records 60000,60001,60002, and 60003
any ideas how this can be done? I'm thinking a query, but it might require coding of a for...next loop???
Thanks in advance for the help
View 4 Replies
View Related
Nov 11, 2004
Hi, im having a problem with shring my db over a networkt,
as far as i understand access 97 locks a page (2k) of records when a record is being edited,
does anyone know a way in 97 how i can get access to lock ONLY the EDITED record and not the page?
in Tools/Options/Advanced i have "edited record" locking clicked and each form locks only the record edited but its still locking the page, i know there is "record level locking" feature in Access 2002 but not in 97, is this possible?
thank you
Scott
View 1 Replies
View Related
Oct 15, 2007
Hey all,
I have two records for a list of employees: start date and end date. I want to create a query for the top 5 employees who have been employed the longest (and are still currently employed, so end date should not exist for the top 5). How should I go about this using a top values property? thanks.
View 1 Replies
View Related
Feb 3, 2007
I've got myself a little stuck!
I'm trying to create a database for our new theatre group. I've created a table for membership details (ID, Name, DOB, Address, etc.)
I want to create an attendance register - kind of the way a school register looks, so it will show on screen like a spreadsheet (names down the left-hand side, dates of the sessions across the top, and a grid for the attendance codes).
I know I could paste the membership details from Access to Excel and use a spreadsheet, but I'd like to keep it all together.
The attendance codes don't just contain present or absent, I would like to keep a record of payment 'P' or on holiday 'H' etc.
I'll keep searching and scratching my head, but any help would be appreciated.
View 1 Replies
View Related
Dec 17, 2004
Hi all,
I was wondering if anyone had code to split a field by semicolums, to create multiple records.The field has the first line of address for each property with a particular postcode.
For instance
field name:
PRMF
Craven House; Ample Mansion; WHSmith; Bulevard Terrace.
I want to be able to split fields like the one above with these properties by the semicolums so they become seperate records, but share the same other fields e.g. postcode, city...
Thanks in advance,
M-.
View 5 Replies
View Related
Dec 21, 2004
Hi,
still not sure how to split one field therby creating multiple records from it.
For instance:
split field:
PRMF
Craven House; Ample Mansion; WHSmith; Bulevard Terrace.
to
PRMF
Craven House
Ample Mansion
WHSmith
Bulevard Terrace.
I have made it a little clearer on the attached word doc.
The plan is to prompt the user to enter a postcode, then based on postcode an sql statement splits the fields of the field metioned with the criteria on a query. Any help very much appreciated, Thanks in advance.
M-.
View 2 Replies
View Related
Jan 25, 2008
Hi,
Firstly, I apologise if this has been posted before. I have done a couple of searches of the forums, but can't find what I'm after... and being new to access, I'm finding it hard to know what exactly to look for. How to even explain what I want is difficult!
I am designing a database for the clients we deal with a work. It started out as being a database of 'post' and correspondence, so the Idea was, we'd have a databse of all the clients... and by selecting their names, it would bring up a list of all the letters that have come in for them. I have managed this part fine - probably basic, but fine.
What I would like to do, is expand it to more than just 'letters'. Each client has done a particular 'work' with us, and each client has particular details that are unique. For example, a client will have made certain transactions through a bank account.
I hope to be able to click on a client, and have a screen or page pop up with details and comments about that particular client. I have tried hyperlinking but that doesn't really produce what I'm after. For example, I tried creating a "report" with a page for each client, so that I could have comments for each client - hyperlinked to the table. But all it does is link to the "whole report" and not a particular page for a particular client.
I'm sure this is sounding really confusing:
I have a client named "Peter Litman". His name and details are within a "client" table (listing all clients). I hope to be able to click on his name (or row) and bring information (comments, details etc.) about him. I thought this could be some sort of "pop up", or link to a special page. ??
The same would then apply with all other clients.
Any ideas? questions?
thanx.
View 2 Replies
View Related
Mar 8, 2012
There is currently a database which contains location information on a variety of different samples, each which is identified by a unique sample number (the primary key). However, when these samples are processed, they are split it half and each is assigned a second identifier for each half (in this case, an A or a B). Therefore, if originally there was sample 1, it will be split into 1A and 1B. My task is essentially to create a second database with further information for each sample half (1A or 1B), while maintaining a link to the main sample database to reflect any changes to the sample location information. So far I have been using a make table query that pulls from the linked table which links back to the main database and combines with another table that simply has one column called "Piece" which has an 'A' in the first row and a 'B' in the second row.
I am quite new to using access, but I have found this task fairly frustrating so far because it feels like I am trying to force access to work in ways that it was not designed. Essentially I would like access to create a duplicate entry for each sample in the original database, and force in an 'A' or a 'B', and combine these fields to create a unique identifier. However, I am running into a lot of issue when trying to append data from the original database etc.
View 6 Replies
View Related
Mar 13, 2007
Hi
I am writing mini database which will produce labels for boxes. I want to be able to produce a sheet of labels based on the 'number of labels' to print field. I can output one label or many on the page/s depending on how I structure the query and how many records are in the query.
My Question:
I need is a query which takes an individual record and duplicates it by the integer in the 'Number of Labels' field
any ideas?
thanks
View 3 Replies
View Related
