Unit of competency Outline

Date retreived
23/07/2026 12:14 AM 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.

Use simple relational databases

Use simple relational databases

Unit of competency
National Code
BSBITU311
State Code
OAE78
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
27/09/2018
View on TGA
State Implementation and Classification
Approved Date
14/02/2019
Field of Education
080905 - Practical Computing Skills
Original Release Date
14/02/2019
Nominal Hours
20
Description
This unit describes the skills and knowledge required to use simple two-table relational databases with reports and queries, for storage and retrieval of information.It applies to individuals that may provide administrative support and analysis within an enterprise, or may be independently responsible for storage, retrieval and simple analysis of data relating to their own work roles.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Create a simple database
  • 1.1 Plan a simple one-to-one relational database, using a database application, basic design principles, software functions and simple formulae
  • 1.2 Develop a table with fields and attributes according to database usage, as well as data considerations and user requirements
  • 1.3 Create a primary key for each table
  • 1.4 Create a relationship between the two tables by assigning a foreign key
  • 1.5 Modify table layout and field attributes as required
  • 1.6 Check and amend data entered, in accordance with organisational and task requirements
2. Create reports and queries
  • 2.1 Identify information output, database tables to be used and report layout, in accordance with task requirements
  • 2.2 Identify data groupings, search and sort criteria, in accordance with task requirements
  • 2.3 Run reports and queries to check that results and formulae provide the required data
  • 2.4 Modify reports to include or exclude additional requirements, where necessary
3. Use database
  • 3.1 Ensure data input meets designated timelines and organisational requirements for speed and accuracy
  • 3.2 Use help functions to overcome simple issues with database design and production
  • 3.3 Preview, adjust and produce database reports or forms in accordance with organisational and task requirements
  • 3.4 Name and store databases, in accordance with organisational requirements, and exit application without data loss or damage
  • 3.5 Prepare and distribute reports to appropriate personnel in a suitable format
No information
No information
Replaces
State Code National Code Title Type
AUI28 BSBITU301 Create and use databases Unit of competency
Replaced By
State Code National Code Title Type
OCE02 BSBTEC302 Design and produce spreadsheets Unit of competency