Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Student Registration And Student Cources


I have designed a form where you enter all of the student data, and I have designed another form in which you select student name the cources they are taking and all of the information related to the cource.

my problem starts here, for example I had student A take english cource this summer, once the the summer is over the student doesnt come to school untill the next summer.

I allso have a report reads student cources data and tells me when each student is due to pay, and the main hassle starts here. If the student doesnt come to the school at the moment, I dont want him to appear on the list of due people. And the only way to completly remove him from the list of due people is to delete his student cource record, if I just delete the due date then the student appears on the top of the list.

And allso if the student comes back and wants to take english again, it is a big hassle to find his record, and sometimes whem I miss the record then I create a new one and the database is filled with extra unused entryes.

My question is there an easy way to merge student registration with student cources so that I could keep all of the student cources data in student registration and make it available to each cource to choose active or inactive and allso to keep for each cource grade history and payment and so that and I choose that the cource is inactive it will not show up in the list of student dues. The screen shots of the 2 forms and the due list report is in the attachements.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Student Log In/out Database
Hello everyone. I am a new member and need help with a database that I am working on. Let me first say that my knowledge of Access, SQL, and databases in general is very limited. I work in the Academic Success Center at my college and they use an access database for sign in/out. My job is to redesign this database so that there are two forms instead of one. The first form will just be the first and last name of the student along with the date and time that are generated automatically. Currently the student must type in there info and when they are done working in center they must sift back through the records on the form to find their sign in info and type in a sign out time. My task is to make two forms one that has just the students first and last name along with the current date and time. This will be the student sign in. Once the student is done they should be able to find there name in a list of currently signed in students, select themselves, and be taken to their sign in record. The student will then be required to click a button to be taken to the sign out form which will automatically fill in there name, date, and current time not sign in time. The will then be required to select the resources that they used and what courses they worked on and any comments if they wish. Once they have filled out everything they will need to click a button that will close the sign out form and update the student table with their info. The actual design of the forms is not the problem, the problem is getting all of this to function the way it is supposed to. When I fist agreed to this it really didnt seen like it would be that difficult but apperantly it is, I am becoming very frustrated and desperate. If anyone can give any help at all or point in a direction that will help I would greatly appreciate it. Thanks in advance, and sorry to be so long-winded.

View Replies !   View Related
Student Exams
Hi all! First time posting here. I hope u will help me :o I'm trying to set up a database regarding student exams. It should have the following tables: 1. personnel name, 2. parts of exams (part I, II, III, IV), 3. Semester (May, Nov. Year), 4. Success results (pass, fail, absent). Is there something u can propose to me? Thank you very much.

View Replies !   View Related
Calculating Student Fees
I am handling a group of students and I want to calculate the fees coming from the student. Does anyone knows how to develop a tables and forms in microsoft access?

View Replies !   View Related
Any One Willing To Help A College Student Out For Paypal.
Probablly easier for me to explain via email. I have a class assignment due ASAP, and I am completely lost.

Thanks in advance you can reach me on yahoo.. Marketsharez@yahoo.com

View Replies !   View Related
Student Database Design
Hi folks,

I'm building a database to store student exam results so that transcripts can automatically generated. This is a final year project for university so the database will never be used. I am a complete amateur when it comes to designing databases.

20885

I have attached the relational schema for the database. I'd be grateful if someone who knows about proper design could tell me if its ok (from the point of view referential integrity and normalization etc).

I'd really appreciate helpful comments.

Regards,

sabatier

Just to explain a few things:
1) In the OverallMarks table, MarkType refers to whether the overall mark (i.e. 1st honours, 2nd honours) is for JF (Junior Freshman), SF(Senior Freshman) and so on.
2) In the ExamResults table, YearOfStudy refers to JF, SF, JS or SS. Year refers to the actual year the exam was sat e.g. 2007.
3) The data in the database will be coming from Excel spreadsheets, so my database will not be doing any calculations on the data. That's why I'm storing the overall mark instead of calculating it from the ExamResults table.

View Replies !   View Related
Multiple Tables Per Person (student)
Hi

I have a DB for students.
I'm making notes each time we've had a chat.
Is there a possibillity to make a relationsship between 2 tables so I can make multiple records for one person? (or any other way)
For ex. 03-04-06 there were a couple of things I wrote down.
and 03-06-06 there were some other things I wrote down about the same person.
and then I will be able to backtrack this information
How do I do this.

Mikael

