Queries

gabriellafederici
Mind Map by gabriellafederici, updated more than 1 year ago
gabriellafederici
Created by gabriellafederici almost 7 years ago
32
2

Description

A-Levels ICT Mind Map on Queries, created by gabriellafederici on 05/14/2013.
Tags

Resource summary

Queries
1 Simple Query
1.1 A simple query is a query that searches using just one parameter
1.2 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
2.1 A parameter query that searches using one or more parameter value
2.2 This query can be a 'AND', 'OR', 'NOT' query
3 Static Query
3.1 They are hardcoded so every time the query is run, the same parameters will be searched for
3.2 These queries cannot be changed
4 Dynamic Queries
4.1 These can be created to ask the user for the value to search for
4.2 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

MICROSOFT WORD 2013 SKILLS FOR WORK
John O'Driscoll
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
Networks
Will8324
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
General ICT Quiz
Jade Fantom
Data Types
Jacob Sedore