Randomising Access database content is no small thing. The SQL involved is quite complex even for small amounts of data and on only one table. If you have a series of questions with multiple choices available to answer the necessary query would be compounded in difficulty.
Have you looked at some of the tools for generating quizzes if you aren't inclined to write your own ?
HotPotatoes is used by a lot of people click here while other products like QuestionTools click here allow some quite sophisticated quizzes and questionnaires to be generated.