Test: Multiple Choice Template

Can any one do this i need it real fast let me know!!



ADVERTISEMENT

Multiple Choice Test Database - Version: 2003 (11.0)

Hi,

I think this is the best place for my question...

I am looking at setting up a databse that can be used to test individuals using multiple choice questions.

My best thoughts so far:

Opening form asks for name which starts a record for that person
Series of check boxes on forms for questions and answers ie one form per question, 5 check boxes each one of which is the right answer
Login for administrator which can then view results

Only trouble is I then need to be able to score the answers some how ie person x scored 8 out of 10 and got 80%

Am I working along the right lines for such a project - I've never attempted something like this before and need some guidence!

Thanks in advance.

View Replies View Related

Multiple Choice

I have a query which check assignement of vehicles.
Is it possible to have combo box with all employee names ,and acording to that choice to execute query.
So when i open my report I want to be asked to pick name of 1 employee in drop down menu and then get his records.
If its doable please be gentle cause i am new in all this
thx

View Replies View Related

Multiple Choice Parameters???

I'm trying to setup a parameter that has a multiple choice so to speak. Rather then the user being able to enter whatever data they want.. I would like them to have a choice between two items.

Is it possible? if so.. how do I do it?

Thanks!

View Replies View Related

Multiple Choice Quiz DB - Version: 2003 (11.0)

I'm helping someone get started on one of these but I'm unsure how to best set the tables up. Can anyone give a little guidance? Here are the parameters:

Thousands of questions, some wordy so the question text will require a memo field.
Each question has four and only four choices...no more...no less
Never more than one correct choice

I'm seeing TWO ways to set this up but I'm unsure which is the best way to go:
Code:

OPTION A:
tblQuestions
QuestID Autonumber
QuestionTxt Memo
dtmLastModified date/Time
fk_ModifiedBy Number
fk_ReferenceMaterialID Number

tblAnswers
AnswerID Autonumber
AnswerTxt Text
fk_QuestID Number
bolIsCorrect Yes/No
fk_QuestID related to QuestID in question table. So there are four rows in tblAnswers for Each row in tblQuestions.


OPTION B:
More of a flat file to start with since there is only one table. This table would include fields A thru D where the answers would be spelled out:

tblQuestions
QuestID Autonumber
QuestionTxt Memo
dtmLastModified Date/Time
fk_ModifiedBy Number
A Text (max 255 characters)
B Text (max 255 characters)
C Text (max 255 characters)
D Text (max 255 characters)
Correct Text (max 1 character)



The actual questions would look something like:
How much wood could a wood chuck chuck if a wood chuck could chuck wood?
A) A lot of wood. The wood chuch is eager
B) Some wood. Depends on how early he woke up
C) None, Woodchucks are a type of marmot, and are also known as groundhogs. They don't eat wood.
D) 10 lbs per hour.... only stopping to up chuck every 5 minutes.

View Replies View Related

How Do I Create A Multiple Choice Questions - Version: 2000 (9.0)

I want to develop multiple choice questions for 10 subjects.The questions cannot be changed.When a student selects his class it must display all the students in that class.He choses his name and selects a subject.the databse must fetch questions pertaining to the subject.The student is met with a form with test 1 ,test2 and so on .Each test consist of 40 questions.The student is marked out of 100.Some of the tables are obvious Such as
tblClass
ClassId (PK)

tblstudents
StudentID
StudentName
ClassID(FK)

tblsubjects
SubjectID
SubjectName

tblquestions: I have a problem here since there are diferent subjects
tblAnswers and so .Pls i need help as how i can implement it in access

View Replies View Related

How Deal With Multiple Choice For Field In Query - Version: 2007 (12.0)

Lets say I have a report and a report dialog form that gathers criteria for the report. In the query I have parameters. The parameters get their values from fields on the dialog.

