|
Lecturer(s)
|
-
Kubát David, Ing. Ph.D., Ing.Paed.IGIP
|
|
Course content
|
Lectures: 1. MS Access: Basic Objects, Tables, Sessions, Reference Integrity. 2. Session types, database administration and analysis, import and data connection. 3. Types of queries and their creation. 4. Forms and their use. 5. Use and create reports. 6. Visual Basic for Applications - macros, modules. 7. MS Access: communications, Internet. Seminars: 1. MS Access: Database. Session. 2. MS Access: Tables. 3. MS Access: Questions - Part 1. 4. MS Access: Questions - Part 2. 5. MS Access: Forms - Part 1. 6. MS Access: Forms - Part 2; assignment of a semester project. 7. MS Acess Sets. 8. MS Access: Makra. 9. MS Access: Modules. 10. MS Access: Communication with other systems. 11. MS Access: Access and Internet. 12. MS Access: Tools. 13. MS Access: Module and tool assembly applications. 14. Presentation and defense of the semester project.
|
|
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.
|