• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Working with Lists and Datab... > Creating Links to External Databases

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 (page 638) 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint