1 / 10

Super Hero Databases

Super Hero Databases. Lesson 2. Lesson 2 Aims…. To know different data types . To understand why it is important to put the correct data in the correct data type. To be able to a flat file database table using correct datatypes . Starter.

cyma
Download Presentation

Super Hero Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Super Hero Databases Lesson 2

  2. Lesson 2 Aims… • To knowdifferent data types. • To understand why it is important to put the correct data in the correct data type. • To be able to a flat file database table using correct datatypes.

  3. Starter • Explain to your neighbour what top trumps is..... • Someone in the room will have to report back

  4. Activity 1 – MS Access • Using MS Access, create a new database - ‘Top Trump Superheros’.

  5. Activity 2 – Super Hero Categories • Decide as a class which categories (max 6) you will use for your ‘Superheros’ – e.g.: • Write 3 on your wipeboard

  6. Activity 2 – Super Hero Categories • Decide as a class which categories (max 6) you will use for your ‘Superheros’ – e.g.: • Strength • Team Spirit • Size • Power • Skill • Costume Vote on PollEverywhere You have 3 votes

  7. Activity 3 – Creating a Table • Create a table – ‘tbl_Superhero’ in ‘design view’. • Add the different categories & data types from Activity 2.

  8. Activity 4 – Adding Superheros • Add the details of your Superhero's to your table. • Remember to keep the scores between 0 and 10 • Save your table.

  9. Activity 4 – Making More Heros • Repeat the same process to create more Super Heros: • Level 1-3 = 6+ Heros • Level 3–4 = 8+ Heros • Level 5+ = 10+ Heros

  10. Plenary – Spelling Test

More Related