Saving, Printing & Exporting Databases in Access 2019 for Windows
Access 2019 (Windows)
| Beginner
- 6 videos | 20m 50s
- Includes Assessment
- Earns a Badge
- CPE
In this 6-video course, "Saving, Printing, and Exporting Databases," learners will discover how to save data, print database items, export a database, and send tables via email in Access 2019. To begin, learn how to save your data as a database or object, and then move onto saving regularly and repairing, backing up, and adjusting your database save settings. This leads learners into observing how to protect a database by adding password encryption if it contains confidential or sensitive data. Any object contained in your Access database can be printed, so you will next learn how to print items in your database. Furthermore, learn how to export data that you have compiled in your database to a different program; observe how Access allows you to export data in a variety of different formats including Excel spreadsheets, PDF files, and HTML formatted web pages. You will conclude the course by discovering how to send your database table via email using Access's integrated email function.
WHAT YOU WILL LEARN
-
Save data in accessRepair and back up a database, and adjust the save settingsUse password encryption to protect a database
-
Print items in a databaseExport data in various formatsSend a database table via email
IN THIS COURSE
-
3m 31sIf you want to be able to stop working on your database and return to it later on, you are going to need to know how to save it. Each individual object in your database file needs to be saved if you want to make sure that you do not lose any of your data. FREE ACCESS
-
3m 10sThere is nothing more frustrating than losing data you entered into your database. You can minimize the risk of losing your data by saving regularly. In Access, you can also create multiple copies of your database. FREE ACCESS
-
2m 49sIf your database contains confidential data, you can protect it by applying password encryption. The next time someone opens the file in Access, they will need to confirm that they have authorization to do so by inserting the password. FREE ACCESS
-
3m 53sAny object that you create in your Access database can be printed out. Using the print preview tool can help you to adjust the layout of your object, ensuring that your printout corresponds to your requirements. You can, for example, adjust your printout's margins, page size, and even orientation. FREE ACCESS
-
4m 47sIf you want to use the data that you have compiled in your database in a different program, you can export it. You will find that Access allows you to export your data in a variety of different formats, including Excel spreadsheets, HTML-formatted webpages (which can then be published online), and PDF files. FREE ACCESS
-
2m 41sIf you want to share your database table with a colleague, you can use Access's integrated email function. This tool will automatically create a new email (using your default mail client) with the data table attached using the format that you have chosen. After that, all you need to do is write the email and send it! FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.