PHS badge

PHS CyberSchool

Computer Studies SG

Modified 16 January 2004


Internet URLs - Access table

  1. Using the program Access create a database called SAWEB to store details about South African web sites.
  2. In the database SAWEB create a table called 'Your Name's favourite web sites', for example 'Bill Gates' favourite web sites'.
  3. In Design View create the database table with the description below. Access will probably assign ID as your primary key with the Data type as Autonumber - if not, do not worry.


    Field Name Data Type Field Properties Description
    Name Text Field size 30 Name of company/site
    URL Text Field size 50 URL of company/site
  1. Add 40 records to the database. All records must be concerned with South Africa. Be sure to have the URL of the SABC, your favourite radio station, magazine, shop, singer and sports team.
  2. Sort the data alphabetically according to the name of the company/site field name.
  3. Print the sorted table on ONE page. (The name of the table is your name so you do not have to add your name again.)
  4. Onsite learners hand in. 
  5. Online learners fax the table to school: Phone 531 7415 Attention Computer Teacher. Phone your Computer Studies Teacher two days after submitting the work to discuss the task - no phone call and discussion, no mark.

Return to Computer Studies lesson plan index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.