8. Linking, Importing, and Exporting Data

Undoubtedly, every personal computer user has data that can be processed through database-management techniques. Any data that a computer can arrange in tabular form—even tables in word processing files—can be converted to database tables. The strength of a relational database management system (RDBMS) lies in its capability to handle large numbers of individual pieces of data stored in tables and to relate the pieces of data in a meaningful way.

PC users turn to RDBMSs when the amount of data created exceeds a conventional productivity application’s capability to manipulate the data effectively. A common example is a large mailing list created in Microsoft Excel or Word. As the number of names in the ...

Get Microsoft® Access® 2010 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.