Database Hints

Create a query
  • Open a database
  • Click on Queries option
  • Use query wizard
  • Drop down menu, select table data (validated)
  • Select the fields you want in the query
  • In last step, give the query a clear name

Query Criteria
  • Design mode
  • In criteria row put a criteria i.e. >2 (more than 2) or sport (only people who answered sport)
  • Click on ! button to run the criteria
  • See number of results at bottom of screen

Sort a query
  • Design mode
  • Click on field, click on ascending
  • Click on ! button to run the sort