Access Developer 10 continues our focus on learning how to program the Visual Basic for Applications programming language (VBA) in Microsoft Access.
This is the introduction video only. The full course is 1 hour and 30 minutes long and can be found on my web site at http://599CD.com/XAPEVI
This class continues our look at programming in Visual Basic for Applications in Microsoft Access (VBA, or Access VB). We will continue building the Test Taker database that we started in Developer 9. We'll begin by determining the questions that have not been answered for the current test session. This will involve a series of three related queries.
In Lesson 2, we'll click on the Begin Test button, it will look at the list of unanswered questions, select the next question to be asked (by the Order field we created), and then display the question data.
Now we're going to display the multiple choice answers on the screen. We'll get the answer from the user and determine whether it's correct or not. Save that information in the test session table.
In Lesson 4 we're going to calculate the grade and store the final results in the test session table.
This is the 10th class in the Access Developer series. If you're serious about building quality databases with Access, and you want to learn how to automate your database with VBA Programming then don't miss out on this course. Of course, if you have any questions about whether or not this class is for you, please contact me.
00. Intro ( 2:51)
01. Test Taker 5 ( 22:09)
Figure Out Which Question to Ask
TestResultQ
Show Unanswered Questions for Test
QuestionsCurrentTestQ
AnswersCurrentTestQ
MissingAnswerQ
Set Order Default to Max +1
02. Test Taker 6 ( 9:40)
Get the Question
Fields to Display Q&As
Add Scroll Bars to Text Box
Display Next Question Sub
Required Order Value
Validation Rule 0
03. Test Taker 7 ( 36:26)
Answer Given Text Box
Answer List Box
Determine if Multiple Choice
Display Text or List Box
Check Answer for Correctness
NZ with False
StrComp() if Case Sensitive
04. Test Taker 8 ( 15:31)
Calculate Grade
Store in TestResultT
ROUND Function
05. Review ( 3:30)
Learn more about Microsoft Access here:
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://www.microsoft.com/en-us/micro...
This is the introduction video only. The full course is 1 hour and 30 minutes long and can be found on my web site at http://599CD.com/XAPEVI
This class continues our look at programming in Visual Basic for Applications in Microsoft Access (VBA, or Access VB). We will continue building the Test Taker database that we started in Developer 9. We'll begin by determining the questions that have not been answered for the current test session. This will involve a series of three related queries.
In Lesson 2, we'll click on the Begin Test button, it will look at the list of unanswered questions, select the next question to be asked (by the Order field we created), and then display the question data.
Now we're going to display the multiple choice answers on the screen. We'll get the answer from the user and determine whether it's correct or not. Save that information in the test session table.
In Lesson 4 we're going to calculate the grade and store the final results in the test session table.
This is the 10th class in the Access Developer series. If you're serious about building quality databases with Access, and you want to learn how to automate your database with VBA Programming then don't miss out on this course. Of course, if you have any questions about whether or not this class is for you, please contact me.
00. Intro ( 2:51)
01. Test Taker 5 ( 22:09)
Figure Out Which Question to Ask
TestResultQ
Show Unanswered Questions for Test
QuestionsCurrentTestQ
AnswersCurrentTestQ
MissingAnswerQ
Set Order Default to Max +1
02. Test Taker 6 ( 9:40)
Get the Question
Fields to Display Q&As
Add Scroll Bars to Text Box
Display Next Question Sub
Required Order Value
Validation Rule 0
03. Test Taker 7 ( 36:26)
Answer Given Text Box
Answer List Box
Determine if Multiple Choice
Display Text or List Box
Check Answer for Correctness
NZ with False
StrComp() if Case Sensitive
04. Test Taker 8 ( 15:31)
Calculate Grade
Store in TestResultT
ROUND Function
05. Review ( 3:30)
Learn more about Microsoft Access here:
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://www.microsoft.com/en-us/micro...
Microsoft Access Developer Level 10 - Introduction access denied | |
8 Likes | 8 Dislikes |
490 views views | 164K followers |
Education | Upload TimePublished on 1 Sep 2018 |
Không có nhận xét nào:
Đăng nhận xét