Queries

Description

A-Levels ICT Mind Map on Queries, created by gabriellafederici on 14/05/2013.
gabriellafederici
Mind Map by gabriellafederici, updated more than 1 year ago
gabriellafederici
Created by gabriellafederici almost 11 years ago
36
2

Resource summary

Queries
  1. Simple Query
    1. A simple query is a query that searches using just one parameter
      1. 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
        1. A parameter query that searches using one or more parameter value
          1. This query can be a 'AND', 'OR', 'NOT' query
          2. Static Query
            1. They are hardcoded so every time the query is run, the same parameters will be searched for
              1. These queries cannot be changed
              2. Dynamic Queries
                1. These can be created to ask the user for the value to search for
                  1. The set of [ ] creates the query. The value entered into the box is Used as the search criteria
                  Show full summary Hide full summary

                  Similar

                  Types and Components of Computer Systems
                  Jess Peason
                  Input Devices
                  Jess Peason
                  Output Devices
                  Jess Peason
                  Networks
                  Will8324
                  General ICT Quiz
                  leahshaw
                  ICT Revison Flash Cards
                  Arun Johal
                  FLAT FILE VS RELATIONAL DATABASE
                  rosiejones
                  Online World - Learning Aim A
                  andysedge
                  Business Aims and ICT Strategies
                  scrt
                  User Interfaces
                  Skeletor
                  General ICT Quiz
                  Jade Fantom