Lab Work

Lab Work (11/03)

To open a database (A 2.06)
To create a query (A 2.06)
To include fields in the design grid (A 2.10)
To run the query (A 2.11)
To return to the select query window ( A 2.12)
To close the query (A 2.13)
To include all fields in a query (A 2.14)
To clear a query ( A 2.15)
To use text data in a criterion (A 2.16)
To use a wildcard (A 2.18)
To use criteria for a field not included in the results (A 2.19)
To use a number in a criterion (A 2.20)
To use a comparison operator in a criterion (A 2.21)
To use a compound criterion involving AND (A 2.23)]
To use a compound criterion involving OR (A 2.24)
To sort data in a query (A 2.25)
To omit duplicates (A 2.26)
To sort on multiple keys (A 2.28)
To join tables (A 2.30)
To restrict the records in a join (A 2.32)
To use a calculated field in a Query (A 2.34)
To calculate Statistics (A 2.36)
To use criteria in calculating statistics (A 2.39)
To use grouping (A 2.40)
To save a query (A 2.41)
To close a database (A 2.42)