Using Queries

Databases can contain enormous amounts of data. They can be made of dozens of tables, with each table containing hundreds of records, and each record consisting of many fields. The amount of data in a database can be overwhelming.

The goal of any database is to provide a place to organize and store large amounts of information, which you can then query for subsets of data. A query consists of search criteria that you specify. You define the search criterion and run the query, and the query searches the entire database for data that matches the specified criteria. If matching data is found, the query returns only those records that contain the matching data. By defining and running queries, you can quickly extract the particular ...

Get Inside AutoCAD® 2002 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.