In this unit you will be introduced to databases. You will learn what databases are used for and how databases are created. You will also learn how to search database for data and create user entry forms.
Download office 2010 (Windows only). Make sure that you turn the Interet off before installing.
Instruction
Turn Internet off.
Take Office 2010 folder from compressed (zipped folder) that after its been downloaded.
Open the folder and scrol down to Setup and click
This activity will introduce you to databases. You will learn the following:
All: be able to describe what a database and identify different data types
Most: be able to choose most appropriate data types
Some: recall benefits of storing data in databases
You will need to download the worksheet. Use the presentation abobe to help you answer the questions.
Make sure that look carefully at the marks before you answer.
Remember you use this worksheet to help with revision for the need of unit assessment!
This activity will introduce you to creating databases. You will learn the following:
All: be able to create a database table
Most: be able to create a table and assign suitable field types
Few: be able to create a database and add records
In this task you will be creating database tables using MS Access.
In this task you will be creating database tables using MS Access.
In this task you will be creating database tables using MS Access.
This activity will introduce you to database forms. You will learn the following:
All: know that a form is a user friendly way of adding data
Most: identify at least two control that can be added to a form
Some: be able to add at least four controls on the form
This task will introduce you to database forms. You will need to carefully follow the tutorial.
Remember that you will be adding buttons adding controls such as buttons to forms.
This activity will introduce you to queries. You will learn the following:
All: Know that a query means search in a database
Most: be able to create simple searches
Some: be able to create more advanced searches using multiple criteria
Download the kites database. (click here)
Using the database downloaded from 4.1 work through the query tutorial.
Now that you have an understanding of how to make queries - work your way through the query task.
This activity will introduce you to queries. You will learn the following:
Download the activity and follow the tutorial
These activities will help you with your upcoming Midterm Tests.
Review Part 1
These activities will help you with your upcoming Midterm Tests.
Review Part 2
These activities will help you with your upcoming Midterm Tests.
Super Heroes Database (click here)