Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Create a simple database
   • Design a simple database, with at least two tables, using a database application, basic design principles, software functions and simple formulae
   • Develop a table with fields and attributes according to database usage, as well as data considerations and user requirements
   • Create a primary key for each table
   • Modify table layout and field attributes as required
   • Create a relationship between the two tables
   • Check and amend data entered, in accordance with organisational and task requirements
2. Create reports and queries
   • Determine information output, database tables to be used and report layout to meet task requirements
   • Determine data groupings, search and sort criteria to meet task requirements
   • Run reports and queries to check results and formulae provide the required data
   • Modify reports to include or exclude additional requirements
3. Use database
   • Ensure data input meets designated timelines and organisational requirements for speed and accuracy
   • Use manuals, user documentation and online help to overcome problems with database design and production
   • Preview, adjust and print database reports or forms in accordance with organisational and task requirements
   • Name and store databases, in accordance with organisational requirements, and exit application without data loss or damage
   • Prepare and distribute reports to appropriate person in a suitable format