ICT Revision

ICT Revision

1. Components of a Data Dictionary

   • Primary Key
     • Uniquely identifies all records within a table
   • Relationship between tables
     • e.g. 1:M
   • Foreign Key
     • Shows relationship between tables

2. Simple and Complex Query

   • Simple Query
     • 1 parameter e.g. Number of Years> 10
   • Complex Query
     • More than 1 parameter e.g. Number of Years> 10 and town= Coventry

3. Desktop Publishing Software

   • Easy for novice users
   • Templates
   • Feature clipart library images

4. Stages of a Mail Merge

   • 1: Create data source
     • 2: Merge to new document
       • 3: Link letter and data source
         • 4: Insert merge fields
           • 5: Preview mail merge
             • 6: Merge to new document

5. Frame

   • Area of a page that contains texts or images

6. Changes that could be made to a letter in order to fit on one side of A4

   • Resize writing
   • Smaller font type
   • Reduce line spacing

7. Advantages of using macros within a database

   • Run specific tasks which saves times for the user
     • Reduces errors, all steps are completed corrected by the computer

8. Check digit check validation

   • Digit at end of number- results checked against check digit
     • Uses mathematical calculations to match digit against check digit

9. Referential Integrity

   • Put data into atomic form
   • Uses less storage within a database

10. Animation

    • Moving text or image, such as rotate
    • Link that appears underlined and in blue by default. Takes users to a separate page once clicked