Student Log in/out database

[fhenderson]

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.

 

[pbaldy]

Welcome to the site. As an FYI, most of us work best with more specific questions. If you can provide a specific problem you're having, we can probably sort it out. It would also help to know your table layout (perhaps even a sample db to look at).

As food for thought, I wrote an app for the university here (helps when you're friends with the Director of IT; you get some side jobs). One thing I incorporated you might think about is a card swipe unit. All the students have cards anyway, so all they have to do is swipe their card. In your situation, you could check to see if they're already signed in (programmatically). If not, sign them in, if so, sign them out. Saves the trouble of them filling in their info to sign in, or finding their info to sign out.

 

[fhenderson]

Hello. Well there is one form. This form has fields for the students firs and last name, curent date and time, check boxes so the student can select resourses used and courses worked on and a comment field. As far as I can tell there are only two tables that are being used. The student table and the tutor table. The student table is the one that is updated depending on how the student fills out the form. It cantains these fields:

UserID
Student First Name
Student Last Name
Tutor
Date
TimeIn
TimeOut
Then come the courses I wont type them all out here but there are nine. After that there are the resources fields and then the comment field

The form also cantains three buttons, one to go to the previous record, one to go to the last record, and one for a new record. If the last record is shown on the form the student can click the new record button to clear the form and make a new record for themselves. This how the student sings in. Once the student is finished they type in the out time and leave. The student table is updated with the info everytime this happens. Oh there is also a tutor table with just the names of the turtors. Theses two tables are linked together in relationships (one-to-many). My task is to split the form and have two instead of one. The first form will have only first and last name fields, time and date and a list dislpayed with all the students that are currently signed in. Once the student is finished, they can then select themselves from the list rather then having to sift back through the records to find themselves. When they have selected their name from the list they will then click a button that will take them to the second form which will look like the first except it will have the check boxes for the resources and courses and comment box and without the list from the first form. When they have made all their selections they will click a button that will add their info to the table and take them back to the first form. Well there it is. Sorry its so long but yuo to be specific. I cant upload the database because it is 1KB to big . I am becoming very desperate and frustrated with this and really hope that someone can help. If anyone thinks that this post should be in another area please tell me and I will move it. Thanks everyone.

 

[Rabbie]

I cant upload the database because it is 1KB to big . I am becoming very desperate and frustrated with this and really hope that someone can help.

Have you done a compact and repair on the DB and zipped it. If necessary delete some records from the DB.

 

[fhenderson]

Yeah didnt think about that. Here it is

 

[rubieufl]

I'm on the same boat as you. Have you figure out how to do that I help your help if you can. . Can you send me that data base so I can study them thanks

 

[dTskrill]

Welcome to the site. As an FYI, most of us work best with more specific questions. If you can provide a specific problem you're having, we can probably sort it out. It would also help to know your table layout (perhaps even a sample db to look at).

As food for thought, I wrote an app for the university here (helps when you're friends with the Director of IT; you get some side jobs). One thing I incorporated you might think about is a card swipe unit. All the students have cards anyway, so all they have to do is swipe their card. In your situation, you could check to see if they're already signed in (programmatically). If not, sign them in, if so, sign them out. Saves the trouble of them filling in their info to sign in, or finding their info to sign out.

I need to create an app where individuals sign in and out with bar coded cards. The information needed to be listed would be last name, first name, status (in/out), Building number, Room number, and have a time and date stamp. is there a template you could point me in the right direction with?

Thank you,
dTskrill

 

[pbaldy]

I don't know of one offhand. You might see how close the sample posted to this thread is.