Home

Newsletters

Journal

Conference

BACIT

Qualifications


Introduction

Regulations

Module Prescriptions


[ .. Back .. ]



Forum

Job Vacancies

Links




Information and Communications
Technology Qualifications


For full details refer to Qualification Regulations and to Appendix E Certificate in Computing (CIC)

| Back to list of Prescriptions


Prescription:AP320 Databases (flat-file)

Aim of Module To introduce students to the concepts and functions of flat-file databases.

Credits 5

Student Learning Hours 50

Content Revised 2001

Prescription Expiry Date Nov 2005


Level and Assessment Schedule
TopicsHighest
Skill Level
Suggested
Assessment
Percentage
1 Basic Principles C 20
2 Practical Application A 80

100

LEARNING OUTCOMES

The Student Will
C1Demonstrate an understanding of the basic terminology of databases, and know what data types are available.
A2Complete a practical exercise to demonstrate understanding of the basic principles.

CONTENT

1  Basic Principles
> Define the following terms and concepts relative to the package being used:
File (Table)
Record (row, entity)
Field (column, attribute)
Field characteristics (name, format content)
File (table) structure
Form
Report
Table view/form view
Sort
Query
Filter
> Describe the purpose of data types eg Alphanumeric, Numeric, Date, Logical
> Plan and design a database for a simple problem
top
2  Practical Application
> Complete a practical exercise(s) using a database package which involves:
Creating a file (table) structure requiring various data types
Creating a simple data-entry form
Adding records
Changing records
Deleting records
Using table and form views
Changing the sort order
Performing a simple query
Performing simple calculations
Generating and printing a report using the standard report generator with title and column headings
Generating and printing a report using the standard report generator with title and column headings based on a query
Check data and compare with original sources
Modify a standard report
top



| Home | Newsletters | Journal | Conference | BACIT | Qualifications | Forum | Job Vacancies | Links |