Title: Year 8 Databases

We will look at a large database in Excel and then import it into Access to see the different types of searching and sorting that can be done there.

This unit will not cover relational aspects of the Access database but will look at queries and form design.

Category: ICT/Computing courses — A number of sample ICT courses with varying degrees of cross-curricular scope. Most have some kind of planning and review section. Use more for ideas and adaptation than expect a neatly packaged and completed course.

The Java Programming workshop is, however, a complete course.

Role: Guest — Guests have minimal privileges and usually can not enter text anywhere.

Section 1
  News forum
Section 2
  Lesson plan 1
  My Tunes
  My Tunes database worksheet
  Upload the completed worksheet (assignment)
  Teacher hints and tips sheet
Section 3
  Lesson plan 2
  Importing an Excel Spreadsheet to MS Access (Smart Notebook file)
  Importing an Excel spreadsheet into MS Access (pdf)
  Homework Diary example (teacher resource)
Section 4
  Lesson Plan 3
  Searching/querying and Access database (worksheet)
  Upload the completed worksheet (assignment)
  Teacher hints and tips for worksheet
  The myTunes Access database
  How to make queries in Access (Smart Notebook file)
  How to make queries in Access (pdf file)
  OK, now we want to hear from you. Please lis...
  Excel vs Access
  Forum assignment
  More on Access queriesJust to see some of the wond...
  Lesson plan 4
  More queries worksheet
  Upload the completed worksheet here please (assignment 8MB - 1)
  8 MB assignment 2
  More on queries (Smart Notebook file)
  More on queries (pdf )
Section 5
  Lesson plan 5
  Making a Homework Diary database (Smart Notebook file)
  Making a Homework Diary database (pdf)
Section 6
  Lesson plan 6
  How to make the homework due form (Smart Notebook)
  How to make the homework due form (PDF)
  Additional thoughts
  Upload your completed Access Database here (8MB - 3)
  Report Grades (please read)