View Replies !   View Related
Pupil / Student Attendance / Register
This idea has been sending me nutty for months!

I’m a travelling music teacher. So my many pupils are split into many small groups (of 1, 2 or 3 pupils).

What I want is to open a form with lesson details. I’d select a date and then a group and then the details of the pupils in that group would come up (probably in a subform). I could then enter data for each pupil for each lesson e.g. whether they were absent.

That’s it!

My current tables are

[pupils]
pupilID (pk) (autonumber)
pupilname (text)

[groups]
groupID(pk) (autonumber)

[lessons]
lessonID (pk) (autonumber)
lessondate (date)
group (text)

[pupilinlesson]
pupilinlessonID (pk) (autonumber)
group (text)
pupilID (number)
absent? (Y/N)
lessonID (number)

This last table is supposed to store the data of each pupil in each lesson.

Relationships

[groups]groupID 1 – M [pupils]group

This is probably quite easy for someone who knows how. Lots of people must need registers of pupils!

Thanks

View Replies !   View Related
College Student Struggling With Simple Combo Look Ups Arggh!
Hello people,

I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!

For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...

e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...

The relationships are all ok, the fields for Student ID are lookup, etc.

I don't understand. It's driving me insane. I need help with this, I'm struggling so much.

Help much appreciated.

Thanks - Neil.

View Replies !   View Related
College Student Needing Help With Lookup Combo Boxes
Hello people,

I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!

For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...

e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...

The relationships are all ok, the fields for Student ID are lookup, etc.

I don't understand. It's driving me insane. I need help with this, I'm struggling so much.

Help much appreciated.

Thanks - Neil.

View Replies !   View Related
Register A Student To Multiple Classes (forms, Combobox, Checkbox, Listbox, Query)
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

View Replies !   View Related
Register Multiple Classes For A Student (form, Combobox, Checkbox, Radio, Listbox)
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

View Replies !   View Related
ActiveX Registration
Hi
Pls anyone can give some suggestion
I am trying to add some flavours to Access using self created DLL from VB6 or VB2005 without any luck
The DLL has been written by me in VB6 and when registered in Access using Tools - ActiveX Control - Registered control is not available and not part of the ActiveX Control list.
Can find in object browser search and can declare it.
I have also tried to the same but using VB2005 version, this time Access responded with a message that the dll could not be added/deleted. Install/remove the control using a separate setup utility.
…………..hmmmm.

I have tried Regsvr32 still the same.

Can anyone help!?

Thanks for any input

View Replies !   View Related
Conference Registration
Hi,

I'm looking for some basic ideas on how to change the registration proceedure for my company's conference from a basically all paper endeavor to an online form.

Would it be relatively simple to put a form on our website asking for basic information (Name, Company, etc) that would output into an MS Access file? Are there technical issues / problems that would make this very difficult?

Thanks,
--Jim

View Replies !   View Related
MS Access 2.0 Registration Interface
Is there any software available so that I can create registration and activation codes for ms access 2.0 application on runtime

View Replies !   View Related
Event Registration Bulk ListBox
Hello im new to this forum and I just recently became involved with access so please bear with me and my many questions. I work for a mining company in Canada and we have training events. These records must be kept showing who attended and what was covered.

I have used the event template and contact template and merged them into one to I have a listing of all employees and their personal information. I have another table with events that say what was taught or shown and so forth. I am trying to figure out the best way to have them register for these events.

Right now I have right now a registration form that has the employeeID and the eventID. The problem is I would like to be able to use a list view and just select the people who attended and with the press of a button have all the registrations be completed dynamically. As right now for each person I have to create a new entry. Hope I was not too confusing, and thanks for the time. Patrick

View Replies !   View Related
Planning – Adding Time Management/registration
Hi all,

I’m adding a new function to our Costumer Relations Management system – Time management. Or maybe “time registration” is a better definition for it. The idea is that our consultants can add their hours into our CRM, either from the “Project”, “Tasks” or “Costumer” part of the CRM. Note: This is a tool to keep track of hours spent on a project, not a planning tool.

I’ve made the input-form for the records (Date, ClockStart, ClockStop, TimeSpent, InvoiceHours, etc.). But now I’m basically without a clue on where to start – I want to make a function almost like the calendar in Outlook, where the consultants can input what they’ve been working on, say between 13:00 and 14:00.

It doesn’t have to be fancy graphically, but functional and give a good overview.

Any ideas?

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved