{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Access TNA Intermediate"],"not_rendered":{"charts":1,"external_links":2,"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"Access TNA Intermediate","index":0,"n_rows":61,"n_cols":5,"rows_kept":61,"merged":[[0,0,0,4],[1,0,1,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[10,1,11,4],[12,1,12,4],[15,1,15,2],[18,1,18,2],[22,1,22,2],[30,1,30,2],[34,1,34,2],[38,1,38,2],[43,1,43,2],[60,1,62,4]]}
["ATI-Mirage Training Solutions"]
["Access - Intermediate - Training Needs Analysis (TNA)"]
[]
["Name:"]
["Organisation Name:"]
["Department:"]
["Telephone:"]
["Mobile :"]
["Email:"]
[]
[null,"Please choose one response that most accurately describes your knowledge level for each topic. This is not a test, therefore your responses will address your training needs for the level that you are at."]
[]
[null,"Use the Blue Coloured cells if you know all of a Section, otherwise click the yellow cell to select an option"]
[]
[null,"Section","Question","ALL","Response"]
[{"$f":"IF(ISBLANK(B16),\"\",\"A\")","v":"A"},"Review of introductory concepts"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Designing Tables",null,{"$f":"IF($D$16=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Working with Queries",null,{"$f":"IF($D$16=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"Table field Properties"]
[null,{"$f":"IF(ISBLANK(C20),\"\",B18+1)","v":3},"Required fields",null,{"$f":"IF($D$19=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":4},"Validating data",null,{"$f":"IF($D$19=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C22),\"\",B21+1)","v":5},"Lookup fields",null,{"$f":"IF($D$19=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B23),\"\",\"C\")","v":"C"},"Action Queries"]
[null,{"$f":"IF(ISBLANK(C24),\"\",B22+1)","v":6},"Create Make Table queries",null,{"$f":"IF($D$23=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C25),\"\",B24+1)","v":7},"Create Delete queries",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C26),\"\",B25+1)","v":8},"Create Append queries",null,"click to select value"]
[null,9,"Create Update queries",null,"click to select value"]
[null,10,"Create Parameter queries",null,"click to select value"]
[null,11,"Create Calculations in queries",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":12},"Create Crosstab queries",null,"click to select value"]
[{"$f":"IF(ISBLANK(B31),\"\",\"D\")","v":"D"},"Table Relationships"]
[null,{"$f":"IF(ISBLANK(C32),\"\",B30+1)","v":13},"Create relationships between tables",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C33),\"\",B32+1)","v":14},"Relational database concepts",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":15},"Referential Integrity settings",null,{"$f":"IF($D$31=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B35),\"\",\"E\")","v":"E"},"Complex Query Design"]
[null,{"$f":"IF(ISBLANK(C36),\"\",B34+1)","v":16},"Multi-table queries",null,{"$f":"IF($D$35=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C37),\"\",B36+1)","v":17},"Creating and using joins",null,{"$f":"IF($D$35=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C38),\"\",B37+1)","v":18},"Using a Query as the data for a form",null,{"$f":"IF($D$35=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B39),\"\",\"F\")","v":"F"},"Designing Forms and Reports"]
[null,{"$f":"IF(ISBLANK(C40),\"\",B38+1)","v":19},"Create forms and reports using the wizard",null,{"$f":"IF($D$39=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C41),\"\",B40+1)","v":20},"Using the design view to modify Forms and Reports",null,{"$f":"IF($D$39=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C42),\"\",B41+1)","v":21},"Form/Report Component properties",null,{"$f":"IF($D$44=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,22,"Add controls to a form",null,{"$f":"IF($D$44=\"All\",$B$58,$B$59)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B44),\"\",\"G\")","v":"G"},"Special Design Options"]
[null,{"$f":"IF(ISBLANK(C45),\"\",B43+1)","v":23},"Use design effects for Forms and Reports",null,{"$f":"IF($D$44=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C46),\"\",B45+1)","v":24},"Create Sub Forms and Sub Reports",null,{"$f":"IF($D$44=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C47),\"\",B46+1)","v":25},"Use sections and grouping for Report analysis",null,{"$f":"IF($D$44=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,26,"Use Formulae for data validation",null,{"$f":"IF($D$44=\"All\",$B$58,$B$59)","v":"click to select value"}]
[null,27,"Copy validation settings",null,{"$f":"IF($D$44=\"All\",$B$58,$B$59)","v":"click to select value"}]
[]
[]
[null,null,"PLEASE ENSURE THAT YOU HAVE ANSWERED ALL QUESTIONS"]
[]
[null,"Responses","Score","Percentage"]
[null,"No Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C55/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C56/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C57/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C58/COUNTA($E$17:$E$49))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$50,click_to_select_value))","v":27},{"$f":"IF(ISBLANK($E$17),\"\",C59/COUNTA($E$17:$E$49))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C59>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR(D55>=CriteriaToPass,(D55+D56)>=CriteriaToPass),\"We suggest that you do the Introduction course\",IF(D58>80%,\"Based on your response you have good knowledge of Intermediate  concepts, we suggest that you do the Advanced TNA, to check if you would be comfortable doing the Advanced Course\",\"Based on your responses you have  knowledge of some Intermediate  concepts, we suggest that you do the  Intermediate Course\")))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]