For best results: this site requires that cookies be enabled for proper operation - see Legal Page for more info

Select Any of These

MS Access 95 and earlier

LAST UPDATED: 08 November 2007 18:29:53 -0600

ACCESS: CONVERTING AN EXCEL LIST TO AN ACCESS LIST

EVERYBODY LOVES A SHORTCUT    MORE ACCESS SHORTCUTS

ACCESS: CONVERTING AN EXCEL LIST TO AN ACCESS LIST

If you've developed a customer list in Excel that's becoming large and cumbersome, consider converting it to an Access list. To do this, click anywhere in the list and choose Data, Convert To Access. A wizard will open and guide you through the conversion. We can't describe the process in more detail because the choices you make in the wizard depend on your specific list. After the conversion is finished, you'll get a message informing you of the new file's name and location.

EVERYBODY LOVES A SHORTCUT

Since everyone likes shortcut keys, here's a collection for Access.

Display Control menu: Alt-Spacebar
Open Replace dialog box: Ctrl-H
Open new database: Ctrl-N
Open existing database: Ctrl-O
Paste the Clipboard contents at the cursor: Ctrl-V
Copy to the Clipboard: Ctrl-C
Cut to the Clipboard: Ctrl-X
Undo: Ctrl-Z
Open Find: Ctrl-F

Stay tuned for more Access shortcuts next time.

MORE ACCESS SHORTCUTS

Here are some more shortcuts you can use inside a database window:

Move up a single line: Up Arrow
Move down a single line: Down Arrow
Move up one window: Page Up
Move down one window: Page Down
Move to the first object: Home
Move to the last object: End

Questions?

Just Check out some of our sponsors

Shop at BestPrices.Com!

COPYRIGHT 1998 - 2008 All names used are Trademarks of the respective companies

[ Home ] [ Up ]

Send mail to CompanyWebmaster  with questions or comments about this web site.
Copyright © 2007 HALO Computer Technology
Last modified: 02/14/08