Lesson 4 - Plant Database

Download Report

Transcript Lesson 4 - Plant Database

For all your gardening needs
We are learning to
• Use software to create a Database
• Develop our skills handling the database
• Choose suitable field headings for a
customer database
What I’m looking for
Students who can:
•
Use the software correctly to make a database
•
Show a developing knowledge of using database
packages efficiently
•
Understand how we can use a database of
customers to improve sales and marketing
What do I have to do?
Julia’s House Plant Sale
Open MSExcel
• You must design the database for the
customers you sold plants to last year to
raise money for charity.
• You must include all 7 plants.
• You must include at least 20 of your
customers.
Plenary
• What is a database?
• Can you name 3 examples of a database you
have at home?
• Name 8 suitable headings which you might need
in a database at:
• A Police Station
• A Hospital