Access Video Quiz B2.1
By Richard Rost
2 days ago
Why Downloaded Databases Show Security Warnings? Why does Microsoft Access display a security warning when you open a downloaded database? Welcome to another Microsoft Access Video Quiz. You will be asked five Beginner-level questions about preparing databases for use, security warnings and trusted locations, desktop shortcuts, and AutoNumber gaps. Answer each question, check your score, and see how well you know Microsoft Access. Recommended CoursesWant More?KeywordsAccess Video Quiz, Access trusted location, Access security warning, downloaded Access database, extract ACCDB from ZIP, active content warning, database desktop shortcut, AutoNumber gaps, AutoNumber values not consecutive, database setup
More InformationTranscript Time for another video quiz from Access Learning Zone.
This one's for beginners.
I got five questions about getting started with your Access databases. You'll have three seconds for each question. Pause if you need more time, and keep track of your score.
Let's see if you're ready for the keys to the vault.
Question 1.
You've downloaded an Access database inside a zip file. What's the best thing to do before working with it?
Work in the database directly inside the zip file, extract the database into a regular folder, rename the zip file to ACCDB, or import the zip file into a blank database.
That's going to be extract the database into a regular folder.
Question 2.
Why does Microsoft Access display a security warning when you open a downloaded database?
The database contains too many records. Access needs to update the file format. The database has no primary key. The database may contain active content that could be unsafe.
That is D, the database may contain active content that could be unsafe.
Question 3.
What's the purpose of a trusted location in Microsoft Access?
To allow trusted database files in that folder to run without the usual active content warnings, to automatically back up every database in that folder, to prevent users from changing the database structure, or to encrypt all database files stored in that folder.
That is A, to allow trusted files in the folder to run without the usual active content warnings.
Question 4.
You want a desktop icon that opens an Access database stored in another folder. What's the best solution?
Move the database onto the desktop, create a second copy of the database, create a desktop shortcut to the database, or export the database as a text file.
That'll be C, create a desktop shortcut to the database.
Question 5.
You delete a record from an Access table, leaving a gap in the AutoNumber sequence. What should you do?
Manually re-number all the remaining records. Change the AutoNumber field to short text. Reset the AutoNumber field so the numbers are consecutive. Or leave the gap alone, AutoNumber values don't need to be consecutive.
That is D.
Leave that gap alone. AutoNumbers don't need to be consecutive. AutoNumbers are not for you.
Alright, how'd you do?
Did you get 5 out of 5?
Are you the keeper who earned the keys to the gold reserve? Or the one who left the vault door open? Oops.
Well, if you missed any of these, these topics and more are covered in Microsoft Access Beginner Level 2.
Lesson 1 is all about getting your database ready to use and setting up good habits.
Thanks for playing. Post your score in the comments down below, and remember to lock the vault on your way out.
Until next time, live long and prosper. Intro Why does Microsoft Access display a security warning when you open a downloaded database? Welcome to another Microsoft Access Video Quiz. You will be asked five Beginner-level questions about preparing databases for use, security warnings and trusted locations, desktop shortcuts, and AutoNumber gaps. Answer each question, check your score, and see how well you know Microsoft Access. |
