objectives(s) that this lesson is contributing to
10.3.2.4 create a form
for data entry (SQL)
●creates a form based on a single table using
the Form Wizard tool;
●creates and saves a new record in the database
using the form;
All learners will be able to know:
create a form for data
form concepts in databases
Vocabulary and terminology specific to the subject:
reports, Form Wizard, Report Wizard, Constructor.
Useful expressions for conversations and writing:
create a form you need ...
form is intended for ...
Group work ,
co-operation, time management, academic integrity
Cross curricular links
Course of the lesson
Planned stages of the lesson
Planned activities at the lesson
Definition of the topic.
Setting lesson objectives and success criteria
Find information on creating forms and reports of MS access DB
What types of information systems exist?
Teacher gives 10 minutes for discussion
1.create a report and a
form of an already created database
2.create an algorithm
for creating reports and forms
Teacher gives 10 minutes for this task
Repetition of the material covered.
Task number 1
1.1 How many
fields does the database contain?
1.2 How many
records are in this database?
1.3 Which field
can be the key field in the database?
You need to get
the following icons T, R, J, ¶. You should focus your attention on if you
do not have any symbol:
T- repeat the definition of the term field, note what
to apply to the fields;
R- repeat the definition of the term
record, note what to refer to the records;
J - carefully read once again what the key
field is, learn how to identify them correctly;
¶- you need to know how key fields differ
from ordinary fields.
Learners are offered a small questionnaire, the
content of which can be changed, supplemented depending on which elements of
the lesson special attention is paid. You can ask students to argue their
1. I worked
on the lesson
2. My work
on the lesson
lesson seemed to me
4. For the
5. My mood
material of the lesson was
Differentiation – how do you plan to give
more support? How do you plan to challenge the more able learners?
Assessment – how are you planning to
check students’ learning?
Health and safety regulations
Work in pairs / groups - support for
Help the teacher, if required.
More capable learners can demonstrate
aspects of their decisions that seem interesting / more complex to the other
Answers questions and a
session of answers.
Use questions when completing
Use survey questions to
understand the results / success of learners at each stage of the lesson.
Remind of some safety rules when working
with computer equipment, for example, that you must be careful when
installing the screen, keyboard and mouse; beware of wires, as they pose a
threat to movement.
Lesson plan Long-term plan unit: 10
Task 1 Research Find information on creating forms and reports of
Assessment – how are you planning to check students’ learning ?