1. Introduction to Database

Topic Description
Database Collection of related data
DBMS Software to manage database
Advantages Storage, security, easy access
  • Understand database concept
  • Learn DBMS basics
  • Know advantages

2. Database Elements

Element Description
Table Rows and columns
Record Row in table
Field Column in table
Primary Key Unique identifier
  • Understand structure
  • Organize data
  • Identify keys

3. MS Access Basics

Topic Description
Create Database New database file
Tables Create and manage
Forms Data entry screen
Reports Output data
  • Create database
  • Manage tables
  • Use forms and reports

4. Basic Queries (SQL)

Query Description
SELECT Retrieve data from table
INSERT Add new record
UPDATE Modify existing data
DELETE Remove data
WHERE Filter specific records
  • Use basic SQL queries
  • Retrieve and manage data
  • Apply conditions

5. Data Management

Task Description
Add Data Insert records
Edit Data Update records
Delete Data Remove records
  • Maintain database
  • Update information
  • Manage records

6. Practical (COPA Trade)

Practical Work Description
Create Database Make new database
Create Table Add fields and records
Run Queries Use SELECT, INSERT, UPDATE
Forms Create entry form
Reports Generate report
  • Practice database tasks
  • Use queries practically
  • Prepare for exam