How to create a complex Microsoft access quizzes and tests

Asked By Dexter Wiley 10 points N/A Posted on - 09/09/2012

 

I need to find a template to work with; my purpose is to create tests for my student. How to create a complex Microsoft Access quizzes and tests ?

• Status: Open
• Question Views: 761
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By William Saago 0 points N/A #151543

How to create a complex Microsoft access quizzes and tests

From the Microsoft Access application, go to File>New>Blank Database.
Give your file a name and select "Create"
Go to the design view>Table>Open or in Access 2010 and 2007 a preloaded template can be used to create the table.
Pick one field of the table and name it "Question." Pick a second field and name it "Answer." Add a third field and name it "Quiz Name." This will create one master table.
Go to Yes, Set a Primary Key for Me> Next
Go to Enter Data Directly into the Table >Finish   
Data can now be entered directly into the table and on completion, click the Enter.
Do likewise for the consequent records till completion of all of questions and answers. Click save and close table.
To view or print sample answers and questions from the table, select "Query To". You can modify or reformat table data at any time

About William Saago

Questions
1

Answers
31

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 09/12/2012
• Question Category: MS Access