BTEC FIRST - Unit 7 Databases
Visited times
Remember the Policy adopted by your tutors is quite simple .... If a document relating to your course of study has been published on THIS WEBSITE, then we ASSUME YOU HAVE READ IT. This means that YOU CANNOT claim to NOT know about any topic that is covered on this website which relates to your course of study.. YOU have already SIGNED an agreement under the college LEARNER CODE OF CONDUCT that clearly states YOU are solely responsible for YOUR OWN LEARNING (with the support of your tutors). So make sure that you download , print and work through ALL the support notes and documents from this website that relate to you and your course. If you do this then your grades will improve dramatically .......kind regards .... Paul Bolger ...... 
Unit 7- Background
Library
 
Why not visit the ACCESS LIBRARY if you get stuck
Unit 7- Notes and Tutorials
Worksheets:
ALL WORK NOT COMPLETED BY THE END OF EACH CLASS MUST BE COMPLETED DURING TIMETABLED STUDY PERIODS PRIOR TO START OF YOUR NEXT CLASS
 
w/b 5th Sep Week 1 - Induction activities
   
w/b 12th Sep Week 2 - Getting started
   
  Activity - create a college grading database
Interactive Notes - Data Types  
  Notes - What is a Relational Database ?
  Notes - What are Key Fields ?
  Notes - Key fields and Relationships
   
w/b 19th Sep Week 3 - Getting further
   
  Activity - create a video rental database
(create and relate tables with look up fields add data and build a cross table query to view all three tables)
Notes - Relationships between tables
  Notes - Drawing Relationship Diagrams
  Activity - Breaking Data down into related Tables 1
  Study work - Breaking Data down into related Tables 2
   
w/b 26th Sep Week 4 - Queries
   
Activity - create a college grading database ( add forms, reports, buttons and queries )
Week 4 Studywork - create a video rental database
( create menus with buttons , add validation,input forms and output reports)
   
w/b 3rd Oct Week 5 - Consolidation
   
  Activity - create a doctors surgery database
  Activity - create a database for an outward bound school
   
w/b 10th Oct Week 6
   
  Classwork/Studywork - Beginners Access Exercises
  Additional Notes - Database Jargon and Concepts 1
  Additional Notes - Database Jargon and Concepts 2
   
w/b 17th Oct Week 7
   
  Classwork/Studywork - Intermediate Access Exercises
  Worksheet - Database Jargon 1
  Worksheet - Database Jargon 2
  Additional Notes - Board Example 'One to Many' Relationships
  Additional Notes - Primary and Foreign Keys
  New Resource - ACCESS LIBRARY more places to go if you get stuck
   
Half Term  
 w/b 31st Oct  Week 8 - Queries, Forms and Reports
   
Activity - create a Doctors Appointment database
( create tables and basic queries)
   
 w/b 7th Nov  Week 9 - Menus, Buttons, Validation, Forms and Reports
   
Activity - create a Doctors Appointment database
( create menus with buttons , add validation,input forms and output reports)
   
 w/b 14th Nov  Week 10 - Consolidation
   
  Activity - College Grades system 2
   
w/b 21st Nov   Week 11 - The IVA Assessment
   
  IVA - 'This Years Unit 7 - Assessment'
  IVA - 'Revision for Assesment Years Unit 7 - Assessment'
   
w/b 28th Nov Week 12 - Relationships & Forms
   

Activity - Creating Relationships and Forms in Access
  Download - Save time & download the database files needed

Activity - Computerise the Data on an Application Form
   
w/b 5th Dec Week 13 - Starting the IVA Assessment
   
  Tasks - IVA Assessment Page
 
w/b 12th Dec Week 14 - Starting the IVA Assessment Write Up
   
w/b 19th Dec Week 15 - Reading week prior to Christmas
   
  Tasks - None Planned - Consolidate work covered so farif class runs this week
   
Christmas  
   
w/b 2nd Jan Week 16 - Consolidation week after Christmas
   
  Tasks - None Planned - Consolidate work covered so farif class runs this week
   
w/b 9th Jan Week 17 - IVA Getting Further - Task 2 Design
   
 ASSESSMENT HELP  IVA exercise 2 - Database Design
  Useful powerpoint show - database 06 Entity Relationship Diagrams
   
w/b 16th Jan Week 18 - IVA Getting Further - Task 2 Design
   
 ASSESSMENT HELP  IVA exercise 2 - Database Design
   
w/b 23rd Jan Week 19 - IVA Getting Further - Task 2 Design
   
 ASSESSMENT HELP  IVA exercise 2 - Database Design
   
w/b 30th Jan Week 20 - IVA Getting Further - Task 1 DBMS Presentation
   
 ASSESSMENT HELP  IVA exercise 1 - DBMS Presentation
  Useful Powerpoint show - database 00 Introduction to databases
  Useful Powerpoint show - database 01 What is a Database
  Useful Powerpoint show - 'The Database Application'
  Useful Powerpoint show - 'Introduction to Databases'
  Good or Bad Student example - example 1
  Good or Bad Student example - example 2
   

w/b 6th Feb

 Week 21- IVA Getting Further - Task 1 DBMS Presentation
   
 ASSESSMENT HELP  IVA exercise 1 - DBMS Presentation
   

w/b 13th Feb

 Week 22- IVA Getting Further - Task 3 Queries & Reports
   
P3
 Slide Show 1 - How to Create a SORT Query
P4 
 Slide Show 2 - How to Create a Multiple Table Query
D3 
 Slide Show 3 - How to Create a Grouped Report based on a Query
   
  Additional Word Notes - How to Create a Query
  Additional Slide Show - Querying a Database - Part 1
  Additional Slide Show - Querying a Database - Part 2
  Additional Slide Show - Querying a Database - Part 3
   
 ASSESSMENT HELP  IVA exercise 3 - Queries and Reports ( you will need to PRINT and complete this exercise)
   
Half Term  
   
w/b 27th Feb Week 23- IVA Getting Further - Task 3 Queries & Reports
   
Advanced Slide Show 1 - Querying a Database 1
 
 Advanced Slide Show 2 - Querying a Database 2
 
 Advanced Slide Show 3 - Querying a Database 3
   
  Notes - How to Create a Query
 ASSESSMENT HELP  IVA exercise 3 - Queries and Reports ( you will need to complete this exercise)
   
  Notes - How to Create a Query
   
   
   
w/b 6th Mar Week 24 - IVA Getting Further - Task 4 User Guide
   
 ASSESSMENT HELP  IVA exercise 4 - User Manual
  Hints and Tips - Barbara's Tips How to Produce a User Manual
  Hints and Tips 7 - Barbara's Tips User Manual
   
w/b 13th Mar Week 25 - IVA Getting Further - Task 4 User Guide
   
 ASSESSMENT HELP  IVA exercise 4 - User Manual
  Hints and Tips - Barbara's Tips How to Produce a User Manual
  Hints and Tips 7 - Barbara's Tips User Manual
 
w/b 20th Mar Week 26 - IVA Getting Further - Task 5 Evaluation
   
 ASSESSMENT HELP  IVA exercise 5 - Evaluation
  Hints and Tips 4 - Barbara's Tips Evaluation
   
w/b 27th Mar Week 27 - IVA Getting Further - Task 5 Evaluation
   
 ASSESSMENT HELP  IVA exercise 5 - Evaluation
  Hints and Tips 4 - Barbara's Tips Evaluation