Queries

Beschreibung

A-Levels ICT Mindmap am Queries, erstellt von gabriellafederici am 14/05/2013.
gabriellafederici
Mindmap von gabriellafederici, aktualisiert more than 1 year ago
gabriellafederici
Erstellt von gabriellafederici vor mehr als 11 Jahre
37
2

Zusammenfassung der Ressource

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
                  Zusammenfassung anzeigen Zusammenfassung ausblenden

                  ähnlicher Inhalt

                  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