O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Links to External Databases

For basic list-management tasks, such as sorting, searching, grouping, and summarizing, Excel is an appropriate, easy-to-use tool. For large and complex databases, however, you have better choices, including Microsoft Access. Choose Access over Excel if any of the following statements is true:

  • You need to combine data from multiple tables.

  • You want to create custom data-entry forms and highly formatted reports.

  • You want to create a secure application that multiple users can work with simultaneously.

  • Your list contains more than 65,536 records.

  • You want to store sounds, pictures, or other data besides text and numbers.

If your database needs have outgrown Excel's list-management capabilities, let a more powerful ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required