Results 1 to 5 of 5
  1. #1
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682

    Learn MSAccess by playing MSAccess Jeopardy

    Attached is a fun MSAccess Jeopardy game I created a couple of years ago where you can learn about MSAccess Tables, Forms, Queries, Modules, Macros, Reports, Comboboxes, Tabs, Labels, and General MSAcccess stuff by playing MSAccess Jeopardy. It keeps track of your high scores and you can play against 2 randomly selected computer opponents.

    Fully customizable where you can manipulate the buzz timer allowed to answer the questions, the skill levels of any computer opponents (Beginner, Intermediate or Advanced), add new computer opponents with different skill levels, pick certain categories a specific computer oponent likes the best, and other settings such as probabilities the computer opponents will answer correctly (and how fast they will buzz in against you). You can even adjust these settings in the middle of a game. You can make it so either of the computer opponents (or both) are always correct or give them a 50/50, 75/25 or any other odds you want that they will be correct. You can again, add new computer opponents giving them any name you want or remove ones so you can always play against tough or easy opponents. The computer opponents also have a random factor where they might 'second-guess' the answer they're going to give sometimes to make it more interesting (you'll see a message box appear that the computer is thinking through a better answer.)

    You can also make this a tutorial for any subject (not just MSAccess), entering your own Title of the Subject Game and enter your own questions, answers and $ amounts.

    It randomly creates the categories every time it plays adjusting the $100 to $500 questions and which answer is correct (ie. A, B, C or D so it's never the same game twice) or you can set your own $ amounts/add new questions to expand with new categories. The correct answer will be shown if answered incorrectly and you can make it so the computer opponents are easy or tough to play against (it randomly selects 2 new component oponents each new game ranging from whatever skill levels you want to play against.)

    You can set it up so you have a limited amount of time to answer or unlimited amount of time when buzzing in. It's currently set to unlimited amount of time when buzzing in so you can take your time thinking about the possible answers displayed after clicking the "*** Buzz ***" button. (the only thing is that the computer will not select is the next question when they answer correctly - you must select the $ amount/category each time.)

    Included is a 2000 and XP version of the mdb file so you can modify/look at the coding if need be (I just ask that you leave me with the credits in the code and on the Main Menu if modifying it.)



    Note: Not tested with MSAccess 2007 or 2010 but it should work ok. Feedback if you like it or not is welcomed.

    *** If the MSAccess file doesn't open, make sure to add this website to your intranet security in IE before downloading to then be able to open any MSAccess files within a zip download.

    .
    Last edited by pkstormy; 08-27-2010 at 08:30 PM.

  2. #2
    shannondtyus is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2011
    Location
    TX
    Posts
    1
    OMG, that was awesome!

  3. #3
    edmarcstuff is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1
    Hi. How can I get a copy of the .zip file? I would like to modify your game to utilize at work. Thanks so much.

    edmarc

  4. #4
    rudedog9d is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    May 2015
    Posts
    1
    I don't see where the download is?

    -BD

  5. #5
    jainkamleshd is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    5
    Couldnt find the attachment...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 19
    Last Post: 08-07-2010, 05:38 PM
  2. Compare msaccess data
    By dref in forum Queries
    Replies: 10
    Last Post: 05-14-2010, 05:35 AM
  3. MSACCESS Query with calculations?
    By Masterfinn in forum Queries
    Replies: 10
    Last Post: 02-24-2010, 10:51 AM
  4. msaccess fault error
    By msmoore in forum Access
    Replies: 4
    Last Post: 02-09-2010, 03:31 AM
  5. MSACCESS Query
    By saa18 in forum Access
    Replies: 0
    Last Post: 11-14-2008, 05:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums