Microsoft Office Tutorials and References
In Depth Information
Establishing Relationships Between Database Tables
Establishing Relationships Between Database Tables
As Chapter 1 of this mini-book explains, you have to establish relationships
between tables if you want to query or generate reports with data from more
than one database table. Relationships define the field that two different
tables have in common. To understand why relationships between tables
are necessary, consider the query shown in Figure 2-10. The purpose of this
query is to list all companies that ordered items in 2012, list the companies
by name, and list the city and country where each company is located.
Figure 2-10:
To conduct
a query with
more than
one table,
the tables
must have a
relationship.
Consider what Access does to run this query:
Access deals with two database tables, Customers and Orders.
In the Orders table, Access looks in the Order Date field to isolate all
records that describe orders made in the year 2009. The expression
for finding these records is shown on the Criteria line in Figure 2-10:
Between #1/1/2012# And #12/31/2012#.
Search JabSto ::




Custom Search