Database

Database

1. Benifits

   • Fast access: faster than a paper based system
   • Easy to edit
   • Validation: setiing checks it is sensible
   • reports can be printed
   • sharing
   • security: passwords can be set

2. Database use

   • A database is a collection of data or information which is held together in an organised or logical way
   • Examples
     • Birthdays
     • Addresses
     • Phone numbers

3. Database terminology

   • A database is a collection of data or information which is heald together in and organised or logical way

4. Validation

   • Validation is an automatic computer check to ensure that the data entered is sensible and responsable. It does not check the accuracy of the data

5. Verification

   • Verification means to check the data that you have entered against the origional source data
     • Entering data twice
     • proof reading

6. Database queries and reports

   • Access Walkthrough
     • Creating fields
     • Choosing datatypes
     • Choosing field sizes
     • Creating drop down boxes
     • Using validation
     • Writing reports
     • Creating mail merged letters
     • Writing quiries