Queries

Queries

1. Simple Query

   • A simple query is a query that searches using just one parameter
   • May use All of the fields in a table or it may just use the field that is necessary from which the information is required

2. Complex Query

   • A parameter query that searches using one or more parameter value
   • This query can be a 'AND', 'OR', 'NOT' query

3. Static Query

   • They are hardcoded so every time the query is run, the same parameters will be searched for
   • These queries cannot be changed

4. Dynamic Queries

   • These can be created to ask the user for the value to search for
   • The set of [ ] creates the query. The value entered into the box is Used as the search criteria