Inserting, Importing, & Formatting Data in Access 2010 for Windows
Access 2010 (Windows)
| Intermediate
- 7 videos | 40m 36s
- Earns a Badge
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 36sOnce 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 34sOnce 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
-
3. Creating dropdown menus in Access 2010 for Windows4m 43sDrop-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
-
4. Adjusting your data validation settings in Access 2010 for Windows4m 44sAnother 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
-
5. Using external data in your database in Access 2010 for Windows6m 37sIf 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
-
6. Importing your address book from Outlook in Access 2010 for Windows5m 39sOne 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
-
7. Creating labels in Access 2010 for Windows7m 44sIf 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.