Lets say I have a Company field on the form dialog. It would be nice if the user could tell the dialog "I want to see Company ABC and Company XYZ, instead of just entering one value in the Company Field. I realize I could query for all companys and then filter on the back-end, but I wonder, is it possible to filter it on the front end, ie., to allow the user to somehow to select Company ABC and XYZ in the report dialog?

I suppose anything is possible if you jump through enough hoops, but is this something that Access provides a solution for that is farily easy?

View Replies View Related

Test Sum Of Multiple Text Boxes Using IF...THEN - Version: 2002 (10.0) XP

I am trying to use an IF...THEN to test the sum of multiple text boxes. I am using
IF (me.textone + me.texttwo + me.textthree) = 0 Then

But it's not working.
Is there a syntax problem ??

View Replies View Related

Choice... ActiveX Or DLL

If you had a choice of using either an ActiveX or a DLL object in an application that is used on various systems, what would you choose?

This is going on a .MDE project and my main concern is stability or compatibility.
I am more interested in general practices of what you would use (either an ActiveX or a DLL object) to add functionality to your Access application.

If we had to go into something specific... then lets just generalize it into 2 catagories:
1) General added functionality.
2) Security

I would like to hear pros and cons about both.

Thanks.

View Replies View Related

Choice Of Address?

I have two addressess, primary and secondary.
I would like to make an option button on the form that indicates (when selected) which address to use for mailings? Although, 9 times of 10, mailings are sent to the primary address, but there are those exceptions...

Can someone direct me to an example code to perform this?

View Replies View Related

Query Different Choice In The Same Fields.

I am trying to create a query that capture all the possible choice of a fields and do some math on them. let me make it clearer.
I have two fields that i need to create a query from forecast type(backup, hardcore) and win percent(76 to 100, 50 to 75, 26 to 49 and 0 to 25).
Forecast type is a drop down that has the following choice hardcore, backup or could be null. Win percent is just a number fields holds value between 0 and 100. One of the criteria for the range of number is when either backup or hardcore is null.i need them to line up as rows or columns so they either look like this

row view

Hardcore
Backup
76 - 100
50 - 75
26 - 49
0 - 25


column view
[Hardcore] [Backup] [76-100] [50-75] [26-49] [0-25]

I am currently using six queries to get the values for each group then joining them to get the final results. the problem with this is the values wont come out correctly. I know there is an easier solution to what i am doing right now.
I need some guidance and help to approach this issue. This will be use in a report so hopefully this provide more alternative to solve this problem.

thanks in advance

View Replies View Related

Date Required After A Choice

I have a form which deals with complaints against employees.

One of the selections is a yes/no checkbox stating "No Merit" indicating the complaint has no merit.

If this checkbox is checked for Yes, I wish to require that data (an explanation) be entered as to why in your opinion the complaint has no merit.

This data would be entered in a text field called Comments.

On the "Close Form" command button I have tried to place the coding
If [nomerit]=yes And [comments]=" " then
run the message box.

I can't seem to get it to work. Any ideas gratefully received.

View Replies View Related

Set A Default Choice In A Combo Box

I used a combo box to let user select "Proejct Status" such as active, completed, cancled. I want to set active as a default selection if user does not choose other status. How can I do that? Thank you very much for your help.

View Replies View Related

Parameter Drop Down Choice

I'm currently use the statement below in a query.

Like [Please Enter the Cluster you wish to view] & "*"

This prompts you to enter in the information.

Is there a statement, that will prompt to select from drop down choices when quering?

For example, I have a database that tracks test scores. I want to be prompted when I run the query to select from a drop down 'Pass' or 'Fail'

Can anyone help me?

View Replies View Related

Option Choice Problems Again

Hello again all-

I am having problems again with my sqlstr. In the three option choices below...option 2 and 3 work fine...easy enough.

My problem is the first one...

I keep getting an error that states:

"The specific field '[SMID]' could refer to more then one table listed in the FROM clause of your SQL statement."

Basically what I am trying to do with option 1..and by default, is show all records in the finance table based on the SMID.


