Access Video Quiz A3.2
By Richard Rost
6 hours ago
Can Macro SetValue Use Back Style Text Values? When a macro changes a control's Height or Width property, what unit does Access use? Welcome to another Microsoft Access Video Quiz. You will be asked five advanced-level questions covering form properties, control events, fonts, macro property values, and references to form sections. Answer each question, check your score, and see how well you know Microsoft Access. Recommended CoursesWant More?Keywords Access Video Quiz, Access macros, SetValue action, control Height Width twips, Got Focus event, Lost Focus event, text box resize, Font Name property, Back Style property, Detail section Back Color, form section references
More InformationTranscript Welcome to another video quiz from Access Learning Zone.
This one's for advanced users. You get five questions covering Access form properties and macros. You'll have three seconds for each question. Hit the pause button if you need more time. Keep track of your score. Are you ready? Here we go.
Question 1.
When a macro changes a control's Height or Width property, what unit does Access use? Screen pixels, twips, inches, or points.
That is going to be twips. You'll be a little twip.
Question 2.
You want a text box to expand while the user is editing it and return to normal afterwards. Which event setup is most appropriate?
A. Expand it on Click and shrink it on Double Click.
B. Expand it on Load and shrink it on Close.
B. Expand it on Got Focus and shrink it on Lost Focus.
Or D. Expand it in Before Update and shrink it in After Update.
That'll be C. Expand it on Got Focus and shrink it on Lost Focus.
Question 3.
Why is it usually best to use a common Windows or Office font when setting a control's Font Name in an Access application?
A missing custom font can produce unreliable or substituted results on another computer. Access can assign Font Name only to labels, not text boxes. Custom fonts can be used only in reports. Or font names must always be numeric values.
That is, a missing custom font can produce unreliable or substituted results on another computer. My favorite is Tahoma.
Question 4.
A macro uses SetValue to change a text box's Back Style. Why can't assigning the text "Normal" cause an error?
Back Style can be changed only in VBA. SetValue can modify only bound fields. Back Style must be assigned a color expression such as RGB. Or Back Style uses a numeric property value rather than a displayed word.
That'll be D. Back Style uses a numeric property rather than the displayed word.
And question 5.
In a macro, which reference targets the Back Color of the Detail section in an open form named Customer F?
Take a look at your four options. Pause if you need to and figure it out. Because I'm not going to sit here and read them all.
There you go, it's B. Forms, Bang, Customer, F, Bang, Detail, Dot, Back Color.
And yes, there are other ways to refer to that, but of the options shown, that's the right one.
Alright, how'd you do? Did you achieve desktop nirvana with zero fatal exceptions? Or are you still waiting patiently for this CD-ROM to spin up?
Well, if you missed any, these topics and a lot more are covered in Access Advanced Level 3, Lesson 2.
Alright, thanks for playing. Post your score in the comments down below, and try not to blame the modem if you missed a few.
And until next time, live long and prosper. Intro When a macro changes a control's Height or Width property, what unit does Access use? Welcome to another Microsoft Access Video Quiz. You will be asked five advanced-level questions covering form properties, control events, fonts, macro property values, and references to form sections. Answer each question, check your score, and see how well you know Microsoft Access. |
