| Unit 7- Introduction to Databases | ||
| Tutor: Paul Bolger | ||
| Unit 7 - Scheme of Work | ||
| Syllabus - Click Here to see what you will be studying this year | ||
| Progress Report - Unit 7 - 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 1 - Induction programme | ||
| Week 2 ( 3 hours) - 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
02 - classwork/homework - getting
to know the website |
Week 02 - induction/ Course/Subject Overview Lesson Plan | |
| Week 3 ( 3 hours) - Features and facilities of a relational database - Components: Database Management System (DBMS) and the database itself. Examples of commercial packages | ||
| week 03 - classwork/homework - Activity Sheet 1 | Week 03 - Lesson Plan | |
| week 03 - classwork/homework - Activity sheet 2 | week 03 - notes - Concepts 1 | |
| week 03 - Databases - A Powerpoint Introduction 1 | <-- A databases overview ( only viewable in college for contract reasons ) | week 03 - notes - Concepts 2 |
| week 03 - Databases - A Powerpoint Introduction 2 | <-- An even better databases overview - | 01 simple databases |
| 02 relational databases | ||
| 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 4 ( 3 hours) - Features and facilities of a relational database - Relational database structure: tables, records, fields, key fields, relationships, Query Design a suitable database - Define tables: meaningful names and acceptable fields, using text and numeric fields appropriately | ||
| week 04 - classwork/homework - Activity Pack 3a | To get the datafile needed for Activity Pack 3a click HERE | Week 04 - Lesson Plan |
| week 04 - classwork/homework - Activity Pack 3b | week 04 - notes - getting started | |
| 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 5 ( 3 hours) - - Features and facilities of a relational database - Multiple tables: concept of related tables and common fields to link them - Design a suitable database - Forms for data entry: appropriate labels and sequencing for data entry | ||
| week
05 - classwork/homework - Beginners Access Exercises |
Week 05 - Lesson Plan | |
|
week 05a - notes - database relationships | |
| week 05b - notes - relationship diagrams | ||
| week 05c - notes - relationships Board Diagram | ||
| week 05d - notes - primary and foreign keys | ||
| Week 6 ( 3 hours) -Features and facilities of a relational database - Facilities: forms, reports, sorting - Design a suitable database - Sorting and searching. sorting on one or more fields and simple, meaningful queries on one or more tables | ||
| Consolidation Week - Catch up with and finish Homework/Studywork | Week 06 - Lesson Plan | |
| 21 - 22 viewing and editing a query | ||
| 23 editing a query | ||
| 24 sorting fields in a query | ||
| 25 creating a report | ||
| 26 form views | ||
| 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 7 ( 3 hours) -Features and facilities of a relational database - Facilities: queries, sorting - Design a suitable database - Reports. on tables or queries; selection of appropriate layouts, labelling and titling | ||
| week
07 - classwork/homework - Intermediate Access Exercises |
Consolidation Week - Catch up with and finish Homework/Studywork | Week 07 - Lesson Plan |
| 01
- formatting data |
||
| 02
- input mask |
||
| 03
- validation |
||
| 04
- other field properties |
||
| 05
-changing the table design |
||
| 06
- sorting data |
||
| 07
- finding data |
||
| 08
- filtering data |
||
| 09
- cascading relationships |
||
| 10
- creating calculated fields |
||
HALF
TERM 1 |
||
| Week 8 ( 3 hours) - Facilities: calculating | ||
| Week 08 - Lesson Plan | ||
| week
07 - classwork/homework - Intermediate Access Exercises |
Week 8 - How work out Age from the DOB | |
| Week 8 - Calculations in Queries | ||
| 11
- formatting fields |
||
| 12
- entering expressions |
||
| 13
- forms - changing control properites |
||
| 14
- forms - headers and footers |
||
| 15
- forms - lists and combo boxes |
||
| 16
- forms - editing tab order |
||
| 17
- forms - subforms |
||
| 18
- reports - sorting and grouping |
||
| 19
- reports - calculated fields and joining text |
||
| 20 - reports - mailing labels | ||
| Week
9 ( 3 hours)
- The IVA Assessment |
||
| week 09 IVA Assessment Cover Sheet | Week 09 - Lesson Plan | |
| week 09 IVA Assessment Tasks | ||
| week 09 IVA Assessment Marking Criteria | ||
| week 09 IVA Assessment Marking Grid | ||
| week
10 -
Case studies: explore the use of databases in industry citing specific examples
and facilities they provide for information provision |
||
| week 10 - What is a DBMS ? | Background information for the IVA assessment Task 1 | Week 10 - Lesson Plan |
| week 09 - | ||
| Week 11 - The IVA Assessment | ||
| Week 11 - Lesson Plan | ||
| week 11 - Further exercises 01 | Provide documentation for the database design - Documentation user manual: design a user manual, giving guidance on purpose of database and forms for input and samples of reports | Week 11 - User Manual tips |
| Week
12 - The IVA Assessment |
||
| week 12 - Further exercises 02 | Provide documentation for the database design - Development log: recording stages, table definitions, consideration of alternative designs | Week 12 - Lesson Plan |
| week 12- Further exercises 03 | ||
| Week 13 - The IVA Assessment | ||
| Evaluation:
is the database fit for its purpose?, What problems were encountered?, Was
it easy to use?, What improvements would be made to the overall design? |
Week 13 - Lesson Plan | |
| Week 14 - The IVA Assessment | ||
| Week 14 - Lesson Plan | ||
| Week 15 - The IVA Assessment | ||
| Week 14 - Lesson Plan | ||
XMAS
BREAK |
||
| Week 16 - The IVA Assessment | ||
| Week 14 - Lesson Plan | ||
| Week 17 - The IVA Assessment | ||
| Week 14 - Lesson Plan | ||
| Week 15 - Assessment | Week 15 - Lesson Plan | |
| Week 16 - Assessment | ||
| Week 17 - Assessment | ||
| Week 18 - Assessment | ||
| End Semester 1 | Week 19 - Assessment | |
|
HALF
TERM 2
|
||
EASTER |
||
HALF
TERM 3 |
||