Code: Private Sub OptChoiceF_AfterUpdate()
Dim strSQL As String
strSQL = "SELECT tblRank.Rank, tblMain!LastName & ', ' & tblMain!FirstName & ' ' & tblMain!MiddleInitial AS FullName, tblMain.SSN, tblFinance.FinMainType, tblFinance.FinanceNomenclatureID, tblFinance.FinAmount, tblFinance.FinTLNumber, tblFinance.FinDateIn, tblFinance.FinDateOut, tblFinance.LoctID, tblFinance.FinanceRemarks, tblFinance.FinComp FROM (tblRank INNER JOIN tblMain ON tblRank.RankID = tblMain.RankID) INNER JOIN (tblFinanceNomencLkUp INNER JOIN tblFinance ON tblFinanceNomencLkUp.FinanceNomenclatureID = tblFinance.FinanceNomenclatureID) ON tblMain.SMID = tblFinance.SMID "

'Variable to hold filtered SQL string
Dim strFilterSQL As String

Select Case Me!OptChoiceF
'Filter record source dependant on option checked
Case 1
strFilterSQL = strSQL & "Where [SMID]= Forms!frmMain.frmFinanceSubform.frmFinanceRoster.SMID"
Case 2
strFilterSQL = strSQL & " Where [FinComp] = False"
Case 3
strFilterSQL = strSQL & " Where [FinComp] = True"

End Select

' Set record source with filtered SQL
Me.RecordSource = strFilterSQL

End Sub


Thanks for any assistance I can get with this

V/R

DWilliams

View Replies View Related

Inserting A Value Based On Combo Box Choice

Hi all,

I have a main form containing client details (tbl_Client) and a sub form containing notes (tbl_notes). tbl_Notes contains a foreign key field (Client_ID) which is obviously the primary key in tbl_Client.

The client is chosen on the main form using a combo box where the user selects the clients name. the id is not visable to the user. How can i get it so that the id (Client_ID) of the selected user is inserted into the Client_ID field of tbl_notes.

Thanks

View Replies View Related

Creating Quiz DB, NOT Mutliple Choice.

Hi.

I am creating av quiz database, that are supposed to handle about 50 users.
It's about 50 questions, and the answers will be long, more than 255 signs.

I have som issues on how to go so far.
The quiz respondents will answer in a dap (or maybe Asp) web page on the intranet. The structure, shown below doestn seem right.

So far I got this:

tblQuiz
-------
quizID
Title
PassScore
introText

tblQuizPart
-----------
quizPartID
partName
sorting
quizID

tblQuizQuest
-------------
questionID
question
correctAnsw
maxPoints
sorting
quizPartID

tblQuizAnsw
--------------
answID
questionID
answer
username
timestamp
pointsGiven
sensured (yes/no)

======================

This is not a satisfying structure, but i'm not sure on where my mistake is.
Does anyone have a suggestion?

View Replies View Related

How Do I Create Mutiple Choice Questions

I'm making a project in VB, and I need it to link to a Database,I already know how to do this
the project is a bit like who wants to be a millionaire with all the questions in an access table,
I know I need the following fields;

the auto number
the question
Answer A
answer B
answer C

the problem is I need to be able to select which answer is correct ?

View Replies View Related

Create Recordset From Combo Choice

I have a table called Contacts and a form with two combo boxes for searching for records either by name or property name. The following code works fine for finding the first record, but I want to be able to show on the form all (and only) those records which match the combo box entry. Currently rowsource for name box is:
************************************************** *
SELECT [Last Name1] FROM Contacts UNION SELECT [Last Name2] FROM Contacts
ORDER BY Contacts.[Last Name1];
************************************************** *
and code is:
************************************************** *
Private Sub Combo214_AfterUpdate()
' Find the record that matches the control for Last Name search
Dim rs As DAO.Recordset

