Student Detention Database - Layout And Limit Via Date
Mar 4, 2012
What tables should i create that suits 'normalisation'? Do I need to do anything different if I intend to upload this to Sharepoint and have a sharepoint entry or Infopath component.?
How do I limit to only 25 Students on a given date?
Student Data is Imported in from Excel spreadsheet
Basic Access User, but need to move on from Excel UI's.
Starting up a database that will allow a teacher to add students to a detention roster on a specified date.
View Replies
ADVERTISEMENT
Aug 18, 2007
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 5 Replies
View Related
Feb 28, 2008
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 3 Replies
View Related
Nov 18, 2012
I am creating a student database in ms access2007 but finding difficult to go further. In my database, I have created the following
Student-info-table
SemesterTable
SessionTable
PaymentTable
Then a query from the payment that shows student I'd,arrears,amount due,paid. And balance
My question is
1.How do I transfer the students and their balance to a new semester and session
2.Do I have to new student and payment tables every semester bcos payment are made every semester
3. I want to keep each students payment for as long as they remain in the school
4. A session is made up three semesters how do I transfer students to a new session
May be my tables layout are faulty...
View 1 Replies
View Related
Dec 31, 2012
I'm in the process of constructing a student database for my school which would track (in addition to detailed student information) the daily attendance of over 270 students.
It is my understanding that there is a limit of 255 field names per table, so I can't use the student names as field names, nor can I really use dates as this would not quite cover even a year.
Student ID and AttendanceDate as field names is also not really a feasible strategy, as each week this would eat up 1300+ rows, so I would run out of space in that direction as well.
My question is ultimately am I better off building this in excel 2010, or is there a way of doing this in access that I have overlooked?
View 4 Replies
View Related
Sep 25, 2013
I am developing database for my school. I am done with everything except the examination aspect where i need to indicate students position in every subject beside their overall position according to the sum of all the subject scores. How to indicate student position in subjects.
View 2 Replies
View Related
Jan 13, 2005
I have an issue with a database layout and I am not sure which is the best way to proceed.
The problem is in an invoice part of a db . When a service is delivered, say 2 hours of a technicians time, it has to be assigned to a particular tech. No problem when there is only one tech however there could be two or more techs who have helped to supply this particular service and the time ( and income) needs to be divided up between them. However the invoice can only show one item the ie total time taken to deliver the service ( quite likely to be a fixed cost for a particular service ).
Possibilties I have considered are: to have a number of fields in the invoice detail table , one for each tech, however I would have to assume a maximum number of possible techs per job and also there would be a lot of redundant fields and trying to analyse how many hours each has worked would be painful.
Each tech could be assigned a code ( single number or letter ) and these could be stored in a single field . The code would then have to be manipulated to work out how many techs worked on each item and how much each had worked. Again this is rather messy.
I think the ideal would be for each tech to have their own table where each time an service was invoiced which they helped delivered the appropiate percentage is assigned but I cant quite see how to do this.
Any ideas or examples gratefully recieved
View 1 Replies
View Related
Nov 15, 2005
I have designed a few databases for my work. I have been recently assigned a new one that has me a little stumped. I am looking for some suggestions as to how to go about this.
Essentially, we have a training department that does training in the various aspects of the job. In the various classes, the "students" take a midterm exam to gauge the level of retention of the training midpoint in the class. Then at the end of the class, they need to take a final exam.
My department director would like the "students" to be able to take the exams using Access, since 99% of the questions are either multiple choice, yes/no, true/false, or fill in the blank, and Access would be able to "auto-grade" the tests, essentially.
I am at a loss, basically, as to the layout. The "student" information table would be the easy part. I am unsure of how to create the tables that would have the questions, depending on the class and whether it is a midterm or final, with the answer choices attached.
Any suggestions?
View 1 Replies
View Related
May 24, 2006
ok, someone please clarify this for me..
i know about normalisation and data redundancy..
therefore i will lay out my database like so..
job id
job date
job time
job id
driver id
driver id
driver name
driver phone
job id
payment id
price
etc...
this is all fine..
in the most straightforward situation, you create a form based on a table...
now if i create a query with fields from all the tables.. eg..
job date, job time, driver name, price
if i create a form in the basic way, you cannot add fields from several tables (in the direct sense i mean, forgettin the use of subforms.. etc)
if i create a form based on the query, will this allow me to add as many fields, and most importantly from as many tables, as i wish.. choosing only the relevant ones for that particular form..
will everthing automatically link with the job id if my user fills in this form..
if this is the case then i can see my self making one large query.. with all the relevant job details, and then using a tabbed form to separate them.. is this a common practice.. is this the correct way to go about things?
View 5 Replies
View Related
Jul 20, 2015
I want to track inventory. All our items are tubes that are stored in boxes in a 10x10 grid. So I have a single access table with columns for tube ID, box ID, and position in the box (numbered 1-100). That works fine in terms of 'where can I find tube x'. However it's also useful to be able to look at the physical box & check that there are tubes where should be tubes, and empty spaces where there should be empty spaces. So for each box in the database, I want to print out a 10x10 grid, with the appropriate tube ID's in the appropriate place. Then I can easily check the layout in the database against the layout in the actual box.
View 14 Replies
View Related
Oct 27, 2006
I have a small database for doing some tracking and some reporting. I want to be able to allow everyone to view the data and also to print reports. However, I also need to limit who is able to enter data into this application.
I don't want to build a login form for the application...I want to be able to limit users based on their Windows Login name, which I would have in a table. The first thing I would do is compare their Windows login name against the table, and then put in code such as "If table name = suchandsuch then you can't do suchandsuch, but if tablename = blahblah then you can do something."
Is something like this doable? If so, how might I go about getting started with this train of thought?
Thanks to any and all who respond..... I appreciate your time and knowledge!!
View 7 Replies
View Related
Feb 10, 2015
I am creating an Action Item Database that will be located on a Sharepoint portal so multiple users can access and I'd like each user to have a login/ password to
1) keep unauthorized users out of the database and
2) limit what users can see.
This login/ security should ideally work so that user "Bob Smith" logs in with his assigned login/ password and he will only view/edit/ run reports for those Action Items that he has generated (field named "GeneratedBy") or have been assigned to complete ("ResponsibleLead") which are both fields in table "tbl_ActionItems". I can not tie the security levels to a users network login; this has to be security within the database. I don't necessarily need specific code at this point so much as I need a logical starting point for setting this up.
View 6 Replies
View Related
Feb 13, 2008
to show only those dates between a certain time interval as in:
between jan 1 2007 to jan 1st 2008?
Is there a certain type of format I need to type into the criteria field of the query?
Thanks in advance!
View 1 Replies
View Related
Aug 16, 2013
I am using Access 2007. My boss has given me a project to create a tool for our team. I'm done with most part of the project, but for the last part I want editing and updating of database restricted to a few members of our team. However others can access the database and run queries etc. through buttons on a form.
I went about creating a login form for users to get access to the database and in turn created a table with fields UserID, UserName, UserPW and a yes/no field titled IsAdmin. For those who would be limited access would log in as 'Other' user and same as password. I am then using the code to determine if the user should be treated as admin or not by looking up the IsAdmin field in the table. Following is what I have so far, but it needs correction some places and I can't figure where:
Private Sub cmdLogin_Click()
Dim xxAdmin As String
'Check to see if data is entered into the UserName combo box
If IsNull(Me.cboUser) Or Me.cboUser = "" Then
MsgBox "You must enter a User Name.", vbOKOnly, "Required Data"
[Code] ....
View 14 Replies
View Related
Apr 30, 2015
I have a field that shows dates as quarters. Right now it is just a date/time field, but that posses a problem, as the user can enter any date possible. I want the dates to be limited to March, June, September and December, and any year they choose.
View 1 Replies
View Related
Jul 30, 2013
I have a query that is pulling information from 2 tables: airport codes and orders. I was able to select the 7 states I wanted without any problem. I am trying to limit the "order date" by using the criteria ">=#1/1/2011#". I want the query to only choose those orders that were dated 1/1/2011 to the present.
No matter what I place in the criteria for the date, the data never changes. I even tried "=date()" just to see if it would change. I tried "Between #1/1/2011# And #12/31/2013#" and the results were the same. This should be a simple task (as were the states) but I don't know why it is not yielding the desired results.
View 7 Replies
View Related
Aug 30, 2013
Ok, not sure if this is even possible or where to even start..
I've got a form that has all the info for a client, eg..
Client First Name
Client Last Name
Client Hours
Client WE/CS/EE
Client Day And Times
Client Phone
Client Comments
Begin Date & End Date (2 boxs) on there for date input..
and what i'm trying to do is limit that any date entered between begin date and end date, it'll check and make sure there is only ever 20 clients on any 1 day..
i thought Datediff would be the way to go, but then again how do you get it to search each day and make sure theres only 20 clients on there..
View 1 Replies
View Related
Apr 16, 2015
I basically have General Date field (e.g. 10/1/2014 6:34:11 PM) and I want to limit the results to only a specific month and only to show reuslts after 6PM. I tried everything and still stuck.
View 2 Replies
View Related
Jun 28, 2015
I have a form with a chart , 2 textboxes for start date and end date and a button to filter the data( filter the data by date range) How do i continue from that? The chart isnt updating.
View 5 Replies
View Related
Jun 10, 2005
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 1 Replies
View Related
Nov 30, 2005
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 3 Replies
View Related
Nov 24, 2014
I am working on a Student database for a school. Need changing the student status e.g. A student was enrolled in class Prep. and now promoted to grade 1. How do I solve the problem. I need this for a report (Student Details) Like on 1/1/2014 the student was enrolled in prep and on 1/1/2015 he/she was promoted to grade 1.
View 3 Replies
View Related
Apr 13, 2013
I want to prepare a query which gives me the ranking of the classroom according to their average. (also there are classrooms in the table, if possible, query should consider the grades) you can see the attached sample document..
View 1 Replies
View Related
Nov 13, 2006
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 6 Replies
View Related
Feb 25, 2007
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 2 Replies
View Related
Jul 5, 2012
I run an after-school youth program for high school students. My issue is an accurate way to track attendance of students. We have MS ACCESS 2010 on our computers at work.
On any given day we may see between 30 to 50 students, so this is a small operation - - and the reason I'm adverse to buying fancy "custom" software and hardware "systems". Because students come and go and vary over time, we may see 100 kids in a given week, but in the past 2 years of operation, we have had well over 250 students come through our program, with some returning at various times.
What I would like is to be able to
1) Make a simple ID card with student photos and a unique ID # that can be ...
2) Scanned by a simple barcode system.
2b) Actually two barcode swipes ... one swipe at the front door / main entrance, and a 2nd swipe by a hand held bar code in the various four classrooms to be sure the student is not only in the building, but also went to the correct class.
3) That the input of that information dumps into our ACCESS database so we can track student attendance, and ...
3b) provide reports out to school counselors / principals of the numerous highs schools that our students come from, to let them know which of their kids are actively attending our program.
My questions are ...
A. Can this be done with ACCESS?
B. Would it be better to do this with EXCEL?
C. If ACCESS can handle it, which types of bar code devices would be the best choice for us to purchase? (We would need a total of five barcode scanners. One at the front desk, and one in each of our four classrooms.)
The system would need to be expandable seeing that this could easily be doubled in terms of classrooms and students within the next year or so. We are currently just 2 years old.
View 3 Replies
View Related
