EFS CO8

Unit CO8 Element Maintain and use databases (Admin level 3 Unit 307, imported unit CfA) CO8.1 Retrieve and enter data to update database Simulation is not acceptable for this element. Assessment should be conducted on several occasions, over time, to ensure demonstration of consistency of competence against the specified standards. You must ensure that: a) obtain any necessary permission to access database files b) correctly locate and retrieve the data required by the customer1 c) effectively maintain data structures to meet customer’s requirements d) when required, create fields with specified characteristics to effectively meet customer’s requirements e) when required, modify field characteristics to meet customer’s requirements and maintain the integrity of existing data f) when necessary, promptly seek guidance, from the relevant person(s) g) input data accurately, completely and to meet your customer’s requirements h) effectively use available automated facilities2 for data checking i) when necessary, effectively use online help facilities j) save files to preserve their integrity and to comply with your organisation’s requirements3 k) promptly and accurately report any problems to the relevant person                You must know and understand: How to interpret and apply your customers’ requirements How to locate and retrieve database files How to maintain data structures How to create fields and field characteristics How to use the available software and automated facilities How to use program help files How to save database files How to follow your organisation’s requirements for saving files The person(s) from whom to gain authority to access files The importance of meeting your customers’ requirements The limits of your own responsibility for data entry and updating database files The reasons why access authority is required for certain files The importance of checking the data The importance of conforming to your organisation’s requirements The person to whom you report EFS CO D/05/2001 Final Draft – 4 May 2001 Unit CO8 Element Maintain and use databases (Admin level 3 Unit 307, imported unit CfA) CO8.2 Extract the required information Simulation is not acceptable for this element. Assessment should be conducted on several occasions, over time, to ensure demonstration of consistency of competence against the specified standards. You must ensure that: a) make sure the given database document format meets your customer’s requirements b) correctly translate customer information requirements by using database interrogation c) correctly process the extracted information and save it to meet requirements d) effectively use the software facilities provided to achieve the required data format and page lay out requirements e) promptly raise any queries arising during the production of the document with the relevant person(s) f) when necessary, effectively use program help files g) make sure the final document is complete and meets customers' requirements           You must know and understand: How to interpret and apply customers’ requirements for database documents How to use the software functions effectively for manipulating data interrogation facilities How to use the software available to produce database documents How to use the software functions effectively for formatting database documents How to use the software functions effectively for page lay out How to use program help files The person(s) with whom to raise queries Your customers’ requirements for the document to be produced The factors influencing the choice of software facilities and functions to produce database documents The importance of meeting customers’ requirements EFS CO D/05/2001 Final Draft – 4 May 2001 Unit CO8 Element Maintain and use databases (Admin level 3 Unit 307, imported unit CfA) CO8.3 Output specified information to the required destination Simulation is not acceptable for this element. Assessment should be conducted on several occasions, over time, to ensure demonstration of consistency of competence against the specified standards. You must ensure that: a) make sure the selected database document is complete and ready for output b) use the database document output devices that are suitable for meeting customer’s requirements c) set the printer output parameters to meet the output requirements d) make sure the final database document is complete and meets your customer’s requirements e) where necessary, use methods of outputting database documents to preserve confidentiality        You must know and understand: How to select the destination required How to interpret instructions for using output devices How to identify and set up parameters to meet output requirements and preserve confidentiality How to use methods for checking output devices The factors influencing your decision in choice of output device Your customers’ requirements for document outputs The occasions when confidentiality should be preserved EFS CO D/05/2001 Final Draft – 4 May 2001