Topic 8

Topic 8

1. Data types

   • number (interger)
   • Number (real)
   • Text or string
   • Data/time
   • Currency
   • Boolean
   • Lists
   • Picture
   • Sound
   • Video

2. Files, records and fields

   • Field
   • Record
   • File
   • Key Field

3. Validation

   • Range check
   • Type check
   • Format/Picture check
   • Length check
   • Presence check
   • Lookup list

4. Reports

5. Forms

6. Calculated fields

7. Uses of a database

8. Updating records

9. Searching for data

   • Simple query search
   • Complex query search
   • Wildcard charecters

10. Sorting data

11. Security issues with databases

12. Software methods for keeping data secure

    • passwords
    • Access rights
    • Back-ups

13. Advantages of using a database

    • fast access
    • Easy to edit
    • Validation
    • Reports
    • sharing
    • Security