Unit 7- Introduction to Databases  
Tutor: Paul Bolger
Unit 6 - Scheme of Work
Syllabus - Click Here to see what you will be studying this year
Progress Report - AVCE Year 2 - Unit 6 - Latest Results
Unit 7 - Documents and Notes
Quick Catch Up - Have you been Rumbled ? Not actually done any of that studying you were supposed to have done yet ? CLICK HERE if you need to catch up with MICROSOFT ACCESS very quickly ...
Access 2000 Quick Ref 1 - Essential Quick reference Sheet Part 1-
 
Access 2000 Quick Ref 2 - Essential Quick reference Sheet Part 2
Studywork / Homework
 Week by Week Lesson Topics Classwork /Notes
  Week 0 - College Induction programme -  
     
  Week 1 - Induction programme - Unit Induction - Explain overview of the syllabus - Explain Assessment Method and Rules - Explain Class rules - Introduce unit website - Register each student for an email address and record it - Ensure each student registers for the unit on line  
week 01 - Activity - getting to know the website   Week 01 - Lesson Plan
  Week 2 - (3 hours ) Explain the concepts of simple databases, relational databases, primary keys, multiplying tables, types of relationships, database design, creating databases, creating a table, setting the primary key, saving the table design  
week 02 - Databases - A Powerpoint Introduction A databases overview in powerpoint Week 02 - Lesson Plan
week 02 - Databases - A Powerpoint Introduction 2 An even better databases overview - needs unzipping with winzip 01 simple databases
week 02 - Activity - Activity Sheet 1   02 relational databases
week 02 - Activty - Activity sheet 2   03 primary keys
    04 multiplying tables
    05 types of relationships
    06 database design
    07 creating databases
    08 creating a table
    09 setting the primary key
    10 saving the table design
  Week 3 - Getting Started - Databases. Features and facilities of a relational database - Relational database structure: tables, records, fields, key fields  
week 03 - Activty - Activity Pack 3a   Week 03 - Lesson Plan
week 03 - Activity - Activity Pack 3b To get the datafile needed for Activity Pack 3a/3b click HERE Week 03 - Notes - Database Concepts 1
week 03 - Activity - breaking data down into tables 1   Week 03 - Notes - Database Concepts 2
week 03 - Activity - breaking data down into tables 2
   Week 03 - Notes - Board Example
week 03 - Activity - classwork - create a video shop database   11 table views
    12 adding data to a table
    13 changing the field size
    14 editing and deleting data in a table
    15 -16 opening and closing a database
    17 editing relationships
    18 creating a query
    19 adding tables to a query
    20 adding fields to a query
  Week 4 - Relationships - Features and facilities of a relational database - Multiple tables: concept of related tables and common fields to link them  
week 04 - Activity complete an ERD   Week 04 - Lesson Plan
week 04 - Activity - Computerise data on an application form
   Week 04 - Notes - database methods and jargon
week 04 - classwork/homework -
Beginners Access Exercises		   Week 04 - Notes - database relationships
    Week 04 - Notes - drawing relationship diagrams
    Week 04 - Notes - primary and foreign keys
    21 - 22 viewing and editing a query
    23 editing a query
    24 sorting fields in a query
    25 creating a report
    26 form views
  Week 5 - Forms and Sub Forms  
week 05 - Activity - create a college grading database   Week 05 - Lesson Plan
week 05 - Activity - Activity Pack 4   Week 05 - Notes - creating relationships and forms in Access
week 05 - classwork/homework -
Intermediate Access Exercises		   Week 05 - Save time download the data files from week 5 by CLICKING HERE
week 05 - Further exercises 01   27 bound / unbound controls and labels
    28 adding simple controls
    29 changing controls
    30 creating a report
    31 saving / changing views and printing
    32 changing a report
  Week 6 - Consolidation Week  
week 06 - Activity - Activity Pack 4 continued Catch Up session - Complete all homework/study works not yet completed Week 06- Lesson Plan
week 06 - classwork/homework -
Advanced Access Exercises		    
week 06 - Further exercises 02    
HALF TERM 1
 1/11/2004 Week 7 - Consolidation Week  
week 07 - Activity -Activity Pack 5 Mark all Homework / Studyworks formally submited in folder Week 07- Lesson Plan
week 07 - Further exercises 03    
 8/11/2004 Week 8 - Assessment Release  
week 08 - Assessment Release   Week 08 -Lesson Plan
week 08 - Deadline 1 - w/b December 6th 2004 Click on this link to view a summary of the tasks to be completed by the FIRST of the three deadlines.   Week 08 - Assessment Tasks
15/11/2004 Week 9 - Queries - Assessment Consolidation  
week 09 - Deadline 1 - w/b December 6th 2004 Click on this link to view a summary of the tasks to be completed by the FIRST of the three deadlines. Week 09 - classwork - Queries Forms Menus Week 09 -Lesson Plan
  -
 
22/11/2004 Week 10 - Simple Systems Analysis and Design, Normalisation First Normal Form, Calculations and Form Properties  
week 10 - Deadline 1 - w/b December 6th 2004 Click on this link to view a summary of the tasks to be completed by the FIRST of the three deadlines. Week 10 - classwork - Doctors Surgery DFD Week 10 -Lesson Plan
week 10 - homework - First normal form
 Week 10 - Notes Normalisation - First Normal Form Part 1
 Week 10 - First Normal form Activity Pack 1
