^

 
 

Unit of competency details

BSBITU301 - Create and use databases (Release 1)

Summary

Usage recommendation:
Superseded
Mapping:
MappingNotesDate
Supersedes and is equivalent to BSBITU301A - Create and use databasesUpdated to meet Standards for Training Packages 24/Mar/2015
Is superseded by and equivalent to BSBITU311 - Use simple relational databases 26/Sep/2018

Releases:
ReleaseRelease date
1 1 (this release) 25/Mar/2015


Training packages that include this unit

CodeSort Table listing Training packages that include this unit by the Code columnTitleSort Table listing Training packages that include this unit by the Title columnRelease
CPC08 - Construction, Plumbing and Services Training PackageConstruction, Plumbing and Services Training Package 9.3-9.8 
RGR - Racing and Breeding Training PackageRacing and Breeding Training Package 2.0 
CUA - Creative Arts and Culture Training PackageCreative Arts and Culture Training Package 2.0-4.1 
BSB - Business Services Training PackageBusiness Services Training Package 1.0-2.0 
SIT - Tourism, Travel and Hospitality Training PackageTourism, Travel and Hospitality Training Package 1.0-1.2 
HLT - HealthHealth 2.0-6.1 

Qualifications that include this unit

CodeSort Table listing Qualifications that include this unit by the Code columnTitleSort Table listing Qualifications that include this unit by the Title columnRelease
SIT40316 - Certificate IV in Holiday Parks and ResortsCertificate IV in Holiday Parks and Resorts
CPC40808 - Certificate IV in Swimming Pool and Spa BuildingCertificate IV in Swimming Pool and Spa Building
BSB30815 - Certificate III in RecordkeepingCertificate III in Recordkeeping1-2 
SIT50416 - Diploma of Hospitality ManagementDiploma of Hospitality Management
BSB31115 - Certificate III in Business Administration (Medical)Certificate III in Business Administration (Medical)
CPC40408 - Certificate IV in Building and Construction (Sales)Certificate IV in Building and Construction (Sales)
CPC40508 - Certificate IV in Building and Construction (Site Management)Certificate IV in Building and Construction (Site Management)
BSB30515 - Certificate III in Business Administration (International Education)Certificate III in Business Administration (International Education)1-2 
BSB30415 - Certificate III in Business AdministrationCertificate III in Business Administration
HLT40213 - Certificate IV in Aboriginal and/or Torres Strait Islander Primary Health Care PracticeCertificate IV in Aboriginal and/or Torres Strait Islander Primary Health Care Practice5-7 
HLT46115 - Certificate IV in Indigenous Environmental HealthCertificate IV in Indigenous Environmental Health
CPC40308 - Certificate IV in Building and Construction (Estimating)Certificate IV in Building and Construction (Estimating)
CPC40912 - Certificate IV in Plumbing and ServicesCertificate IV in Plumbing and Services
BSB30915 - Certificate III in Business Administration (Education)Certificate III in Business Administration (Education)1-2 
CPC40110 - Certificate IV in Building and Construction (Building)Certificate IV in Building and Construction (Building)6-7 
SIT30816 - Certificate III in Commercial CookeryCertificate III in Commercial Cookery
SIT30116 - Certificate III in TourismCertificate III in Tourism1-2 
SIT50116 - Diploma of Travel and Tourism ManagementDiploma of Travel and Tourism Management
CPC40611 - Certificate IV in Building and Construction (Specialist Trades)Certificate IV in Building and Construction (Specialist Trades)
SIT60316 - Advanced Diploma of Hospitality ManagementAdvanced Diploma of Hospitality Management
BSB30115 - Certificate III in BusinessCertificate III in Business1-2 
SIT30416 - Certificate III in Holiday Parks and ResortsCertificate III in Holiday Parks and Resorts
HLT46015 - Certificate IV in Population HealthCertificate IV in Population Health
SIT30916 - Certificate III in Catering OperationsCertificate III in Catering Operations
SIT50316 - Diploma of Event ManagementDiploma of Event Management
CUA30915 - Certificate III in Music IndustryCertificate III in Music Industry1-2 
SIT40416 - Certificate IV in HospitalityCertificate IV in Hospitality
SIT30216 - Certificate III in TravelCertificate III in Travel
SIT40516 - Certificate IV in Commercial CookeryCertificate IV in Commercial Cookery
HLT40113 - Certificate IV in Aboriginal and/or Torres Strait Islander Primary Health CareCertificate IV in Aboriginal and/or Torres Strait Islander Primary Health Care5-7 
SIT40716 - Certificate IV in PatisserieCertificate IV in Patisserie
CUA30615 - Certificate III in Arts AdministrationCertificate III in Arts Administration1-2 
BSB40615 - Certificate IV in Business SalesCertificate IV in Business Sales1-2 
CPC40708 - Certificate IV in Building and Construction (Trade Contracting)Certificate IV in Building and Construction (Trade Contracting)
BSB41315 - Certificate IV in MarketingCertificate IV in Marketing
BSB31015 - Certificate III in Business Administration (Legal)Certificate III in Business Administration (Legal)
SIT30516 - Certificate III in EventsCertificate III in Events1-2 
SIT31016 - Certificate III in PatisserieCertificate III in Patisserie
HLT37415 - Certificate III in Pathology AssistanceCertificate III in Pathology Assistance1-2 
SIT30616 - Certificate III in HospitalityCertificate III in Hospitality1-2 
CPC40208 - Certificate IV in Building and Construction (Contract Administration)Certificate IV in Building and Construction (Contract Administration)
SIT40816 - Certificate IV in Asian CookeryCertificate IV in Asian Cookery
SIT40616 - Certificate IV in Catering OperationsCertificate IV in Catering Operations
SIT50216 - Diploma of Holiday Park and Resort ManagementDiploma of Holiday Park and Resort Management
SIT31116 - Certificate III in Asian CookeryCertificate III in Asian Cookery
RGR30418 - Certificate III in Racing ServicesCertificate III in Racing Services
SIT40116 - Certificate IV in Travel and TourismCertificate IV in Travel and Tourism
Items per page 10 | 20 | 50 | 100
Displaying items 1 - 47 of 47

