Creating a Query in Design View To sort a field in ascending or descending order
Open the table in Datasheet view.
Click anywhere in the column you want to sort, and then click the Sort Ascending or Sort Descending button.
To reverse the sort order, click the opposite Sort button.
To sort on more than one column of information, arrange the columns so that they are side-by-side in the order you want to sort them, select the columns, and then use the Sort buttons.
Filtering Information in a Table To filter a table by selection
Open the table in Datasheet view.
Click any instance of the selection by which you want to filter, and then click the Filter By Selection button.
Filtering Information in a Table To remove a filter
Filtering Information in a Table To exclude a field from a filter process
Filtering by Form To filter by form in a form
Open the table or form you want to work with in either Datasheet or Form view.
Click the Filter By Form button on the toolbar.
Click the field or fields in which you want to create the filter, type the filter criteria you want, and press
; or select the criteria from the list of options. (Repeat this step for any other fields you want to filter.)To add additional filter criteria for a particular field, click the Or tab and enter the criteria as necessary.
Click the Apply Filter button.
Locating Information that Matches Multiple Criteria To filter by multiple criteria
Open the table in Datasheet view.
On the Records menu, point to Filter, and then click Advanced Filter/Sort.
If the design grid is not blank, on the Edit menu, click Clear Grid.
Select the criteria by which to filter.
On the Filter menu, click Apply Filter/Sort to view the records that match the criteria.
Creating a Query in Design View To create a select query in Design view
On the Objects bar, click Queries.
Double-click Create query in Design view.
In the Show Tables dialog box, double-click each table that you want to include in the query, and then close the dialog box.
To include a field in the query, drag it from the field list at the top of the window to consecutive columns in the design grid. To copy all fields to the grid, double-click the title bar above the field list to select the entire list, and then drag the selection over the grid.
Click the Run button to run the query and display the results in Datasheet view.
Creating a Query in Design View To add an expression to a query
Open the query in Design view.
Right-click the appropriate cell in the design grid, and then click Build on the shortcut menu.
In the Expression Builder dialog box, double-click the Functions folder in the first column of the elements area, and then click Built-in Functions.
Build your expression, and then click OK.
Press
to move the insertion point out of the field, which completes the entry of the expression.To rename the expression, double-click Expr1, and then type the name you want.
Click the Run button to run the query and see the results in Datasheet view.
Creating a Query with a Wizard To create a query by using a wizard
On the Objects bar, click Queries, and then double-click Create query by using wizard.
In the Tables/Queries list, click the table on which you want to base the query.
Double-click each field that you want to include in the query to move it to the Selected Fields list.
If you want to include more than one table in your query, repeat steps 2 and 3.
Follow the instructions of the Simple Query Wizard, and then click Finish to complete the process and see the results.
If you want to use a field in a query but don’t want to see the field in the results datasheet, click the View button to switch to Design view, and then clear the Show check box for fields you don’t want to display.
Switch to Datasheet view to see the results.
Performing Calculations in a Query To perform a calculation in a query
Open the query in which you want to perform a calculation.
Click in the field in which you want to perform the calculation, and then click the Totals button on the toolbar.
In the new Totals cell for the field, click the down arrow, and then click the calculation you want to perform from the drop-down list.