"Zpracov\u00E1n\u00ED dat"@cs . "Problematika zpracov\u00E1n\u00ED dat s vyu\u017Eit\u00EDm tabulkov\u00E9ho kalkul\u00E1toru Excel a datab\u00E1zov\u00E9ho syst\u00E9mu Access, sezn\u00E1men\u00ED s mechanismy zabezpe\u010Den\u00ED dat, se standardem XML, z\u00E1kladn\u00EDmi programovac\u00EDmi technikami MS Visual Basic. Obsah: Formulace, principy. \u00DAvod do XML technologie, implementace v MS Office. Visual Basic, Makra. Zabezpe\u010Den\u00ED v MS Office. MS Excel (\u00DAvod; Excel jako kalkula\u010Dka, funkce, zdroje informac\u00ED; Grafy; Pr\u00E1ce s rozs\u00E1hl\u00FDmi listy, seznamy, pr\u00E1ce s kl\u00E1vesnic\u00ED; Kontingen\u010Dn\u00ED tabulky; Pou\u017Eit\u00ED vzorc\u016F k \u00FAprav\u00E1m a korektur\u00E1m textu; Zji\u0161t\u011Bn\u00ED dat pomoc\u00ED vzorc\u016F, n\u011Bkter\u00E9 zaj\u00EDmav\u00E9 vzorce). MS Access (\u00DAvod, pojem datab\u00E1ze, ODBC, S\u0158BD; Relace, objekty; Tabulky, kl\u00ED\u010De, relace; Dotazy v\u00FDb\u011Brov\u00E9, parametrick\u00E9, k\u0159\u00ED\u017Eov\u00E9, ak\u010Dn\u00ED, SQL; Oper\u00E1tory porovn\u00E1vac\u00ED, aritmetick\u00E9, logick\u00E9, v\u00FDpo\u010Dty; Formul\u00E1\u0159e, ovl\u00E1dac\u00ED prvky; Sestavy, prezentace dat; Pr\u00E1ce s vn\u011Bj\u0161\u00EDmi datab\u00E1zemi). Zabezpe\u010Den\u00ED dat - \u0161ifrov\u00E1n\u00ED, integrita, autorizace." . . . . "I" . . "Zpracov\u00E1n\u00ED dat" . . . "Toman, Ji\u0159\u00ED" . "RIV/49777513:23420/10:43920846" . . . . "RIV/49777513:23420/10:43920846!RIV14-MSM-23420___" . "graphs; relations; SQL; database; Ms Office"@en . "Zpracov\u00E1n\u00ED dat"@cs . "Data processing using Excel spreadsheet and Access database system, introduction of mechanisms for data security, the XML standard, basic programming techniques in MS Visual Basic. Content: Formulation, principles. Introduction to XML technology and its implementation in MS Office. Visual Basic Macros. Security in MS Office. MS Excel (Introduction; Excel as a calculator, functions, sources of information; graph; working with large sheets, lists, work with the keyboard; pivot tables; using formulas to edit and proofread the text; detecting data using formulas, some interesting formulas). MS Access (Introduction, the term database, ODBC, DBMS; session, objects, tables, keys, session; inquiries selection, parametric, cross, action, SQL, comparison operators, arithmetic, logic, calculations, forms, controls, assemblies, presentations data; working with external databases). Data security - encryption, integrity, authorization."@en . "300464" . "[8C3003199C5C]" . "1"^^ . "https://kvd.zcu.cz/cz/secure/ict/kratkodobe/kurz_01_zpd/ebook1/index.htm" . "23420" . "Data processing"@en . "Data processing"@en . . . . "1"^^ . . . . "Problematika zpracov\u00E1n\u00ED dat s vyu\u017Eit\u00EDm tabulkov\u00E9ho kalkul\u00E1toru Excel a datab\u00E1zov\u00E9ho syst\u00E9mu Access, sezn\u00E1men\u00ED s mechanismy zabezpe\u010Den\u00ED dat, se standardem XML, z\u00E1kladn\u00EDmi programovac\u00EDmi technikami MS Visual Basic. Obsah: Formulace, principy. \u00DAvod do XML technologie, implementace v MS Office. Visual Basic, Makra. Zabezpe\u010Den\u00ED v MS Office. MS Excel (\u00DAvod; Excel jako kalkula\u010Dka, funkce, zdroje informac\u00ED; Grafy; Pr\u00E1ce s rozs\u00E1hl\u00FDmi listy, seznamy, pr\u00E1ce s kl\u00E1vesnic\u00ED; Kontingen\u010Dn\u00ED tabulky; Pou\u017Eit\u00ED vzorc\u016F k \u00FAprav\u00E1m a korektur\u00E1m textu; Zji\u0161t\u011Bn\u00ED dat pomoc\u00ED vzorc\u016F, n\u011Bkter\u00E9 zaj\u00EDmav\u00E9 vzorce). MS Access (\u00DAvod, pojem datab\u00E1ze, ODBC, S\u0158BD; Relace, objekty; Tabulky, kl\u00ED\u010De, relace; Dotazy v\u00FDb\u011Brov\u00E9, parametrick\u00E9, k\u0159\u00ED\u017Eov\u00E9, ak\u010Dn\u00ED, SQL; Oper\u00E1tory porovn\u00E1vac\u00ED, aritmetick\u00E9, logick\u00E9, v\u00FDpo\u010Dty; Formul\u00E1\u0159e, ovl\u00E1dac\u00ED prvky; Sestavy, prezentace dat; Pr\u00E1ce s vn\u011Bj\u0161\u00EDmi datab\u00E1zemi). Zabezpe\u010Den\u00ED dat - \u0161ifrov\u00E1n\u00ED, integrita, autorizace."@cs . . . "Zpracov\u00E1n\u00ED dat" .