Lesson 2 - Building the database

Keywords - database, fieldname, data type, record, primary key, valid

Starter

Recap of the previous lesson with a Q&A on the different categories of food data which will form the database.  Students can use their food labels from homework to support this activity.

Main Activity

Demonstrate the use of Microsoft Access to create a database.  Students to create a table with appropriate fieldnames, data types and descriptions. [See example on food data categories.]

Use the student's own completed data capture form from last lesson to determine fieldnames for the creation of their database. [See example on nutritional data.]

Interactive spreadsheet activity on data types – students should complete this activity before finalising their database design.
 
Students use food label data to enter initial records into their database in order to test their design and data validation.

Plenary

Recap Data Types Quiz and ask for examples of where data type settings have been used to good effect. 

Homework

Students to collect food miles for the foods which they have input so far.