Using Microsoft Access to Find Duplicates, Modify, Combine, and Present Data

Microsoft Access has several other types of queries that identify duplicates, modify, combine, and present data in a robust format for your forms and reports. This video gives an overview of each type of query, how to build them, run them, and modify them.
I cover:
1. Aggregate queries,
2. Make Table queries,
3. Delete queries,
4. Append queries,
5. Update queries, and
6. Crosstab queries.

[satyabanukil]

How get sum of multiple fields in a single query