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

{"sheet":"Access Introduction TNA","index":0,"n_rows":70,"n_cols":5,"rows_kept":70,"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],[21,1,21,2],[31,1,31,2],[40,1,40,2],[49,1,49,2],[69,1,71,4]]}
["ATI-Mirage Training Solutions"]
["Access Introduction - 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"},"Database Concepts"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Database Concepts: field, record,cell,table",null,{"$f":"IF($D$16=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Designing a database",null,{"$f":"IF($D$16=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C19),\"\",B18+1)","v":3},"Relational Database concepts",null,{"$f":"IF($D$16=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,4,"Database objects",null,{"$f":"IF($D$16=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,5,"Familiarity with the database window / pane",null,{"$f":"IF($D$16=\"All\",$B$67,$B$68)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B22),\"\",\"B\")","v":"B"},"Database Tables"]
[null,{"$f":"IF(ISBLANK(C23),\"\",B21+1)","v":6},"Work with database tables",null,{"$f":"IF($D$22=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C24),\"\",B23+1)","v":7},"Design and create database tables with own fields",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C25),\"\",B24+1)","v":8},"Work with and create Lookup Tables in Design view",null,"click to select value"]
[null,9,"Work with Table structures and field properties",null,"click to select value"]
[null,10,"Set the primary key",null,"click to select value"]
[null,11,"Create transactional table(s) / Lookup Tables",null,"click to select value"]
[null,12,"Add/edit records (information) in a table",null,"click to select value"]
[null,13,"Search for data in a table",null,"click to select value"]
[null,14,"Sort and filter data on a table",null,"click to select value"]
[{"$f":"IF(ISBLANK(B32),\"\",\"C\")","v":"C"},"Queries"]
[null,{"$f":"IF(ISBLANK(C33),\"\",B31+1)","v":15},"Create a basic Query",null,{"$f":"IF($D$32=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C34),\"\",B33+1)","v":16},"Work with Select Queries",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C35),\"\",B34+1)","v":17},"Familiarity with Query concepts",null,"click to select value"]
[null,18,"Design a select Query",null,"click to select value"]
[null,19,"Add criteria to a Query",null,"click to select value"]
[null,20,"Use views of a Query",null,"click to select value"]
[null,21,"Use wildcards in a Query",null,"click to select value"]
[null,22,"Create calculations in a Query",null,"click to select value"]
["D","Forms"]
[null,{"$f":"IF(ISBLANK(C42),\"\",B40+1)","v":23},"Create a basic Form",null,{"$f":"IF($D$41=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C43),\"\",B42+1)","v":24},"Enter data in a Form",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C44),\"\",B43+1)","v":25},"Work with a form in Design View",null,"click to select value"]
[null,26,"Work with a form in Layout View",null,"click to select value"]
[null,27,"Format objects on a Form",null,"click to select value"]
[null,28,"Work the Properties in a Form",null,"click to select value"]
[null,29,"Move and Re-size, a form and objects on a Form",null,"click to select value"]
[null,30,"Print a Form",null,"click to select value"]
["E","Reports"]
[null,{"$f":"IF(ISBLANK(C51),\"\",B49+1)","v":31},"Create a basic Report",null,{"$f":"IF($D$50=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C52),\"\",B51+1)","v":32},"Use a Wizard to create a Report",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C53),\"\",B52+1)","v":33},"Use Grouping in a Report",null,"click to select value"]
[null,34,"Create calculations in a Report",null,"click to select value"]
[null,35,"Work with Report in Design View",null,"click to select value"]
[null,36,"Print a Report",null,"click to select value"]
[null,37,"Change Page set for a Report",null,{"$f":"IF($D$50=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,38,"Print a Document",null,"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$59,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C64/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C65/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C66/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C67/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,click_to_select_value))","v":38},{"$f":"IF(ISBLANK($E$17),\"\",C68/COUNTA($E$17:$E$58))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C68>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR($D$64>=CriteriaToPass,$D$65>=CriteriaToPass),\"We suggest that you do the Introduction course\",IF($D$67>80%,\"Based on your responses you have good knowledge of Introductory  concepts, we suggest that you do the Intermediate TNA, to check if you would be comfortable doing the Intermediate Course\",\"Based on your responses you have  knowledge of some Introduction  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"}]