Creating and using a database

Creating and using a database

1. Different organisations that use databases

   • Schools may use one to store personal information
   • Different business
   • Information was previously stored on paper in files

2. Advantages Of databases

   • Can store vast amounts of data
   • The data contained can easily be altered, added to or deleted
   • They help keep data safe
   • Passwords can be added to ensure there are no unauthorised entries
   • You can easily search and sort the data and records

3. Parts of a database

   • Table
   • Data
     • The information that has been collected either directly or indirectly
   • vertical Fields
     • A category of information That contains a piece of data from every record
   • horizontal records
     • Holds all the data about one person or thing

4. Sorting a database

   • Ascending
     • Sorted highest to lowest or A-Z
   • Descending
     • Sorted lowest to highest or Z-A

5. Features of a database

   • Forms
     • Can be used to make inputting data easier and more visually appealing
   • Reports
     • Can display database information in a format ready for printing or presenting