Inserting, Importing & Formatting Data in Access 2019 for Windows
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 table
Modify the default editing settings
Use external data in a database
Import an address book from outlook -
Format data in tables
Create a dropdown menu
Create data validation rules
Create labels
IN THIS COURSE
-
3m 8sOnce you have created a data table in Access, you can begin to add values and records. A record is a collection of related data values, organized according to the fields found in the table. A customer record, for example, could contain information such as the individual's first name, last name, title, and telephone number. FREE ACCESS
-
3m 21sIf you use Access a lot, you may find it useful to know how to customize the way in which you edit and move between records. By default, using the enter or arrow keys on your keyboard will take you to the next field in a record. If however you want to change that, you can do so via the Access options menu. FREE ACCESS
-
3. Using external data in your database in Access 2019 for Windows4m 2sIn Access, you can import data that was created or edited in a different program. This can spare you having to manually re-enter your data values or records. You can, for example, use the import to tools to transfer data taken from an Excel spreadsheet into your database. FREE ACCESS
-
4. Importing your address book from Outlook in Access 2019 for Windows3m 56sIf you have a number of contact entries stored in your Outlook address book and you want to use that data in Access you can import it into your database. This can save you having to copy and add the data by hand. In Access, you can define the data that is imported, the format that is applied, and even the primary key used to identify unique records. FREE ACCESS
-
5. Formatting your data in Access 2019 for Windows3m 53sIn Access, you can make your data tables more attractive by changing the formatting settings applied to your fields, records and values. You can change the font, size, effects and even color of the data values that you have inserted into your tables. FREE ACCESS
-
6. Creating dropdown menus in Access 2019 for Windows4m 15sDropdown menus can be used to speed up data entry in your tables and limit the likelihood of spelling mistakes or typing errors appearing your records. In Access, you can create your own data tables, specify exactly which values can be inserted, and even prevent users from diverging from your preset list. FREE ACCESS
-
7. Creating data validation rules in Access 2019 for Windows4m 56sData validation rules can be used to place limits on the information that can be inserted into your Access data tables. You can, for example, require users to complete a particular field before the record can be validated. You can also ensure that certain fields contain only unique values, thereby reducing the risk of duplicate entries. You can even use formulae and operators to validate certain data values. FREE ACCESS
-
8. Creating labels in Access 2019 for Windows4m 14sThe data that you have added to your Access database can be presented in label form. You can, for example, extract the name and address data for individual customers and organize it into a sheet of labels, which can then be printed out. 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.
