Access DB To Store And Grade Exam Results
Apr 10, 2006
Hi!
I am creating an access database where the results to an exam will be entered (multiple choice exam so nothing fancy), and in turn they will be graded. I have searched and the closest thing I have come to this is the survey DB with a field for each question. However since this is a exam rather than having "no right answer" this answer needs to be compared with a key. So my question is as follows:
What table structure is ideal for this? ( I have yet to find a way to compare rows )
I appreciate any help on this you can offer,
Joseph Cohen
View Replies
ADVERTISEMENT
Feb 8, 2007
I'm not doing one this minuet but I would still appreciate help.
the exam is in the UK and with AQA.
does anyone know of any sites which will give me tasks to do to test myself.
Thanks in advance:D
View 8 Replies
View Related
Jan 24, 2008
Anyone know any issues that would stop me down grading an access 2007 database. Someone up converted it without me knowing but I want it to be usable for people on older versions.
I went to save as access 2003 and nothing happened. My initial thought was recompile the vba code and do a compact and repair. I did this and still nothing happens. I hit save as access 2003 and nothing happens no error messages or anything (HELPFUL).
View 4 Replies
View Related
Feb 9, 2014
I have a a table 'Orders' with fields (Order Number, Order Date, CD Number, Card Number).
I would like to produce a query in access 2010 that would allow me to count how many times the CD Number 'Diab190617' has been purchased.
I would like to store the results of this count and counts on other cds numbers somewhere so that I can produce a graph/chart of these counts. How can I do this?
View 4 Replies
View Related
Jun 21, 2007
helloi have had alot of help on these forums already and i thank those that have helped me thus far.but i am having some troubles doing a query.i am trying to get a students grade.but each assesment they do has a differant weighting.for each assesment they are given a percent for it say 80% which may have a weighting of 30.while another assesment they have they get 52% but it has a weighting of 60.and if they missed an assesment it doesnt affect there grade.so what i am asking how can i get there percentage at the end of all the assesment and then turn that into a grade like B+.to better show you what i mean here is the end report i have to make which shows how subjects have weighting.http://i18.photobucket.com/albums/b145/hi2chriz/1stPage.jpghttp://i18.photobucket.com/albums/b145/hi2chriz/2ndpage.jpghope i was clear
View 1 Replies
View Related
Dec 7, 2005
Hello friends.....
I am new here... and want your help...
Please tell me how I can apply alphabetic grade (A, B, C or F) in MS access
For example we have these marks of students
45
55
86
74
49
Then how I can apply grade to these values..
Hopping to see u soon.
Take care, and have a good time.
View 3 Replies
View Related
Aug 23, 2005
I am having a problem coming up with a design for reporting by grades within a golf recording system. I want to calculate the grade for each player within a query, based on their handicap.
tPlayer contains the fields pName & pHandicap. tGrades currently contains gGradeName, gMaxHandicap.
In a query I want to be able to list by Grades
Grades could be
A , 10
B , 15
C , 27
or
A , 10
B , 14
C , 19
D , 32
or whatever. but the number, name and ranges of Grades may change.
While it may seem odd, I want to be able to change the Grades and requery on the same Players data.
I feel it should be simple but have not been able to come up with either the design or SQL that would enable me to do this cleanly.
Hope this makes sense - any help would be appreciated.
Many thanks...peter
View 4 Replies
View Related
Dec 27, 2007
dear all;
i've a table #student like
studentID score
Sminth 88
samantha 76
Williamv 45
martell 78
and i also have a #grade table
Grade Start end
F 0 45
E 46 55
D 56 65
C 66 75
B 76 85
A 86 100
and my question is,how to calculate the student table's grade value?
i want the result like below..
#studentID score Grade
Sminth 88 A
samantha 76 B
Williamv 45 F
martell 78 B
anyone can help me??thanks alot
regards
martell
View 12 Replies
View Related
Sep 5, 2013
I have a database with:
2 tables, tblStudentMarks and tblGrades
2 Queries qryResults and qryStudents_Grades
1.qryResults:Calculates the TotalAverageMaths+English+Science)/3.
2.qryStudents_Grades:Calculates the students grades based on the TotalAverage by comparing the total average to the min & max marks on the tblGrades.
Grades are compared within a range specified in tblGrades with the following SQL wich is the query qryStudents_Grades:
Code:
SELECT SM.Student_ID, SM.Students, SM.TotalAverage, SM.Maths, SM.English, SM.Science, GD.Grade
FROM qryResults AS SM INNER JOIN tblGrades AS GD ON (SM.TotalAverage>=GD.MinMarks) AND (SM.TotalAverage<=GD.MaxMarks);
Question: i would like to also calculate the grades of the individual subjects in the same query (qryStudents_Grades), where the marks got by a student in the subject..say maths is compared to the (tblGrades) and grade is displayed in a colum say maths_grades for each student.
How can i do this for all subjects in one query. (qryStudents_Grades)?
View 7 Replies
View Related
Feb 25, 2008
I work at a wine store and right now we use access to create shelf talkers. Visually however they are a bit stale and ive been trying to come up with a new design for them. My problem is figuring out how to use the data from the database in a more design oriented context. here is a image of what id like the shelf talkers to look like...
http://hotimg14.fotki.com/a/72_43/193_67/forhelp.jpg (http://hotimg14.fotki.com/p/a/72_43/193_67/forhelp.jpg)
any recommendations or tips on how i can go about this?
thanks
Brendan
View 3 Replies
View Related
Dec 21, 2004
I was wondering if there is a way I can store a formatted text in a field in Ms Access. I know memo type can contain a very big string upto approximately 65k but formatting is not possible in that type. Regarding the OLE object, I am not sure if I have to create a word document and then store it as a OLE object or is there a way to do that without creating the word doc.?
I do not want to create a word document for each record in the table. Is there a better way?
Please advise. Thanks
View 1 Replies
View Related
Jul 6, 2013
how could I store files such as PDF inside MS access.
View 1 Replies
View Related
Dec 2, 2012
How to insert a timer in the PropertyFrm Form in the Access Database attached to this message. When a user opens the PropertyFrm form I want the timer to record the number of hours, minutes, and seconds each user spend time on a record including the current dateand have the data stored in the Timer table.
When a user goes to another record, I want the timer to reset and store the hours, minutes, seconds, and current date on another record in the Timer Table and so on. If the fields and data types in the Timer table is not created properly.
I do not want the time and current date to be displayed on the PropertyFrm Form. I want the information to be stored in the Timer table.I do not want the user to see the hours, minutes, seconds and current date information on thePropertyFrm Form.
View 2 Replies
View Related
Sep 4, 2007
Folks I need your help; just wanted to get your opinions here.
I work in a small engineering group and we have lots of reference documents in word and excel which we typically use for any projects. Currently, all these files are stored in Lotus Notes database. Unfortunately, they are pulling the plug on Notes license starting this fall. Therefore, I have been asked to see if there is a way we can store these files in Access as a repository and query the database whenever we need some information.
In order to avoid the database size getting too big, my thought was to store the .xls/.doc files as an “OLE object” data type, keep the files in local hard drive and create a link in a form to give the user to retrieve the information.
Do any of you have any suggestion on what is the best way to handle this?
Your input is highly appreciated.
Shan.
View 10 Replies
View Related
Jan 28, 2015
I am writing the following code that will first of all display column headers dynamically using "Headers" field data from Access table and then find out the sum(volume) using column header and first column values. The following code works fine to display headers dynamically in Excelsheet from Access table but doesn't display sum(volume) in all the corresponding cells. As I can't attach the Access table so I have stored data from Access table to sheet named "Access Data" as attached. The sheet2 named "Report" should populate total volume .
Code:
Public Function Inputdata()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim r As Long
Dim i As Integer
[code]...
View 2 Replies
View Related
Dec 4, 2014
Is there a way to make access be able to store software versions and product keys automatically? Programs I am most interested in is like Microsoft Office suites and Adobe Acrobat and Photoshop and whatnot like that. I am not sure if this is even possible but I am trying to get my database fully functional with all the data and efficiency I can for at least 5 people so that I can try to sell access as a better tool than the service they are using now.
View 4 Replies
View Related
Aug 28, 2007
My understanding of the LIKE operator seems to be deficient for filtering a query when using the Access query pane. I have a combo box that lists the values to be filtered. One option in the combo box is "No Selection". If "No Selection" is selected, I want the filter turned off, in other words ALL records are shown.
In theory the following code would seem to be correct when placed in the criteria line. It does not work: IIf([forms]![type5frm].[combo2]=24,Like "*",[forms]![type5frm].[combo2])
If the value of COMBO2 =24 (No Selection), then I would like all records to show up, but no records are displayed. The FALSE side of the IIF statement works correctly.
As an experiment I tried LIKE by itself and it displayed all the records: LIKE "*"
Another failed try:IIf([forms]![type5frm].[combo2]=24,[agency]) Like "*",[forms]![type5frm].[combo2]) AGENCY is the fieldname.
A more exotic attempt that failed:IIf([forms]![type5frm].[combo2]=24,Val(Str([agency]) Like "*"),[forms]![type5frm].[combo2])
Any thoughts?
View 7 Replies
View Related
Jul 11, 2007
Hi ,
I am using Access Application with Orcale Db as backend and this application is already in production.
The problem is.. USers Complained that the system is slow, this is because there is refresh (requery) for each Insert (When they click submit, that particular record is inserted and then a refresh has to be done to bring only unused member IDs on the User screen), i had used a Sql query using NOT IN , then i realized and now changed it to NOT EXISTS, but with this new query , if i test recordset. EOF , even though the query returns more than 13000 ..records, EOF sets to TRUE and the other part (not supposed to) gets executed. I really cant figure out why, i took the same query put it in query builder in Access and ran it , it gave 13000 records..but in VBA , this recordset is not giving expected results and so..i am totally confused..The part of the Code is shown below.
Code:newquery = " SELECT A.MEMBER_ID, A.MEMBER_NAME, A.ADDRESS_LINE1.................. FROM TABLE A WHERE NOT Exists ( SELECT '' FROM TABLE B where A.MEMBER_ID =B.MEMBER_ID)AND A.MATCH_LEVEL <> 0 ORDER BY A.MATCH_LEVEL DESC"rst1.Open newquery, Cnt, adOpenDynamic, adLockOptimisticIf rst1.EOF = False ThenForm_PHS_ASSIGN.RequeryForm_PHS_ASSIGN_SUB.RequeryElse MsgBox " No records to Process!" End If
EVEn though it should requery , it gives a message No records to process which is wrong. It works with NOT IN.... BUT VERY SLOW, NOT EXISTS IS FAST BUT DOES NOT GIVE ME WHAT I WANT..
Where am i going wrong..help pls!!!!
THANKS VERY MUCH!!
View 6 Replies
View Related
Sep 28, 2005
Good morning,
I am having some kind of problem. A query in Acces that is used to find results in the DB is asking 2 time's te input.
And there is no way that the input boxes is asking to do this twice..
here is the Query,
SELECT tblHotlines.Hotlinenummer, tblHotlines.Vestigingsnummer, tblDealers.Postcode, tblHotlines.Datum_hotline, tblBestellingen.Chassisnummer, tblBestellingen.Onderdeelnummer, tblBestellingen.[Uitleverings datum], tblBestellingen.[Vervangende auto ingezet?]
FROM (tblHotlines LEFT JOIN tblBestellingen ON tblHotlines.Hotlinenummer = tblBestellingen.Hotlinenummer) LEFT JOIN tblDealers ON tblHotlines.Vestigingsnummer = tblDealers.Vestigingsnummer
WHERE (((tblHotlines.Vestigingsnummer) Like [Geef het vestigingsnummer op] & "*") AND ((tblDealers.Postcode) Like [geef evt een gedeelte van de postcode:] & "*") AND ((tblHotlines.Datum_hotline) Like [Geef de datum op:] & "*") AND ((tblBestellingen.Chassisnummer) Like [Geef het chassisnr op:] & "*") AND ((tblBestellingen.Onderdeelnummer) Like [geef evt het onderdeelnr op] & "*"));
Qhat could be the problem that Access is running a Query twice before getting results
View 1 Replies
View Related
May 18, 2006
I'm new to Access, but a coworker has a huge project to undertake. There are over 200 queries that produce 1 row results for each query. She's been cutting that row and pasting it into Excel 200 times. Is there an easy way to insert them 1-by-1 into Excel or prefereably Access?
BTW, the columns are the same on the query results. I'll keep investigating while I wait for the experts to answer.
View 2 Replies
View Related
Dec 13, 2004
So I'm having timing issues trying to print data from an Access (actually SQL Server) based query to a Excel Spreadsheet. Basically I'm trying to get around using MS-Query and last week I didn't seem to have any problem as far as performance. However, when i tried running today it seems I've had a slow down of at least 500%. The data I'm trying to print is quite large (few hundred records and about 140 fields) so I expect some performance issues. Like I said though i just can't undestand the decrease. Possibly machine performance?
Anyhow, I've tracked the bottle neck and no suprise it is in the loop, I'm just suprised it takes so long to loop through the recordset.
Here's my code, any help will be appreciated?
'Generate grid to dump data
If intRecordSetCount > 0 Then
rst.MoveFirst
'Loop through length and width and display results
Do Until rst.EOF
intRSTField = 0
intFieldCount = intField
For intIndex = 1 To intColumnCount
Worksheets(strWorksheet).Cells(intRowCount, intFieldCount).Value = rst(intRSTField)
intFieldCount = intFieldCount + 1
intRSTField = intRSTField + 1
Next intIndex
intRowCount = intRowCount + 1
rst.MoveNext
Loop
Else
MsgBox "Recordset has not been initialized or does not exit"
End If
'Define name range
ActiveWorkbook.Names.Add Name:=strRangeName, RefersTo:= _
"= '" & strWorksheet & "'!R" & intRow & "C" & intField & ":R" & intRowCount & "C" & intFieldCount, Visible:=True
View 5 Replies
View Related
Aug 17, 2006
Hi!
I've written a querry - and the results that come back dont look right. Some rows have data in and others dont.
Has anyone seen something similar?
Does this mean that the data are probably incorrect?
Any advise?
A.
View 1 Replies
View Related
May 28, 2014
I have an Access 2010 application that talks to SQL Server. Part of the application creates tables on the SQl Server and inserts data to it (I know SQL Server has its on data inport/export wizard and bulk insert capabilities but for reasons outside of my control it needs to be done from Access). So I have a connection to the SQl Server and i have VBA that happily executs SQL statements on the SQl Server. The problem is I want to return a recordset from the result of a SQL query issued to the SQL Server. The idea being to check for the presence of tables already created, and if so, append to the already existing table, otherwise if it does not exist, create it and insert data to it.Ive tried the following code but it seems no recordset is being returned:
Set objConnection = New ADODB.Connection
objConnection.Open "DRIVER={SQL Server};SERVER=10.200.3.14;trusted_connection=yes; DATABASE=" & Me.Combo54
strSQL = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = '" & Me.Combo54 & "'"
strSQL = "USE " & Me.Combo54 & " " & strSQL
Set Rst = cmd.Execute("USE " & Me.Combo54 & " " & strSQL)
View 1 Replies
View Related
Oct 7, 2013
Running Office 365 (Access 2013). Recent problem occurrence. When I do an 'External Data' command, either from another Access database or an Excel file, the import completes, but I don't see the new table immediately in the navigator section. If I import from another Access database, the new imported tables appear as '~TMPCLP....' tables. If it's from an Excel workbook, the new table doesn't appear at all. It's only after I exit the database and reopen it do I see the new tables correctly named.
View 1 Replies
View Related
Aug 6, 2013
I wrote some code in Excel to open and run a module in Access. The code executes, but when I check the results I get no records, however if I just step back 1 line and rerun the query, I get records. Alternately, if I run the code twice it will get results the 2nd time.
The OpenCounter opens a Session in the terminal screen then performs a macro that writes to a temporary table.
Here is the code:
Dim db As ADODB.Connection, Rst As ADODB.Recordset
Dim Acc As Access.Application
Set db = New ADODB.Connection
db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & DBPath
Set Rst = New ADODB.Recordset
[Code] ....
One thing I tried with limited success was to tell the OpenCounter to open and close the table after it was done writing to it, but that seems like a lazy solution and it also doesn't always work.
View 1 Replies
View Related
Aug 31, 2012
I have a query that includes several columns, one of those columns shows returns on investment as a percentage. I need to figure out the annualised returns on investment using the following excel formula
{=PRODUCT(1+B1:B24)-1^(12/24)-1}
This formula gathers the percentages for the last two years then provides an annualized amount.
I'm just wondering whether this is possible to apply to the query so that when I open the query it can provide me with the 2 year annualized statistics.
View 1 Replies
View Related
