DB Lesson 4 - WordPress.com
Download
Report
Transcript DB Lesson 4 - WordPress.com
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.