These objectives aim to provide learners with a comprehensive understanding of databases, their concepts, and practical skills in creating and managing databases using various tools and techniques.
In the section on databases, the following topics are covered:
- Definition of Database (4.3.4)
- Database Concepts (4.3.5)
- Traditional Filing Methods (Manual and Flat Files) (4.3.5)
- Functions of Databases (4.3.5)
- Types of Database Models (4.3.5)
- Database Software (4.3.5)
- Features of a Database (e.g., Data Structure, Report Generating Query Language, Modules) (4.3.5)
- Data Organization (4.3.6)
- Character Types
- Fields
- Records
- Files
- Database
- Creating a Database (4.3.7)
- Designing a Database Structure
- Field Properties and Data Types
- Key-Fields and Index
- Data Entry
- Editing a Database (4.3.8)
- Modifying Structure
- Updating Database
- Form Design (4.3.9)
- Form Layout
- Data Manipulation
- Formatting Fields
- Queries (4.3.10)
- Creating
- Updating
- Viewing
- Printing
- Reports Layout (4.3.11)
- Creating (Using Rational and Logical Operators: AND, OR, NOT)
- Modifying
- Sorting and Grouping
- Labeling
- Printing