October 1997
Intermediate to advanced
1312 pages
38h 56m
English
Your purpose in acquiring Access is undoubtedly to take advantage of this application's relational database management capabilities. To do so, you have to be able to link related tables based on key fields that have values in common—a process known as a join in database terms. Chapters 8, "Using Query by Example," and 9, "Understanding Operators and Expressions in Access," showed you how to create simple queries based on a single table. If you tried the examples in Chapter 9, you saw a glimpse of a multiple-table query when you joined the Order Details table to the Orders table, which you then joined to the Customers table to create the query for testing expressions. The first part of this ...
Read now
Unlock full access