Selecting data from multiple tables

At this point, you’ve been through all the variations on a single theme—queries on a single table. However, for many tasks, you’ll need to build a query on multiple tables or queries (yes, you can build a query on a query!), calculate totals, and add parameters. It’s easy to build on the knowledge of single table queries to retrieve related information from many tables and to place that information in a single query datasheet. You’ll find this ability to select data from multiple tables very useful in designing views for your web app user interface.

Creating inner joins

A join is the link you need to define between two related tables in a query so that the data you see makes sense. If you don’t define the link, ...

Get Microsoft Access 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.