Office Live – Adding data to a datasheet

Even if you are brand new to contact management and have to start building a database from scratch, you’ll probably find entering multiple records is easier in a datasheet rather than through individual forms.

To open a datasheet, follow these steps:

  1. Click Business Contact Manager from the Navigation bar on the Office Live Home page.
  2. Click the tab that contains the list you want to enter data for.
  3. Select the view you want to work with.
  4. Choose Edit in Datasheet from the Actions drop-down menu.
  5. Scroll to the bottom of the list and start to enter your data in the bottom row of the datasheet.

Business Contact Manager makes this task pretty easy. The column headers stay in sight, no matter how far down you scroll in the list. You can also press Tab to advance from one field to the next. When you get to the end of a record, your cursor immediately jumps to the next row, which is blank and just waiting for your data. You’ll also see that if you start to type something that is already in the datasheet — for example Chicago or United States — the word autocompletes and you can move on to the next field.

I can think of few chores that are more boring than contact entry. Although Office Live doesn’t allow for the ability to import data, you can copy the information from a spreadsheet and paste existing information into a datasheet. If the order of your datasheet column headings match those of the spreadsheet, just place your cursor in the first empty row and paste away. If your columns don’t match, you can still paste in your information one column at a time.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>