PHS badge

PHS CyberSchool

Computer Studies SG

Modified 02 March 2005

Access basic theory exercise - 37 marks

Online learners send the answers as an email message. Onsite learners complete the work on foolscap paper.

Using the Access / Help menu / Glossary, a computer dictionary or glossary, and Access itself, answer the following questions.   The web site www.fgcu.edu/support/office2000/access/index.html is very useful resource.

Section A

  1. What is the file extension for an Access database? (1)
  2. What is a database? (3)
  3. Two kinds of databases are Flatfile and Relational. Which kind of database is Access? (1)
  4. Name five objects in a database. (5)
  5. The table is the basic organisational structure of a database. Name five data types found in a database table. (5)
  6. In which view of a table in a database do you edit or add data? - Design view or Datasheet view (1)
  7. What is a field? (1)
  8. List the five data field types found in a database table, and indicate the characteristics of each. (5)
  9. Give examples of four text fields found in a school database table showing personal particulars. (4)
  10. Give examples of one date/time field found in a school database table showing personal particulars. (1)
  11. What is a primary key? (1)
  12. What would be the primary key in a school database table? (1)
  13. What would be the primary key in a database table at the Department of Home Affairs? (1)

/30/

Section B

Write down a letter/number of the item in Column B which best matches each of the descriptions in Column A.

Column A

Column B
  1. A collection of related information electronically stored and organized in a useful manner that acts as a base for retrieving information.
  2. A complete unit of related data items stored in named data fields in a database.
  3. A file that does not permit the information stored within it to be reorganized or linked to data in other files.
  4. A space reserved for a specified piece of information in a database record; a column in a database.
  5. A unique field used to identify a record in a database.
  6. One of four database structures in which files are linked in some way.
  7. To combine programs or systems for a special purpose.
  1. database
  2. field
  3. flat file
  4. integrate
  5. primary, key field
  6. record
  7. relational database

/7/

/37/

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