|
||||||
|
|
Access Developer 45 Lessons Welcome to Access Developer 45. Total running time is 76 minutes.
Lessons
DownloadsLinks
Resources
Questions?Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you! Subscribe for UpdatesIf you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.
QuizQ1. What is the primary focus of Microsoft Access Developer Level 45?A. Creating detailed reports B. Customizing ribbons and menus C. Building complex queries D. Advanced data analysis techniques Q2. In the context of Access, what is the "Backstage"? A. The main form B. Another name for the Developer Toolbox C. The File menu D. The Reports menu Q3. Which table does the tutorial recommend replacing for storing custom ribbons? A. USysRibbons B. UseRibbons C. RibbonT D. SysRibbonCustom Q4. What function is used to load custom ribbons when the database starts up? A. Application.LoadUI B. Application.StartRibbon C. Application.LoadCustomUI D. Application.InitializeRibbons Q5. In Lesson 1, which menu option on the Backstage menu cannot be hidden? A. Home B. Print C. Save D. Share Q6. What is the purpose of the CommandBar objects collection? A. To manage database security B. To customize the Access user interface C. To populate forms with data D. To create reports Q7. In Lesson 2, what is added to the Backstage menu? A. New ribbon commands B. Custom functions C. New items like categories and buttons D. Custom queries Q8. What command is used to hide the ribbon completely? A. DoCmd.HideRibbon B. DoCmd.ShowToolbar Ribbon, acToolbarNo C. DoCmd.RemoveRibbon D. Application.HideRibbon Q9. How do you customize the Quick Access Toolbar for specific forms or reports? A. By changing File Options B. By creating custom code in the VBA editor C. By using a custom XML file D. By using macros Q10. In Lesson 4, how is the new ribbon table structured? A. RibbonID, RibbonXML, RibbonType B. RibbonID, RibbonName, RibbonXML C. RibbonName, RibbonData, RibbonType D. RibbonID, RibbonName, RibbonData Q11. In the tutorial, which method is recommended for identifying built-in button IDs? A. Using online documentation B. Trial and error C. Looping through all the controls D. Command prompt commands Q12. How can one add custom images to buttons in context menus? A. By using Face IDs or loading an image from a file B. By using only Face IDs C. By using only image URLs D. By adding images through the Access options Q13. What are FaceIDs used for in context menus? A. Identifying different versions of Access B. Specifying icons for built-in buttons C. Naming custom context menus D. Setting up database relationships Q14. Which of the following is NOT an example of a control type added to context menus? A. MSO_CONTROL_BUTTON B. MSO_CONTROL_IMAGE C. MSO_CONTROL_POPUP D. MSO_CONTROL_DROPDOWN Q15. Why is it recommended to use late binding for objects like CommandBar in VBA? A. For easier debugging B. To ensure portability across different user environments C. For faster performance D. To reduce code complexity Q16. Which Microsoft Office tool's object library can be referenced for more context menu options in VBA? A. Microsoft Word B. Microsoft Excel C. Microsoft Office D. Microsoft PowerPoint Answers: 1-B; 2-C; 3-C; 4-C; 5-A; 6-B; 7-C; 8-B; 9-B; 10-B; 11-C; 12-A; 13-B; 14-B; 15-B; 16-C 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. |
||||||||||||||||||||||||||||||||||
|
| |||
| Keywords: access developer 45 lessons PermaLink Access Developer 45 Lessons |