Wednesday, 4 February 2015

Year 7 - Build your own Database using Microsoft Access

Your task for the next 4 lessons is to build your own database using Access. Ideas for your database could include:

  • Your favourite films, music, games
  • FIFA Ultimate Team Database
  • Countries of the World
  • Animals


Watch my demonstration carefully. The first 2 lessons will be about building a database. Next week we will be using the data to create 'forms'.

HELPFUL TIP No. 1: Think carefully about the fields you want to create for example, for 'Countries of the world' the fields I might create would be:

  • Name
  • Population
  • Continent
  • Flag
  • Neighbours
  • Capital City

HELPFUL TIP No. 2: When you create a new field, think carefully about the data that will be displayed. You must choose from text, attachments (if you want a picture), currency, date etc.

No comments:

Post a Comment