Database Reference
In-Depth Information
Make Table
button
58
Table to contain
the query results
Query to select
records to add to
the new table
New table will
be saved in the
current database
FIGURE 2-38
Make Table dialog box
After closing the Make Table dialog box and running the make-table query, the records it selects are
added to a new table named CustomerRep in the current database. Figure 2-39 shows the new CustomerRep
table created by the make-table query.
Fields from
the Customer
table
New table
Fields from
the Rep table
FIGURE 2-39
CustomerRep table created by the make-table query
RELATIONAL ALGEBRA
Relational algebra is a theoretical way of manipulating a relational database. Relational algebra includes opera-
tions that act on existing tables to produce new tables, similar to the way the operations of addition and sub-
traction act on numbers to produce new numbers in the mathematical algebra with which you are familiar.
