Elements and Performance Criteria
- 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
- 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
- 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