用于MS Access的随机问题生成器 [英] Random Question generator for MS Access

问题描述

我使用MS Access Form作为前端和ms-access数据库作为后端

我想从100个问题中随机从数据库中检索10个问题

simultenously in RichTextBox的。如果我点击下一步按钮，则显示第二个问题。

我使用四个单选按钮选项

然后我点击完成按钮然后显示结果以及我如何将10个问题与用户答案存储在数据库中。

I am use the MS Access Form as frontend and ms-access Database as backend
I want to retrive 10 question randomly from database out of 100 question
simultenously in richtextbox. If i click on next button then second question display.
I am use the four radio button for option
and I click on finish button then show the result and how iam store the 10 question with user answer in database.

推荐答案

嗨mohammad你好吗？


我给你一个select查询来检索一个表的前10条记录，

我认为剩下的对你来说很容易，


祝你好运

hi mohammad how are u?

I give u the select query to retrieve the top 10 records of a table,
I think the remaining would be so easy for u to do,

good luck

展开 | 选择 | Wrap | 行号

MohammadShabbir



- Mojyzzzz'的解决方案不会阻止重复的问题，因此建议检查这些问题或使用DISTINCT。和M。已经对您的表设计做了一些假设，因此请注意您可能必须修改查询。 （ SQL谓词）


- 因为这是一个有点熟悉的问题，经常被要求做家庭作业或课程项目，我会要求/要求你发布你当前的代码和数据库设计。注意：这并不意味着附加图片或文件，因为这些信息可以很容易地输入到帖子中。

请记住使用< CODE />来格式化代码和SQL块。工具栏中的按钮。

MohammadShabbir


- Mojyzzzz''s solution will not prevent duplicate questions so it is advisable to check for these or use the "DISTINCT" and "M" has made some assumptions about your table design so be aware of the fact that you may well have to modify the query. ( SQL Predicates )

- As this is a somewhat familiar question often asked for homework or class projects I would ask/require that you post your current code and DB design. Note: that does not mean attach pictures or files as this information can be typed into the post quite easily.
Please remember to format your code and SQL blocks by using the <CODE/> button in the toolbar.

你还应该记住，建议的SQL会为你随机化数据，但它将是一个可重复的随机化，这样你就可以得到相同的随机数记录每次运行。

You should also bear in mind that the suggested SQL will randomise the data for you, but it will be a repeatable randomisation, such that you will get the same random ten records each time it''s run.

这篇关于用于MS Access的随机问题生成器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！