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 Access must...
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...
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...
Access uses the phrase 'filter by selection' to mean 'search for certain data'.
Let's search for...
The table below is not sorted. Watch the animation to see how to sort it by country into descending and ascending...
You are going to use the data file Mobile Phones to find answers to the following questions. Look back in these...
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.
...
It is important to save your work often, particularly if you have made a number of changes.
Click on File in...
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 Access, load the file Mobile Phones and...