week 10 - homework - First Normal form 2   Week 10 - How work out Age from the DOB
29/11/2004 Week 11 - Expected Assessment Submission  
week 11 - Deadline 1 - w/b December 6th 2004 Click on this link to view a summary of the tasks to be completed by the FIRST of the three deadlines. Go through Grade E Marking Grid and Discuss exactly what needs to be handed in by next weeks deadline 1 Week 11 -Lesson Plan
  Illustrate expected Menus, forms, Queries, Tables, relationships, Annotation methods - Use Overhead Projector to illustrate how to do it AND HOW NOT TO DO IT W eek 11 - First Normal Activity Pack 2
06/12/2004 Week 12 - Assessment subsmission - Deadline 1  
week 12 - Deadline 2- w/b January 24th 2005 Click on this link to view a summary of the tasks to be completed by the SECOND of the three deadlines. Check and Mark Assessment Submissions Week 12 -Lesson Plan
13/12/2004 Week 13 - Normalisation Second and Third Normal Form and The Data Dictionary  
week 13 - homework - Data Dictionary Week 13 - Notes Normalisation - Second Normal Form Part 1 Week 13 -Lesson Plan
week 13 - Deadline 2- w/b January 24th 2005 Click on this link to view a summary of the tasks to be completed by the SECOND of the three deadlines. Week 13 - Notes Normalisation - Third Normal Form Part 1 Week 13 - classwork - Data Dictionary
  Week 13 - Notes - Data Dictionary week 13 - more Normalisation notes
    week 13 - Normalisation Activity Pack
 
 
20/12/2004 Week 14 - Consolidation Week  
week 14 - Deadline 2- w/b January 24th 2005 Click on this link to view a summary of the tasks to be completed by the SECOND of the three deadlines.   Week 14 -Lesson Plan
XMAS BREAK
03/1/2005 Week 15 - Consolidation Week  
week 15 - Deadline 2- w/b January 24th 2005 Click on this link to view a summary of the tasks to be completed by the SECOND of the three deadlines.   Week 15 -Lesson Plan
     
10/1/2005 Week 16 - Visual Basic and Access - Incorporating Utilities  
week 16 - Deadline 2- w/b January 24th 2005 Click on this link to view a summary of the tasks to be completed by the SECOND of the three deadlines. Week 16 - How to make a Pop Up Calendar
Week 16 - Pop Up Calendar Example
Week 16 - How to Build a Date Combo Box 1
Week 16 - How to Build a Date Combo Box 2
Week 16 - Combo Box Date Example		 Week 16 - Lesson Plan
   
Week 16 - further forms 01
Week 16 - further forms 02
17/1/2005 Week 17 - Logical Data Modelling  
week 17 - Deadline 2- w/b January 24th 2005 Click on this link to view a summary of the tasks to be completed by the SECOND of the three deadlines. Week 17 - notes - Logical Data Modelling 1
Week 17 - notes - Logical Data Modelling 2
Week 17 - notes - Logical Data Modelling 3
Week 17 - notes - Logical Data Modelling 4 		Week 17 - Lesson Plan
  Go through Grade D/C Marking Grid and Discuss exactly what needs to be handed in by next weeks deadline 2  
24/1/2005 Week 18 - Assessment subsmission - Deadline 2  
week 18 - Deadline 3- w/b February 28th 2005 Click on this link to view a summary of the tasks to be completed by the THIRD AND FINAL of the three deadlines. Check and Mark Assessment Submissions Week 18 -Lesson Plan
    Week 14 - User Spec guidelines
Week 14 - Documentation Suggestions
31/1/2005 Week 19 - User Spec and Documentation  
week 19 - Deadline 3- w/b February 28th 2005 Click on this link to view a summary of the tasks to be completed by the THIRD AND FINAL of the three deadlines.   Week 19 -Lesson Plan
     
     
7/2/2005 Week 20 -  
week 20 - Deadline 3- w/b February 28th 2005 Click on this link to view a summary of the tasks to be completed by the THIRD AND FINAL of the three deadlines.   Week 20 -Lesson Plan
HALF TERM 2
21/2/2005 Week 21 -  
week 21 - Deadline 3- w/b February 28th 2005 Click on this link to view a summary of the tasks to be completed by the THIRD AND FINAL of the three deadlines.    
28/2/2005 Week 22 - Assessment Deadline 3  
Word - Lesson Plan week 22 Adobe - Week 22 - Notes Normalisation - First Normal Form Part 1 Adobe - homework - First normal form
Powerpoint - The Need for Normalisation   Adobe - homework - First Normal form 2
Powerpoint - Normalisation - 1NF Lesson   Adobe - First Normal form Activity Pack 1
07/03/2005 Week 23 -  
Word - Lesson Plan week 23    
Powerpoint - Normalisation - 2NF Lesson A look at the steps involved in testing for 2nd Normal Form
Powerpoint - Normalisation - 3NF Lesson A look at the steps involved in testing for 3rd Normal Form  
     
14/03/2005 Week 24 -  
     
EASTER
04/04/2005 Week 26 -  
     
11/04/2005 Week 27 -  
     
18/04/2005 Week 28 -  
     
25/04/2005 Week 29 -  
     
02/05/2005 Week 30 -  
     
09/05/2005 Week 31 -  
     
16/05/2005 Week 32 -  
     
23/05/2005 Week 33 -  
     
HALF TERM 3
06/06/2005 Week 34 -  
     
13/06/2005 Week 35 -  
     
2-/06/2005 Week 36 -  
     
27/06/2005 Week 37 -