Yes.
A report's record source can be a query or SQL statement containing more
than one table.
You can also place subreports on a main report.
There are several controls that have a Row Source property that can
reference another table.
You can also write code in your report to pull values from other tables.
The aggregate domain function such as DLookup() and DSum() can pull values
from other tables.