98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Access articles
Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
Mon 25th June 2007
If you were to open a Microsoft Access file in a program other than Access, it would at first look like a mess of odd characters. However, if you were to really dig around, you would be able to find some bits of information stored in your database. To prevent this you'll want to encrypt your database. Once you encrypt your database, some functions may perform slower when you're working with your database. To solve this, you'll want to decrypt your database while working with it.
You can learn more about encrypting and decrypting in classroom based Access Database Courses, but this Quick Course will give you how to accomplish these important tasks and allow you to test your work.
Let's get started!
1. Open an existing Access database.
2. Hover over the tools menu to reveal the submenu, then choose security and then encode/decode database.
3. Save the file as filename_encode in your folder of choice. Close the database and click "yes" to block unsafe features if necessary.
4. Open 2 blank text editors such as notepad.
5. In one text editor, open the encoded file and in the other, open the non encoded file. Although the non encoded file may seem like gibberish, there are still pieces of information throughout the file. However, you'll notice that it is impossible to read the encrypted file.
6. Close your text editors and navigate back to Access to learn how to decrypt a file. You'll need to close Access and restart for the new security features to take effect.
7. Open the filename_encode database file and navigate through the safety warning by clicking "open" if necessary.
8. Hover over the tools menu to reveal the submenu, then choose security and then encode/decode database.
9. Save the file as filename_decode. Your database is now unencrypted!
10. To check your work, start another a blank text editor and open the unencrypted document and compare all 3 side by side. You'll see that the two unencrypted documents are identical!
You may be surprised at the simplicity of this and other Quick Access Database Courses. Many people are under the impression that Access is a difficult program to work with, but then find it to be surprisingly easy after taking one or two Access database courses.
To really get fancy with your databases, you'll probably want to invest a few days in some classroom based Access database courses, but what you'll discover is well worth the investment. You, your co-workers, or if you're a manager, your staff will likely find countless ways to increase their productivity and make their jobs more simple after a couple of Access database courses.
Author is a freelance copywriter. For more information on booking Access database courses, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-198-access-database-courses.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsWine & Spirit Education Trust
Quality Assurance Assistant Chloe Challis Effective Communication Skills I cannot fault the training today. It was an enjoyable and informative course delivered with enthusiasm and great care for the audience. A great balance between learning and active participation. PSI CRO AG
CRA Pablo Rios Writing for Impact Please keep going! good job. I'm waiting the training for tomorrow. Thanks Sarah Cannon Research UK
Clinical Trial Assistant Janet Shadare Project Introduction The trainer was great! It took me a while to get my head around things, but he was very patient and offered help when needed. |
PUBLICATION GUIDELINES