Category: Year 8 Databases
Year 8 – European Database
Countries of Europe project
You will create a database of the countries in Europe. For each country you need to find the following infromation.
-
Country name
-
Capital
-
Population
-
Area (sq km)
-
Currency
-
Time zone
Record the information in the MS Excel File below:
European Countries
Year 8 – European Database
Lesson Aim
- Gather information for creating a database of European Countries
Main Task
Your task is to gather information about the countries in Europe and store it in MS Excel. You need to gather the following information:
- Name (Country)
- Area
- Population
- Capital
- Language spoken
- Currency
Extension
If you complete the gathering of all the information for all the European countries. Create a presentation about one of the countries in MS Powerpoint.
Year 8 – World Record Database
Lesson Aim:
- Create Reports using Microsoft Access
Main Task
Your task today is to ensure that you have completed the queries for the task week and then create reports for each of your queries.
Year 8 – World Record Database
Lesson Aim:
- Create queries in MS Access
Main Task
Your task is to download the database and worksheet below and create queries to answer the questions on the worksheet.
Extension
Create reports to improve the presentation of your query
Year 8 – World Record Database
Lesson Aim
- Create a form in a Microsoft Access Database
- Use a Form to add Data to a Microsoft Database
Your Task
Download the file below to your folder and save it in Year 8 and then ICT Folder.
You will then need to create a form (Return to the middle to view demonstration)
Now create a form and add records to your database