Inserting, Importing & Formatting Data
Access 2019 (Windows)
| Intermediate
- 8 Videos | 31m 44s
- Includes Assessment
- Earns a Badge
- CPE
In this 8-video course, "Access 2019: Inserting, Importing, and Formatting Data," learners will discover how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with data. Begin the course by learning how to insert data into a table, and then explore how to modify the default navigation settings. In Access, you can import data that has been created or edited in a different program, which can save you the time required to manually reenter your data values or records. You will next learn how to use Excel data in a database. This leads into exploring how to import an address book from Outlook. Thereafter, learners will delve into formatting text in their data; creating a dropdown menu; and also creating data validation rules, which can be used to place limits on the information that can be inserted into access data tables. The course concludes by demonstrating how to create labels.
WHAT YOU WILL LEARN
-
insert data into a tablemodify the default editing settingsuse external data in a databaseimport an address book from Outlook
-
format data in tablescreate a dropdown menucreate data validation rulescreate labels
IN THIS COURSE
-
1.Inserting data into your table3m 8sUP NEXT
-
2.Modifying the default editing settings3m 21s
-
3.Using external data in your database4m 2s
-
4.Importing your address book from Outlook3m 56s
-
5.Formatting your data3m 53s
-
6.Creating dropdown menus4m 15s
-
7.Creating data validation rules4m 56s
-
8.Creating labels4m 14s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.