Print out this checklist. Tick the boxes for the skills you already have and work through the others. Tick the box for...
What is this section about?
This section will help you learn how to use a database. A database is one of three...
Here are some examples of databases in common use:
Address books
A list of activities at a swimming...
Databases can also be stored electronically in a computer system. The data in an electronic database like AppleWorks...
You may be more used to seeing data in the form of a record. Play the animation to see the different ways in which...
Play the animation to see how to open an existing database file.
You are going to use a file called Health...
Once the database is opened you will see 17 records in the table. Each one holds data about a different...
Play the animation to see an example of how you might sort data.
...
You may have noticed that as you move the mouse pointer around the screen it changes shape at different points.
Play...
AppleWorks allows you to create searches to find information.
Let's search for those countries where there is a...
The table below is not sorted. Watch the animation to see how to sort it by country into decending and ascending...
There is another data file in your folder, which is called Mobile Phones. You are going to use that file to...
Tables need to be edited as data changes.
You need to know some important keys on a keyboard before editing a...
There is always a blank row at the bottom of any table. This is where you can enter new records. Here is new...
Advice to travellers to Tajikistan is being reviewed. Let's delete Tajikistan's record for now.
Watch the...
Sometimes you need to add or change data inside the fields. Play the animation to see how to add...
The entry for diphtheria in Greece is a mistake and should be deleted.
In your own file:
...
Now you are going to edit some of the data already entered.
Burma is now called Myanmar.
To make this...
You should always check to see if you can improve how your table looks. This is called formatting the table.
Notice...
It is important to save your work often, particularly if you have made a number of changes.
Click on File in the...
To print your table:
Select File from the top menu bar.
Select Print from the menu which opens.
Press OK...
For this exercise you will need the data file Mobile Phones.
Open up AppleWorks, load the file Mobile Phones and...