|
Lecturer(s)
|
-
Kubát David, Ing. Ph.D., Ing.Paed.IGIP
|
|
Course content
|
Lectures (topics): 1. Databases: basic objects, tables, relationships, referential integrity. 2. Databases: M relationships, database management and analysis, data import and linking. 3. Databases: queries. 4. Databases: forms and reports. 5. Business intelligence - introduction, definitions, and key concepts. 6. Business intelligence - data types and sources, the ETL process. 7. Artificial intelligence - models, principles, ethics, and prompting. Seminars (topics): 1. Databases: relationships. 2. Databases: tables and simple queries. 3. Databases: advanced queries. 4. Databases: forms and reports. 5. Test. 6. Business intelligence - working with a simple dataset, data cleaning. 7. Business intelligence - creating a first simple report, working with filters and trends. 8. Business intelligence - analysis of a prepared dataset, simulation of a business decision based on a report. 9. Artificial intelligence - prompting. 10. Artificial intelligence - working with graphics. 11. Project work. 12. Test.
|
|
Learning activities and teaching methods
|
|
unspecified
|
|
Learning outcomes
|
Objective of the course in terms of learning outcomes and competences is to acquaint students with the MS Access database system with focus on enterprise management applications: database, relational, reference integrity, tables, queries, forms, subforms, graphs, reports, macros, modules. Visual Basic Basics. Collaboration of MS Access with other programs. Outputs for Internet and Intranet.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
unspecified
Credit: Successful completion of 2 tests during the semester - each for min. 70%, 80% attendance at seminars. Exam: Development and defense of the semester project.
|
|
Recommended literature
|
-
CAMERON, E. Exploring Microsoft Access 2016 Comprehensive. Upper Saddle River: Pearson, 2016. ISBN 978-0134479453.
-
KOROL, J. Microsoft Access 2016 Programming by Example. Duxbury: Mercury Learning and Information, 2016. ISBN 978-1942270843.
-
KROENKE, D. a D. J. AUER. Databáze. Brno: Computer Press, 2015. ISBN 978-80-251-4352-0.
-
KUBÁLEK, T. a M. KUBÁLKOVÁ. Databázový systém Microsoft Access 2016. Praha: Oeconomica, 2016. ISBN 978-80-245-2165-7.
-
KUBÁLEK, T., M. KUBÁLKOVÁ a I. TOPOLOVÁ. Microsoft Office 365: systém sjednocené komunikace. Praha: Oeconomica. Manažerská informatika (Oeconomica), 2014. ISBN 978-80-245-2019-3.
-
SHEPHERD, R. Access VBA: výukový průvodce. Brno: Computer Press, 2012. ISBN 978-80-251-3686-7.
-
VESELÁ, J. Relační databáze jako nástroj pro analýzu a prezentaci dat: Microsoft Office Access 2013. Praha: Vysoká škola manažerské informatiky, ekonomiky a práva, 2014. ISBN 978-80-86847-73-3.
|