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 Replies


ADVERTISEMENT

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

Student Database - Version: 2002 (10.0) XP

First of all, Offer my warm regards to all of u, I am new here and hope help and guide me

I am told to make a faculty database, and I am new in making databases with no experiences, but alittle bit femilar with coding and database concepts.

can anyone post the available student databases example in this forum

Thanks in Advanced



Edited by: LOG on Wed May 23 8:53:09 EDT 2007.

View Replies View Related

College Student Needs Help - Version: 2007 (12.0)

I am doing a final project Microsoft access and HTML or dreamweaver. I was just wondering how you can connect the two. I am fairly new at this. I would like to be able to type in a users name and then bring back the users information from the database. This necessarily doesn't need to be on a web server. Is it possible just to have this happen on a desktop rather than hosting it on the web.

View Replies View Related

Student / Pupil Attendance - Version: 2002 (10.0) XP

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.....

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

Creating An Student Examination Database - Version: 2003 (11.0)

I was ask by my fellow Instructor if it is possible to a database in Access for the students examination. So now I'm starting building it.

But I need some suggestions from you guys (UA's Members).

Any suggestions will be very much appreciated. Thanks

View Replies View Related

Student Tracking Database: Do I Need Another Table? - Version: 2003 (11.0)

So, I have been working on this for a while. I'm new to the whole database thing. I am writing a database that is going to be used to track student progress in their school application process. So far I have:

tblHighSchools
idSchoolID
chrSchoolName
lnkSchoolWebsite
--you get the idea

tblStudentInfo
idStudentID
numYear
chrHomeRoom
--etc

tblSchoolRequirements
idRequirementID
chrRequirementName
chrDescription
numSchoolID
--each school has different reqs and a different amount of reqs. it seemed easier to just push that out of tblHighSchools

tblSchoolReqStatus
idSchoolReqStudentStatusID
numStudentID
numSchoolID
numRequirementID
blnCompleted (this is supposed to be a boolean)
--basically i needed a new "instance" of SchoolRequirement for each student, so this seemed to be the easiest way

I setup all the relationships.
my main next goal is to use cascading combo boxes so that I can select a student, then select a school, then see all the requirements for that school and if the student has completed them or not.

questions:
1. is this design correct?
2. what the *&%$ do I do next?

View Replies View Related

Need Assistance With Student/Class Management Database. - Version: 2007 (12.0)

I work at a Dive shop as their IT guy (I do all the networking, routers, and such). I have no background or training in access, i've never used it. Well the guys that run the classes at this store track everything with a dry erase board and it drives me crazy because I know there is a better way to do it. So I sat down in front of access thinking it would be much easier than it really is. I have the basic layout made and functional but I'm have a hard time doing certain things. I guess I'll just throw out a list and see if anyone has some spare time to help out.



1. If someone goes to add a new record, such as a new instructor and they partially fill in the record but realize they are in the wrong screen, they click 'main menu'. But the database saves the partially filled in record anyways. I don't know how to stop that.



2. When you go to add a student there are two drop down menus for 'class type' and 'convening date'. Right now it brings up a list of ALL the class types, not just the one there are scheduled classes for, I want it to be only the scheduled classes. Also I want the convening date to relate to the type of class selected in the 'class type' box, not all the convening dates for all the classes.



3. I want someway to have a search function by any of the variables in the database. I also want someway to print up a class roster.



I'm sure this all sounds confusing but I have attached the database and if you open it, it will make more sense. I really appreciate anyone that will help me with this!



Josh



File is an Access 2007 Database compressed into .RAR, then compressed into .ZIP to have a compatible format for this message board.

Edited by: igotag on Mon Jan 21 10:19:24 EST 2008.

View Replies View Related

Please Guide Me How To Design The Table Between The Student Weig - Version: 2003 (11.0)

Good evening. I would like to know how to design the table for comparing the data between students' height, weight and their sex. for example
tblStudentWeighHeight
id---------sex----weight----height----age
01245-----1--------50---------131------15
01246-----2--------41.5-------120------14

I would like to know how I can match the student table with the rating about height and weight that can be showed that my student are thin, or fat. Thank you very much.

This for boy's students.
StudAge StudWeight StudHigh StudSex
10 26.4 131.0 1
11 28.6 135.5 1
12 32.9 141.2 1
13 37.0 148.5 1
14 41.3 155.0 1
15 46.8 160.5 1
16 50.3 164.0 1
17 51.2 165.0 1
18 53.0 165.3 1
19 53.5 165.4 1
20 53.7 165.5 1

This for girl 's students.
StudAge StudWeight StudHigh StudSex
10 26.8 132.0 2
11 30.5 138.0 2
12 35.4 145.0 2
13 39.8 149.8 2
14 43.0 152.3 2
15 45.0 153.9 2
16 46.7 155.2 2
17 47.3 155.3 2
18 47.6 155.4 2
19 47.6 154.4 2
20 47.7 154.4 2
Thank you very much.

View Replies View Related

Check My Design For A Db To Track Student Apps For Schools - Version: 2003 (11.0)

okay, this is my third post. I think I needed to take a step back, and so I am asking people to review my db design.
okay, its a middle school. each student must apply to multiple high schools. different high schools have different requirements such as essays, recommendations, transcripts, etc. here is what i have so far:

tblSchools:
school name
website
application due date
response date
you get the picture

tblStudents
this has general info on each student

tblSchoolRequirements
RequirementName
Description
SchoolID
I took this out of the schools table because different schools have different requirements, and creating fields for things that a lot of schools wont even use seemed wasteful (plus someone on here told me to!)

tblSchoolReqStatus
StudentID
SchoolID
RequirementID
boolean for completed? yes/no

i used to have a tblSchoolApp, but by taking out the requirements it seems redundant.
now i need a way of meaningfully displaying all this info.
how can i create a form that will show a particular student, what schools they are applying for, and what things they have completed?
I have already setup the relationships but am unsure what to do next.

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

Student DB - 'School Quarter' Table And Form Advice/Help - Version: Any Version

I am stuck once again...

Students > Quarters > Courses

There are 4 quarters in 1 school year.
Each quarter is filled with courses.
Some quarters last more than one quarter.
Some don't.

I have my DB setup for students <-> courses with a junction table (M-2-M). I thought this would suffice, but I realized that I cannot differentiate courses in quarters.

Example:
StudentA takes Math, Reading, Science in all 4 quarters while PE is for the 1,2,3 and Health is in the 4th Quarter.

I have thought about and researched this for days now...

Maybe, radio buttons, list or combo box with 1st Quarter, 2nd Quarter, 3rd Quarter, 4th Quarter. Once a Quarter is selected, a subform is available to be populated with the courses needed in that particular quarter. (?) The quarter selection "toggles" the view for the courses, in their respective quarters.

How would I modify my tables and design? I do not know where to start with the buttons "toggling" the courses by quarters...

Any thoughts, suggestions, help? PLEASE.

Togarashi

View Replies View Related

Student DB Needs A "link" For Siblings - Version: 2003 (11.0)

I have got the DB almost right where I want it.. but after a meeting with the school faculty someone mentioned being able to look at the students record and know right away if they have siblings and to view their info such as Name, Class, and Grade for the simple reasoning that special notices are usually sent to the eldest child in the family. The info such as Name, Grade and Class are just there to note where the child will be and where to deliver the notice.

I have a students table, collecting info on the students.

Is there a way I could flag or list siblings?

Any ideas or suggestion anyone has will definitely be appreciated.

Thanks.

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

DB For Resident Registration - Version: 2000 (9.0)

Hello all,

I was asked to make a Resident Registration DB, can anyone please give me a good start, or if there is a sort of db sample..

Any help would be appreciated,
rj

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

Is There A Way To Make A Program That Requires Registration? - Version: 97 (8.0)

I am currently developing an ongoing project that requires a registration code.
I want to know if there is a way to do a multi-level registration in access.
For example, could you have Free 30-day-trial, a Home edition and a Pro Edition. Just as an example though. Another thing I would like to know is if there is a way to actually have different codes for each user and have them enter something like their name, orgainization and a special registration ID along with their registration password; with the registration ID being a special code made by the computer (like the hard drive serial number or something like that) and the registration password being a code made up of some kind-of one way encrypted version of the name and orgainization.
I am very new to techniques like this and really have no clue what I'm doing. Please help me!
Cheers!

View Replies View Related

Registration Key Based On Server - Version: Any Version

I'm attempting to generate a registration/activation key that is based on concurrent users. Please let me know if any of the following has holes in its logic or that there is a better way to do it. Any links of other threads doing the same thing would be appreciated.

Registration Key
1) Customer Name (This will show on all report headers.)
2) Server Name (Using this code to get the server's name.)
3) Registration Date (Current Date)


Activation Key
1) Same as above
2) Same as above
3) Same as above
4) Expiration Date
5) # of Concurrent Users ($ per user)

Most registration keys that you see are based on the customer's name and/or a workstation's hardware id. Because we are selling our application based on concurrent users we don't care how many workstations have it installed. We only care about the number of concurrent users.

I decided to use the Server Name to prevent companies with multiple locations from installing it at their different locations. Does anyone see a problem with using the Server Name for this purpose?

I have a table that stores when the user logs in and logs out. I also used this code to periodically check and make sure that a user didn't exit the program with "Ctrl+Alt+Del" or some other improper shutdown. It marks the user as logged out in tblUserLog and marks that it was improperly logged out. When a user attempts to log in the db checks the number of users currently in tblUserLog and if it exceeds the # of concurrent users in the Activation Key then it tells them that someone needs to log out before they can continue.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved