In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports.

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.