|
 |
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
|
LEARNING OUTCOMES
The Student Will
| | | | C | 1 | Demonstrate an understanding of the basic terminology of databases, and know what data types are available. | | | | A | 2 | Complete a practical exercise to demonstrate understanding of the basic principles. |
CONTENT
| | | > | 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
| | | > | 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
|
|