Thursday, April 28, 2005

Excel

Chapitre 5

  1. Cliquer deux fois sur la croix noire pour recopier sa formule jusqu'à la fin d'une colone.

Général

  1. Pour cacher un objet dans une page, activer la barre de dessin, créer une boite blanche, sans bordure. Puis placez la sur l'objet a cacher.

Access

General

  1. Study and use all the toolbar buttons.

Chapter 6

  1. Entering data, problem with key, index, etc.
    Press the ESC key TWO times to start a record over.
  2. CTRL+' to copy previous record data.
    Forget it! You will anyway, use ARROW UP, CTRL+C (copy) then ARROW DOWN, CTRL+V (Paste).

Chapter 10:

  1. Click FORMS then NEW then use the WIZARD for maximum control. For SPEED, use autyform columnar.

Chapter 16:

  1. Click REPORTS then NEW then use the WIZARD for maximum control. For SPEED, use autorepoirt tabular.

Windows

Chapter 5: Windows Explorer

  1. Run your Windows Explorer.
    The fastest way to run it is to press WINDOWS+E keys on your keyboard. This will also show all your drives right away.
  2. Organize your screen.
    To see both panes, make sure you click the Folders button.
  3. To copy and paste files.
    Just SELECT your files in the right pane, press CTRL+C, then, in the left pane, SELECT the destination folder and press CTRL+V.