|
||||||
|
Welcome Welcome! Test Taker DB with Grading Welcome to Microsoft Access Developer Level 10. In this course we will continue building the Test Taker database from Level 9, covering how to generate queries for unanswered questions, set up the form to begin the test and pull in question data, display questions and answers while saving responses and determining correctness, and finally calculate the grade and store results in the Test Result table. This course is suitable for most versions of Microsoft Access and builds directly on the previous lessons, so it is recommended that you complete Level 9 first. NavigationKeywordsAccess Developer, Test Taker database, query unanswered questions, grading automation, VBA form coding, save test answers, calculate grade, grade storage, test question form, Office 365 compatibility, Access Developer Level 10, Test Result table
More InformationTranscriptWelcome to Microsoft Access Developer Level 10 brought to you by AccessLearningZone.com. I am your instructor, Richard Rost. Today we are continuing with the Test Taker database that we started in Access Developer Level 9. If you have not taken Level 9 yet, then I strongly recommend you get that class first and watch Level 9 because parts 1 through 4 of building this database are covered in Level 9. Whether or not you are going to be building a test in your personal or business endeavors, there are a lot of techniques, tricks, and tips covered in this database that will be of use to everybody. I recommend you take all of my classes - beginner, expert, advanced, and developer. There are lots of different lessons, and I suggest all of them. Each series has multiple levels. This is Level 10 of the developer series. The sample database can be found at this page if you want to pick up where I left off at the end of Developer 9. The Test Taker database parts 1 through 4 can be found at this page. You will need the password. Everything today should work with pretty much every version of Microsoft Access. I am going to officially support 2007 and 2016. I am using 2016 with Office 365. However, I think everything I cover today will work with every version of Access going back to at least 2003 and maybe 2002. Let's now take a closer look at exactly what is covered in today's class. In lesson 1, we are going to continue the Test Taker database that we started in Developer 9. This is Part 5. In this lesson, we are going to make a series of queries that will give us a list of the questions that have not been answered yet for the particular test being taken. In lesson 2, we are continuing the Test Taker. We are going to set up the form so we can click the Begin Test button and it is going to actually go out, look at the list of questions that have not been answered, and pull in the question data. In lesson 3, we are at Test Taker Part 7. Now we are going to actually put the question and answers up on the screen. We are going to write code so that when you pick an answer and submit it, the system can save that in the table, figure out if it is right or wrong, and then move on to the next question. In lesson 4, we are going to finish up today with the Test Taker Part 8. We are going to calculate the grade and store the results in the Test Result table. Thank you. IntroWelcome to Microsoft Access Developer Level 10. In this course we will continue building the Test Taker database from Level 9, covering how to generate queries for unanswered questions, set up the form to begin the test and pull in question data, display questions and answers while saving responses and determining correctness, and finally calculate the grade and store results in the Test Result table. This course is suitable for most versions of Microsoft Access and builds directly on the previous lessons, so it is recommended that you complete Level 9 first. QuizQ1. What is the main focus of Microsoft Access Developer Level 10? A. Continuing development of the Test Taker database started in Level 9 B. Building a Sales Management database from scratch C. Introduction to Access Beginner Series D. Designing forms for data entry only Q2. Why is it recommended to watch Developer Level 9 before taking Level 10? A. Level 10 assumes knowledge of parts 1 to 4 of building the Test Taker database B. Level 9 contains unrelated material C. Level 10 repeats all the content from Level 9 D. Level 9 is not part of the developer series Q3. What is a key outcome of Lesson 1 in Developer Level 10? A. Creating queries to list unanswered test questions B. Learning about relationships C. Creating user login forms D. Implementing a search filter for forms Q4. In Lesson 2, what functionality is added to the form? A. Begin Test button to pull question data for unanswered questions B. Exporting data to Excel C. Printing test results D. Sending email reminders to users Q5. What happens when a question is submitted in Lesson 3? A. The answer is saved, checked for correctness, and the next question is loaded B. The database automatically closes C. An email is sent to the administrator D. The form reloads with the same question Q6. What is covered in Lesson 4 of this course? A. Calculating the grade and recording results in the Test Result table B. Creating advanced lookup fields C. Designing a welcome screen D. Linking multiple databases Q7. Which versions of Microsoft Access does the material in Level 10 officially support? A. 2007 and 2016 B. 2010 and 2019 only C. Only Access 365 Online D. Only Access 2003 Q8. Which of the following is a benefit of learning the techniques covered in this course, even if you do not need a test database? A. Techniques, tricks, and tips are broadly useful in many Access applications B. Only applies to educational organizations C. Limited to test-taking scenarios only D. Only useful for creating reports Answers: 1-A; 2-A; 3-A; 4-A; 5-A; 6-A; 7-A; 8-A DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone continues building the Test Taker database in Microsoft Access, which we began in Access Developer Level 9. If you have not completed Level 9, I highly recommend starting there first, as the first four parts of creating this database are covered in that class. Even if you are not planning to create a test system for your personal or business needs, the methods and tips included in this database project will be valuable for anyone working with Access. Throughout this lesson, I will share a variety of techniques and strategies that can be applied to many different projects. I suggest going through my entire course catalog, starting from the beginner level and advancing through expert, advanced, and developer levels. Each series contains several levels with important lessons you should not miss. This video represents Level 10 in the developer series. If you would like to follow along using the sample database, you can download it from my website. The specific Test Taker database, including parts 1 to 4, is also available there. You will need the password to access those files. All of the concepts presented in today's class should be compatible with virtually every version of Microsoft Access. I provide official support for both Access 2007 and Access 2016. Personally, I am working with Access 2016 as part of Office 365, but everything we cover today should work as far back as Access 2003, and likely Access 2002 as well. Here is a breakdown of what we will cover in this lesson. In the first lesson, we will continue with the Test Taker database from Developer 9, as Part 5 of this project. We will create a set of queries designed to generate a list of questions that have not yet been answered for any given test session. The second lesson continues the Test Taker development. We will build a form with a Begin Test button that, when clicked, retrieves the list of unanswered questions and pulls in the relevant question data for the user to see. In lesson three, which is Part 7 of the Test Taker project, we will display each question and the possible answers on the screen. We will develop code that allows users to select an answer, submit their response, and have the system record it in the table. The system will determine if the answer is correct or not, and then automatically progress to the next question. For lesson four, we will wrap up by finishing Part 8 of the Test Taker series. Here, we will calculate the user's grade based on their answers and store their results in the Test Result table. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListCreating queries to list unanswered test questions Setting up the Begin Test button functionality Pulling question data for the current test Displaying questions and answers on a form Saving selected answers to the table Determining if submitted answers are correct Moving to the next question after submission Calculating the final test grade Storing test results in the Test Result table Primary Topicsquery design, form setup, answer storage, grading logic, test cycle automation, Access VBA Secondary Topicsdatabase version compatibility, test result calculation |
||
|
| |||
| Keywords: Access Developer, Test Taker database, query unanswered questions, grading automation, VBA form coding, save test answers, calculate grade, grade storage, test question form, Office 365 compatibility, Access Developer Level 10, Test Result table PermaLink How To Build a Test Taker Database With Grading and Test Results in Microsoft Access |
