Summary

As you can see, Microsoft provides a sophisticated query builder for constructing complex and powerful queries. In this hour you have learned how to work with calculated fields and advanced filters. You have also learned how you can use parameters to supply variable criteria to Parameter queries at runtime. Action queries let you modify table data without writing code; you can use these queries to add, edit, or delete table data. Finally, you have learned how to incorporate aggregate functions into queries and how to refine queries with field, field list, and query properties.