Page 14 - TP_IT_V1.0_C10_flipbpookl
P. 14
Chapter 10: Develop skills in editing and Editing and Deleting tables, Insert Data in the Table: Add new data entries to a table.
Working with deleting tables, creating and Relationships between Edit Records in the Table: Modify existing records within
Multiple Tables managing table relationships, tables the table.
and ensuring referential
integrity. Types of Relationships– one Delete Records from Table: Remove specific records from
to one, one to many, many the table.
to many Sort Data in the Table: Arrange data in ascending or
Advantages of Relating descending order within the table.
Tables in a Database Create and Edit Relationships: Establish and
Creating Relationships modify relationships between tables, including
between Tables one-to-one, one-to- many, and many-to-many.
Referential Integrity Enter Various Field Properties: Set and adjust different
properties for fields in the table.
Chapter 11: Acquire skills in creating Queries Prepare a Query for Given Criteria: Create a query based
Queries in Base and editing queries using both Query creation using wizard on specified criteria.
wizards and design view, and Create a Query Using Wizard and Design View:
working with numerical data Creation of query using Demonstrate how to generate a query using both the
in queries. design view
Editing a query, wizard and design view.
Working with Numerical Edit a Query: Modify an existing query to update its
Data criteria or structure.
Apply Various Criteria in a Query: Demonstrate applying
different criteria in a query, including single field, multiple
fields, and wildcard searches.
Perform Calculations Using Query in Base: Execute
calculations within a query in LibreOffice Base.
Chapter 12: Able to create and modify Forms in BASE. Create a Form Using Form Wizard: Generate a form by
Forms and forms and reports in Creating form using wizard, following the steps in the Form Wizard.
Reports LibreOffice Base, use the Enter or Remove Data from Forms: Input new data or
Form Controls Toolbar, and Modifying a Form delete existing data using forms.
insert additional controls, Form Controls Toolbar
titles, headings, and date/time Report in Base Modify Forms: Demonstrate how to adjust and customize
elements in reports. Inserting other controls in forms.
report Change Label and Background: Modify the label text and
Inserting Titles & Headings background color or design of a form.
Inserting Date & Time Search Records Using a Form: Use the form to find specific
records based on search criteria.
Insert and Delete Records Using Form View: Add new
records or remove existing ones through the Form View.
Create a Report Using Report Wizard: Illustrate the steps
to generate a report using the Report Wizard.
Demonstrate Various Report Examples: Provide examples of
different types of reports created using the Report Wizard.
Unit 4: Maintain Healthy, Safe and Secure Working Environment
SUB UNIT LEARNING OUTCOMES THEORY PRACTICAL
Chapter 13. Understand workplace health, Introduction to Health, Safety, and Security At Practice Basic Safety Rules:
Health, Safety safety, and security policies, Workplace Implement fire safety measures,
and Security at identify various hazards, and Policies and Procedures for Healthy, Safety and Security prevent falls and slips, ensure
Workplace learn how to manage risks electrical safety, and apply
and maintain a safe working Reasons for Health, Safety, and Security Programs first aid procedures to protect
environment. or Policies in the Workplace workers and prevent accidents.
Workplace Safety Hazards
Physical Hazards
Falling Off Heights, Slipping and Tripping
Electrical Hazards
Fire Hazards
Health Hazards
Potential Sources of Hazards in an Organisation
Hazards using Computers
Handling Office Equipment
Handling Objects
Stress at Work
Working Environment
Hazard Control
Safety Guidelines Checklist

