Inserting, Importing & Formatting Data

Access 2019 (Windows)
  • 8 Videos | 31m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 15 Likes 15
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

  • Playable
    1. 
    Inserting data into your table
    3m 8s
    UP NEXT
  • Playable
    2. 
    Modifying the default editing settings
    3m 21s
  • Locked
    3. 
    Using external data in your database
    4m 2s
  • Locked
    4. 
    Importing your address book from Outlook
    3m 56s
  • Locked
    5. 
    Formatting your data
    3m 53s
  • Locked
    6. 
    Creating dropdown menus
    4m 15s
  • Locked
    7. 
    Creating data validation rules
    4m 56s
  • Locked
    8. 
    Creating labels
    4m 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.

YOU MIGHT ALSO LIKE

Likes 14 Likes 14  
Likes 75 Likes 75  
Likes 13 Likes 13  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 132 Likes 132  
Likes 13 Likes 13  
Likes 16 Likes 16