Inserting, Importing & Formatting Data

Access 2019 (Windows)    |    Intermediate
  • 8 Videos | 31m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 21 Likes 21
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 180 Likes 180  
Likes 16 Likes 16  
Likes 112 Likes 112  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 15 Likes 15  
Likes 50 Likes 50  
Likes 233 Likes 233