Access Video Quiz A4.1
By Richard Rost
6 hours ago
Can Input Box Hide Typed Password Characters? What protection does a password button alone provide? Welcome to another Microsoft Access Video Quiz. You will be asked five advanced-level questions about password prompts, including macro logic, shared password settings, masked password entry, access limitations, and using DLookup criteria to retrieve the correct password. Recommended CoursesWant More?Keywords Access Video Quiz, Access password prompt, password protected form, custom password form, password masked text box, InputBox password masking, macro If condition, OpenForm conditional, DLookup criteria, settings table password, payroll form security
More InformationTranscript Welcome to another video quiz from Access Learning Zone.
This one's for advanced students, with five questions about password prompts in Microsoft Access.
You'll have three seconds per question, so hit pause if you need more time. Keep track of your score. We'll see how you did at the end.
Your lab credentials are up for review. Let's get to question one.
This macro opens Payroll F even when the passwords differ. What makes it open only when they match?
Move OpenForm above the If block.
Put OpenForm in an Else branch.
Show incorrect password before OpenForm.
Move OpenForm inside the matching password If block.
That'll be D. Move OpenForm inside the matching password If block.
And why store a shared application password in one settings table instead of writing it into every button macro?
It automatically hides the password from users.
One saved change can be reused by every macro that looks it up.
It removes the need to compare the user's entry.
It automatically refreshes every open form.
One saved change can be reused by every macro that looks it up.
Question three. An Access macro uses an input box to request a password. Users should see asterisks instead of characters they type. Which approach supports this?
Use a custom form with a password-masked text box.
Apply a password input mask only to the table field.
Put asterisks in the input box's default response.
Change the input box's title to password.
That would be use a custom form with a password-masked text box.
Question four. A menu button asks for a password before opening a payroll form. Users can still open the table containing that password as plain text. What protection does this button alone provide?
It encrypts the entire database.
It prevents users from opening every table.
It checks that menu button route, not every access path.
It prevents users from copying the database file.
It checks that menu button route, not every access path.
In question five, DLookUp retrieves one value from a table. Settings T has one password record per department. How can a macro reliably retrieve payroll's password?
Sort payroll to the top.
Add criteria for the unique payroll row.
Rename the receiving variable.
Run the same lookup twice.
That would be add criteria for the unique payroll row.
All right, how'd you do? Did you get all five? Are you saving the lab from a security meltdown, or did you give the penguin your password?
Well, if you missed any of these questions, these topics and more are covered in Microsoft Access Advanced Level 4 Lesson 1, all about building a password prompt.
Thanks for playing. Post your score in the comments down below unless, of course, it's classified.
Until next time, live long and prosper. Intro What protection does a password button alone provide? Welcome to another Microsoft Access Video Quiz. You will be asked five advanced-level questions about password prompts, including macro logic, shared password settings, masked password entry, access limitations, and using DLookup criteria to retrieve the correct password. |
