5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office 2019     Access 2019

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.



Objectives

Access 2019: Inserting, Importing & Formatting Data

  • insert data into a table
  • modify the default navigation settings
  • use Excel data in a database
  • import an address book from Outlook
  • format text in the data
  • create a dropdown menu
  • create data validation rules
  • create labels