Information Handling (Databases)

Searching & Sorting
1. =
  1. Eg. Town = Newport
    1. Lives in Newport
2. <>
  1. Eg. Town <> Newport
    1. All customers apart from those living in Newport
3. >
  1. Eg. Items > 10
    1. More than 10 items
4. <
  1. Eg. Items < 10
    1. Less than 10 items
5. AND
  1. Eg. Town = Newport AND Items > 10
    1. Lives in Newport and has order with more than 10 items
6. OR
  1. Town = Newport OR Items > 10
    1. Either orders with more than 10 items or orders from Newport
7. LIKE
  1. LIKE Town = New
    1. Customers that live in a town beginning with 'New'
Validation
1. Lists
2. Range check
3. Format checks
Data Types
1. Text
2. Number
3. Currency
4. Date
5. Time
6. Boolean
7. Lists
8. Picture
9. Sound
10. Video
Security
1. Password protection
2. Access rights
3. Backup procedures
Benefits
1. Faster access to data
2. Variety of output formats
3. Data integrity

Resource summary

	Created by Katie Leese over 6 years ago