Classifications

SchemeCodeClassification value
ASCED Module/Unit of Competency Field of Education Identifier 080905 Practical Computing Skills  

Classification history

SchemeCodeClassification valueStart dateEnd date
ASCED Module/Unit of Competency Field of Education Identifier 080905 Practical Computing Skills  30/Jul/2015 
The content being displayed has been produced by a third party, while all attempts have been made to make this content as accessible as possible it cannot be guaranteed. If you are encountering issues following the content on this page please consider downloading the content in its original form

Unit Of competency

Modification History

Release 

Comments 

Release 1

This version first released with BSB Business Services Training Package Version 1.0.

Application

This unit describes the skills and knowledge required to create simple two-table relational databases with reports and queries, for storage and retrieval of information.

It applies to individuals that may provide administrative support within an enterprise, or may be independently responsible for storage and retrieval of data relating to their own work roles.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

Unit Sector

Information and communications Technology – IT use

Elements and Performance Criteria

ELEMENT 

PERFORMANCE CRITERIA 

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Create a simple database

1.1 Design a simple database, with at least two tables, 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 Modify table layout and field attributes as required

1.5 Create a relationship between the two tables

1.6 Check and amend data entered, in accordance with organisational and task requirements

2. Create reports and queries

2.1 Determine information output, database tables to be used and report layout to meet task requirements

2.2 Determine data groupings, search and sort criteria to meet task requirements

2.3 Run reports and queries to check results and formulae provide the required data

2.4 Modify reports to include or exclude additional requirements

3. Use database

3.1 Ensure data input meets designated timelines and organisational requirements for speed and accuracy

3.2 Use manuals, user documentation and online help to overcome problems with database design and production

3.3 Preview, adjust and print 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 person in a suitable format

Foundation Skills

This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.

Skill 

Performance 

Criteria 

Description 

Reading

1.1-1.6, 2.1-2.4, 3.1-3.5

  • Recognises and interprets textual and numerical information to determine and confirm tasks are completed as per requirements

Writing

1.1-1.6, 2.1-2.4, 3.1-3.4

  • Inputs numerical and key reporting information when creating and querying databases, and uses standard naming conventions and format to organise data

Numeracy

1.1, 1.2, 1.6, 2.1-2.4

  • Uses mathematical equations to create simple database queries and formulae

Navigate the world of work

1.2, 1.4, 1.6, 2.1-2.3, 3.1, 3.3, 3.4

  • Recognises and follows explicit and implicit protocols and meets expectations associated with own role

Get the work done

1.1-1.6, 2.1-2.4, 3.1-3.5

  • Plans, organises and competes tasks to meet organisational requirements
  • Utilises a broad range of features within applications in performing routine and complex tasks

Unit Mapping Information

Code and title  

current version 

Code and title 

previous version 

Comments 

Equivalence status 

BSBITU301 Create and use databases

BSBITU301A Create and use databases

Updated to meet Standards for Training Packages

Equivalent unit

Links

Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=11ef6853-ceed-4ba7-9d87-4da407e23c10

 

Assessment requirements

Modification History

Release 

Comments 

Release 1

This version first released with BSB Business Services Training Package Version 1.0.

Performance Evidence

Evidence of the ability to:

  • adhere to organisational requirements when inputting, amending and storing data including:
  • correct naming conventions
  • adhere closely to task requirements including:
  • following designated timelines
  • achieving speed and accuracy
  • create simple databases including:
  • reports and queries
  • follow designated timelines
  • correctly name and store data
  • distribute reports to appropriate personnel.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

  • outline key provisions of relevant legislation, standards and codes that may affect aspects of business operations
  • describe organisational requirements relating to data entry, storage and presentation.

Assessment Conditions

Assessment must be conducted in a safe environment where evidence gathered demonstrates consistent performance of typical activities experienced in the information and communications technology – IT use field of work and include access to:

  • business technology
  • workplace documentation and resources
  • industry database software applications.

Assessors must satisfy NVR/AQTF assessor requirements.

Links

Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=11ef6853-ceed-4ba7-9d87-4da407e23c10