DATABASES – LESSON 4 Key Stage 3 ICT STARTER – TASK 4A Try and complete the word search starter. OBJECTIVES Know the purpose of a form Know how to create a form Know how to customise a form OUTCOMES All: Will be able to describe the purpose of a form Most: Will have create a form using the wizard Some: Will have customised a form TODAY’S TASK Using your favourites database from last lesson, create a form based on your table. Add an additional 2-3 records. Change two records using your form. Customise and improve your form. FORMS – WHAT ARE THEY Think back to the Video Clubdatabase we discussed at the start – did that contain EVERY piece of information about you? Think of school register – does that show ALL the information we have about you? A form is a user-friendly view of some of the fields from a database FORMS Watch Demonstration of how to create a form This will allow editing / adding of records in the database CREATE THE SUPERVISOR FORM – TASK 4B Create a form –called Supervisor Add all fields except Student Number. Add a new record – print screen it into your booklet as you add it. FORMS Normal uses of the database do not need to see the secret word field. Why might we want to hide this field from view. We are going to create another form that does not display it FORM CUSTOMISATION. – TASK 4C Try for yourself, view the help videos from your booklets, if you need to. Create a form that has A Title of “My Favourite Students” in Purple, Copper Black font, size 22 The form background is all light blue The field headings are all Purple, Copper Black font, size 12 You have added a suitable image to the header Save your form as “Operator” Print screen your design into your booklets. Add 2 new records using your form and print screen one of them into your booklet. PLENARY – ASSESSMENT OF LEARNING Describe a database form? 3 things you have learnt about forms? 2 things you found difficult 1 thing you would like to know more about. Answer the above questions with the person next to you now into your booklets. We will review in a minute.