DB Lesson 4 - WordPress.com

Report
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.

similar documents