Create a select query that totals a group of records by using the Design view. Create a parameter query by using the Design view. Create a crosstab query by using the Crosstab Query Wizard. Specify multiple search criteria in a query to display specific records by using the Design view. Modify the properties of a field in a query.
Filter records in a query.
Change the type of join between two tables in a query. Remove the join between two tables in a query. Optimize a query by indexing the table on a field. Customize the form sections by using the Design view. Set the properties of a section in a form by using the Section dialog box.