25.8.20
This website uses cookies to ensure you get the best experience on our website. Learn more

Inserting, Importing & Formatting Data in Access 2019<br> for Windows

Caitlyn Caddell

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.

Issued on

February 24, 2023

Expires on

Does not expire