National Qualifications Online - Core skills

Activity 2

Mrs Lacy uses a database to remind her of family events. Some of the data needs editing.

You have to edit this data table…
This is a picture of the original data table.
…so that it looks like this.
This is a picture of the updated data table.

Follow these steps carefully:

  1. Open your folder and find the database Occasions.
  2. Open Occasions.
  3. Open the Occasions dates data table.

Entering new field data

  1. On 26 March, enter 'Starts new job' for Anne in the Occasion field.
  2. Daisy's exams are on 12 June. Enter this date correctly now.

Changing field data

  1. Uncle Kenneth's visit will now start on 2 June. Change this date.
  2. Anne and Daisy are going to Wales, not Ireland. Make the change to Wales.

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.

Did you do the last activity…

with a lot of help? Arrow pointing to the right Then ask your tutor to copy the original files into your folder and do the activities once more.
with little or no help? Arrow pointing to the right Then speak to your tutor.

You may decide with your tutor that you are ready for the database assessment task.

The database assessment task is very like the activity that you have just finished.