Unit of competency Outline

Date retreived
22/07/2026 2:56 PM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Operate simple database applications

Operate simple database applications

Unit of competency
National Code
ICTICT226
State Code
ODT27
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
03/02/2022
View on TGA
State Implementation and Classification
Approved Date
25/05/2022
Field of Education
080905 - Practical Computing Skills
Original Release Date
25/05/2022
Nominal Hours
35
Description
This unit describes the skills and knowledge required to set up, customise and review relational databases using pre-existing data. It includes performing simple data operations to document insights in the form of a data report.The unit applies to individuals who may work in roles such as support desk technicians, who use simple database applications in established contexts.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Set up database settings
  • 1.1 Confirm work brief and tasks according to organisational policies and procedures
  • 1.2 Adjust page layout to meet user requirements
  • 1.3 Identify and compare different toolbar options
  • 1.4 Format font for the purpose of database entries
2. Prepare forms
  • 2.1 Confirm type of form, field lists, design and layouts
  • 2.2 Create simple form according to work brief
  • 2.3 Open database and modify records through the simple form
  • 2.4 Rearrange objects in simple form according to work brief
3. Execute and evaluate database queries
  • 3.1 Run database query according to work brief
  • 3.2 Review query outputs according to work brief
  • 3.3 Confirm that outputs present data in logical sequences
4. Retrieve information
  • 4.1 Locate required database records according to work brief
  • 4.2 Run database applications and document outputs
  • 4.3 Display outputs as required according to work brief
  • 4.4 Save outputs in secure location according to organisational requirements
5. Create and store data reports
  • 5.1 Develop report from outputs according to work brief
  • 5.2 Confirm that data report contains required information according to work brief
  • 5.3 Confirm that report presents data in logical sequences
  • 5.4 Format and distribute reports to required personnel
  • 5.5 Seek and implement feedback from required personnel
  • 5.6 Finalise and store data report according to organisational requirements
No information
No information
Replaces
State Code National Code Title Type
AUU21 ICTICT210 Operate database applications Unit of competency
State Code National Code Title Type
BGJ3 ICT20120 Certificate II in Applied Digital Technologies Qualification