Activity 1

The local sports club has a database showing the members' names, numbers, and whether or not they have paid their fees.

You have to edit this data table…

…so that it looks like this.

Follow these steps carefully:

1. Open your folder and find the database Membership.
2. Open Membership.
3. Open the Membership fees data table.

Entering new field data

1. Pete Ross's number is Gym0973. Enter Pete's number now.
2. Alan Sharp's number is YC1432. Enter Alan's number.

Changing field data

1. Jo's name is actually 'Jo Crookson'. Change to 'Crookson' now.
2. Anne's name should be spelt 'Campbell'. Change her name now.

Printing the data table

1. Move the pointer to File on the menu bar.
2. Click the mouse button.
3. Move the highlight to Print. The print window opens.
4. Find and click OK.

Put the printout in your folder.

Closing the database

1. Click Close on the Membership fees:Table window.
2. Click Close on the Microsoft Access window.