Course details

Access 2019: Inserting, Importing & Formatting Data

Access 2019: Inserting, Importing & Formatting Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.5

Lesson 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
  • Course Number:
    ds_msac2019_04_enus

    Expertise Level
    Intermediate