O Home O Newsletters O Conference 2002 O
 O Past Conferences O PC Drivers Licence O National Moderation O CIC O Bluebook O Forum O Job Vacancies O


Prescription:IC220 Databases (flat-file)

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

Credits 5

Suggested Time 50 student learning hours

Prescription Expiry Date Nov 2003


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
   
Introduction
Regulations
Module Prescriptions
 


Back to list of Prescriptions



Introduction O Regulations O Module Prescriptions O


O Home O Newsletters O Conference 2002 O Past Conferences O PC Drivers Licence O National Moderation O CIC O
O Bluebook O Forum O Job Vacancies O