Inserting, Importing, & Formatting Data in Access 2010 for Windows

Access 2010 (Windows)    |    Intermediate
  • 7 videos | 40m 36s
  • Earns a Badge
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Once you've created fields in Access 2010, you can begin entering and formatting data. Discover how to add and format data, create dropdown menus, configure data validation, use external data, import an address book, and create labels.

WHAT YOU WILL LEARN

  • Inserting data into your table
    Formatting your data
    Creating dropdown menus
    Adjusting your data validation settings
  • Using external data in your database
    Importing your address book from outlook
    Creating labels

IN THIS COURSE

  • 5m 36s
    Once your fields have been created, you can begin entering your data. The rows that you insert are known as records, and can contain multiple types of data. In this video tutorial, you will find out how to insert text and numerical data, and how the different field formats can ensure that you insert the correct data format. FREE ACCESS
  • 5m 34s
    Once you have inserted your data into your table, it can be formatted. You can, for example, change the font style, text size, or even the color settings. You will find out how to make these changes in this video tutorial. FREE ACCESS
  • Locked
    3.  Creating dropdown menus in Access 2010 for Windows
    4m 43s
    Drop-down menus are extremely useful if you want save time when entering data, and also if you want to place a limit on the data values that can be inserted into a particular field. This video tutorial will show you how to define the list of values and how to create your time-saving data entry method. FREE ACCESS
  • Locked
    4.  Adjusting your data validation settings in Access 2010 for Windows
    4m 44s
    Another way of controlling the data that is inserted into your table is to use the data validation tools. These tools can be used to create rules to which records have to adhere in order to be authorized. In this video tutorial, you will find out how to create a data validation rule which can alert you when there is a problem with the record that has been inserted. FREE ACCESS
  • Locked
    5.  Using external data in your database in Access 2010 for Windows
    6m 37s
    If you don't want to manually insert data into your database, you can import data into your file from an external source. In this video tutorial, you will find out how import data from an Excel spreadsheet and insert it into your database. FREE ACCESS
  • Locked
    6.  Importing your address book from Outlook in Access 2010 for Windows
    5m 39s
    One source from which data for your database can be extracted is your Outlook account. Access 2010's import wizard can help you to locate your address book in Outlook and import the data directly into your database. This video tutorial will show you how to do this. FREE ACCESS
  • Locked
    7.  Creating labels in Access 2010 for Windows
    7m 44s
    If you are creating a mail-out and you want to use the address data that you have inserted into your database, you can use the label creation wizard. In Access 2010, this wizard can help you to create a label template which will then organize your data into a document which can be exported, saved, or simply printed out. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Rating 4.0 of 6 users Rating 4.0 of 6 users (6)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
Rating 4.4 of 39 users Rating 4.4 of 39 users (39)
Rating 4.4 of 71 users Rating 4.4 of 71 users (71)