Set rs = Me.Recordset.Clone
rs.FindFirst "[Last Name1]= '" & Me.[Combo214] & "' OR [Last Name2]= '" & Me.[Combo214] & "'"
rs.FindNext "[Last Name1]= '" & Me.[Combo214] & "' OR [Last Name2]= '" & Me.[Combo214] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Combo214.Value = ""
txtFirstName1.SetFocus
End Sub
************************************************** *
Rowsource for property box is:
************************************************** *
SELECT Contacts.PropertyID, Contacts.PropertyName
FROM Contacts
ORDER BY Contacts.PropertyName;
************************************************** *
and code is:
************************************************** *
Private Sub Combo212_AfterUpdate()
' Find the record that matches the control for Property Name search
Dim rs As dao.Recordset

Set rs = Me.Recordset.Clone
rs.FindFirst "[PropertyID] = " & Str(Nz(Me![Combo212], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Combo212.Value = ""
cboPropertyName.SetFocus
End Sub
************************************************** **

Any help is appreciated!

View Replies View Related

Figuring Different Calculations Per Choice In Combo Box

Hello, I have a combo box called (cboridge) bound to a table called (Ridge)with two fields/columns called (dollar amount) (Material type)with 4 different options/records, when the user selects his option/field the dollar amount shows stays visible in the (cboridge) combo box Then I have a text box called (txtridgetot) that has a calculation in it, but I need different calculations per option/field that's picked. Can each option/record that is chosen have a different calculation associated with it in the (txtridgetot) text box.

In other words if the user selects the third option/field called shake ridge could I have a calculation that would run and have it display the sum of this calculation in the text box (txtridgetot).

If so could you please describe how?

Thanks-- Any help will be greatly appreciated.

View Replies View Related

How To Trap An Error (and Force A Choice)?

How do I programmatically force an error dialog to make a certain choice?

I'm able to trap the dialog via the following code:


Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 7787 Then 'record updated by another "user" (subform)
MsgBox "Error trapped!"
Response = acDataErrContinue
Else
Response = acDataErrDisplay
End If
End Sub


Problem is, if I bypass the 7787 error in this manner, it defaults to dropping the changes, rather than saving the record, which is what I want. (Both are choices on the dialog.)

Any help would be most appreciated.

View Replies View Related

Figuring Different Calculations Per Choice In Combo Box

Hello, I have a combo box called (cboridge) bound to a table called (Ridge)with two fields/columns called (dollar amount) (Material type)with 4 different options/records, when the user selects his option/field the dollar amount shows stays visible in the (cboridge) combo box Then I have a text box called (txtridgetot) that has a calculation in it, but I need different calculations per option/field that's picked. Can each option/record that is chosen have a different calculation associated with it in the (txtridgetot) text box.

In other words if the user selects the third option/field called shake ridge could I have a calculation that would run and have it display the sum of this calculation in the text box (txtridgetot).

If so could you please describe how?

Thanks-- Any help will be greatly appreciated.http://forums.aspfree.com/newthread.php?do=newthread&f=18#
Hello!

View Replies View Related

Choice Of DB Design - Version: 2003 (11.0)

I have a table called tblOrder, with primary ID: OrderID.
Any two orders may have relationship, so I need a table to store this relationship while I call it tblOrderRelationship

There are two designs:
1. tblOrderRelationship , which will have
- Order1ID, from tblOrder
- Order2ID, from tblOrder,
- Description, a field of description

2. tblRelationshipID + tblOrderRelationship
tblRelationshipID is used to maintain the two order IDs, so it will only have
- Order1ID, from tblOrder
- Order2ID, from tblOrder,

tblOrderRelationship is used to maintain the descriptions, and be connected with the rblRelationshipID. And fields are identical to those in Option 1.

The second option (see pic) is suggested by my friend, and he explained the tblRelationshipID as a filter to filter out any impossible order relationships. Only qualified relationships can be saved in this table, and further details are saved in tblOrderRelationship.

But I just do not think tblRelationshipID is necessary, so I favor option 1. Which one is better and is there another better option? Thanks for your input.

View Replies View Related

Choice... ActiveX Or DLL - Version: 2003 (11.0)

If you had a choice of using either an ActiveX or a DLL object in an application that is used on various systems, what would you choose?
This is going on a .MDE project and my main concern is stability or compatibility.
We don't have to get into specifics, I am more interested in general practices of what you would use (either an ActiveX or a DLL object) to add functionality to your Access application.

Thanks

View Replies View Related

Is Access Best Choice For My Needs? - Version: 2003 (11.0)

Hi all,
I've been using an old exel spreadsheet which is not meeting my needs anymore. I've had a little expreience with access but quite a while ago. I understand filemaker is quite popular now, but know next to nothing about it. I'm wanting to set up a database that will meet my needs as detailed below. Would Access 2003 be the best option for me? What sort of data/table structure should I use? Any help or direction would be appreciated


Groups, members and dates change on a yearly basis

Patrols
Multiple groups (called ‘patrols’)
Each patrol has multiple members
Each patrol has multiple dates (4+) for compulsory attendance with varying hours
Each patrol has a Captain and a Vice-captain


Members
No member is in two patrols, however they can volunteer for other dates
If members cannot make a patrol, they can get a ‘substitute’ from another patrol
A record is kept of member dates and hours


Competition
Each patrol is inspected (tested) at least twice and given a score
Each patrol is awarded more points for greater member attendance
Each patrol is awarded further points if members volunteer for other dates
Each patrol is awarded further points if members complete certificates
Members are awarded if they have a 100% attendance
The captain and vice-captain each vote for the 3 best members from the date and are ranked 1 to 3 (best obtaining 3 points). The best member does not need to be a member of that patrol, they may be volunteering from a different patrol

Much thanks all
rk

View Replies View Related

Some Newbie Queries About Choice Dependant Fields

I have a database i am playing around with in Access 2003

I should state im new to Access

Anyway i have a field with a dropdown menu with the choice of Yes or No

I want another field to be populated from an entry in the table Extras called ElectricityCharge but only when the Yes is chosen above

Had a look around and cant see any sort of If then type function or anything of that ilk, how can i do this ?

View Replies View Related

Select Query Based On A User Choice

Hi,

I would like to run a simple select query, where the CRITERIA is based on the user choice.
I have a form with a combo box, with a few choices, and a button that will trigger a macro with one query for now. I can store the choice in to a variable e.g. "town", using Microsoft VB code.
How can I transfer the variable to the CRITERIA field in the query, so whenever I chose a specific "town", my query will select the records for that specific town.
I want to use one query, and I don't want to have to "hard type the criteria in to the cells' query", but I would like to use a variable that can change and will be read it from the user choice through combo box.

If I am not clear enough, please let me know.

Thank you!

View Replies View Related

Limit Choice Of Cbo Box To Results Of Another Cbo Box - Version: 2003 (11.0)

I'm attempting to limit a user's choice based on their choice of another cbo box. This isn't working (I get no results.)

SELECT JCJobCode.SKJCJobCode, JCJobCode.ID, JCJobCode.Description, JCPhase.ID
FROM JCPhase INNER JOIN (JCJobCode INNER JOIN JCPhaseDetail ON JCJobCode.SKJCJobCode = JCPhaseDetail.FKJCJobCode) ON JCPhase.SKJCPhase = JCPhaseDetail.FKJCPhase
WHERE (((JCPhase.ID)=[Forms]![Enter/Edit Service Requests]![Service Request Department Subform].[Form]![cboPhase]))
ORDER BY JCJobCode.ID;

Can anyone tell me what I'm doing wrong?

Thanks!

sam

View Replies View Related

Mulitiple Choice Questions? - Version: 2003 (11.0)

I would like to make a multiple choice test for work/personal purpuses. I am new to Access and have only limited knowlede on how to make a database and to use a query. I have tried a few online tutorial's but they seem to confuse me at best. What I would like to do is have an easy way to input questions into some sort of table. I am not too sure how to even set up the table would I have to have a seperate table for each question or could I have each question/answer on each line of the table. What would I output the table too? Not sure if it will be a querry or something else. Here are some other things that I want it to do.

-Change the order of the answers/question each time it is run
-Easy way to input the information (So some one that can't manipulate an access database could do it)


I have seen it done before so I know that it is possible. Maybe some one out there knows of a database out there so I could see how they did it. Thanks.

Andrew

View Replies View Related

Creating A Boolean Choice - Version: 2003 (11.0)

Hi guys, this is a very basic question but since I havent used Access in over 5 years I was hoping to get a quick answer so I can sort out this tiny little issue.

I want to create a boolean choice in my table.

Instead of YES/NO, ON/OFF etc I would like the choice to be Public/In-House.

I know it's very basic but I'd appreciate your help...I've typed in "Public"/"In-House" in the format and chosen a 'combo box' but all I get in each record is Public/In-house and when I try and select an option I get '0:00:00' appear in the field.

Its a simple table which is just going to be used to convert paperwork into electronic form, so nothing fancy required. I'd even be willing to have the two options as check boxes but being a total novice Im stumped.

Thanks for your help in advance

View Replies View Related

Filled Text Boxes Based On Combobox Choice

Hi
I have been searching this forum for 3 hours for a solution, some come close others are pure gobble de gook to me.
I have on a form 1 combobox where a name is chosen, from that choice I would like the address, suburb, state etc automatically placed intheir relevant fields.
I have tried =DLookUp("[PropertyAddress]","tblProperty","[Property]") in the address textbox which will only bring up the first recod's address from the table, if I change the name in the combobox the address doesn't change.
What am I doing wrong, I have designing databases in Access for a total of 7 days now and have been going fairly well with some tips and code snippets from this forum but this has got me stumped.

Cheers
optidisk

View Replies View Related

Saving Choice From Combo At Startup - Version: 2003 (11.0)

Hello,

I have developed a db for a company that allows them to plan the hours that their staff applies to their various projects. They have been using it for a couple of years, and have three "seasons" per year. The data is similar for each season (except for the dates), and I have made all of the labels for forms and reports for each date unbound, so they are not specific to any "season." I have had issues when I make "fixes" sometime they are not applied to each of the seasons - mostly developer error! What I would like to do is have one single front end, and have the user select which season they would like to use, and then have the choice determine which set of data is used.

My initial thought (and preference) was to have the choice determine which back-end file is used, but I couldn't find any info on how to set up the links based upon items in a table.

My second thought is to have the all the data in one table and to have the season specific data be selected from a query based upon the choice in the combo box from the opening form. My problem with this is that I do not know how to retain the choice from that combo box throughout the users use of the db.

Any thoughts would be greatly appreciated!

TIA,

Blair

Of course part of me is not sure if I should do this, since I am paid by the hour and by doing this I decrease the amount of effort/time that I would spend setting up each season, thus reducing my income! ;->

View Replies View Related

Merge Form Fields To Choice Of Word Templates

Merge Form Fields to Choice of Word Templates

I'd found the need to get a reliable "Letter Addresser" for one of my applications, and after a search through the forums at UtterAccess.com it seemed I was not alone. As always, there was several ways to "skin the cat" but in the end I chose this method.

I often find that seeing a demo helps me understand how things work better than just seeing the code and an explanation. I can't take credit for the code - it's an amalgam of several bits of other peoples answers on the forums with a bit of my own tinkering thrown in - hence my "CutAndPaste01" Monica. (for the non Brits amongst you, Monica = Monica Jane = Name....)

As with any of the problems you may encounter, it often pays to do a search first before posting!

Obviously, your own customised Templates can be Envelopes or any other Word Document that you need to transfer information to from an Access Form - it's not just limited to names and addresses! :-)

You can use a fixed Template Version or allow a choice of letter to be sent using the same information on the form.

You may need to reset the reference to MS Word Object Library (mswordX.olb) - normally found in Program FilesMicrosoft OfficeOffice,

If this helps in something you are doing, please send an Email to CutAndPaste01 via the Forum to say hi!

View Replies View Related







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