155-0338/02 – Programming in Database Environment (PRGDB)
Gurantor department | Department of Applied Informatics | Credits | 2 |
Subject guarantor | Ing. Vítězslav Novák, Ph.D. | Subject version guarantor | Ing. Vítězslav Novák, Ph.D. |
Study level | undergraduate or graduate | Requirement | Choice-compulsory |
Year | 1 | Semester | |
| | Study language | Czech |
Year of introduction | 2002/2003 | Year of cancellation | 2008/2009 |
Intended for the faculties | EKF | Intended for study types | Master |
Subject aims expressed by acquired skills and competences
Understand the fundamental principles of the relational databases.
Use commands SELECT, INSERT, UPDATE and DELETE of language SQL.
Create database applications in Microsoft Office Access.
Use the programming language Visual Basic for Application on a simple level.
Teaching methods
Summary
The purpose of this subject is programing economic apllications in relational
database Microsoft Access with use programming language Microsoft Visual Basic
for Application.
Compulsory literature:
Riordan R. M.: Vytváříme relační databázové aplikace
Barker, F. S.: Microsoft Access 2002 - programování databázových aplikací
Dobson, R.: Programování v Microsoft Access 2000
McFedries, P.: VBA MS Office 2000
Roman, S.: MS Access – návrh a programování databází
Scott, D. F.: Velká kniha programování v Microsoft Office 2000
Jerke, N.: Microsoft Office Access 2003 pro pokročilé
Groff, J. R., Weinberg, P. N.: SQL - kompletní průvodce
Recommended literature:
Way of continuous check of knowledge in the course of semester
E-learning
Other requirements
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1) Základy programovacího jazyka Visual Basic for Application
2) Základy jazyka SQL, část DML (Data Manipulation Language)
3) Microsoft Access Objects
4) Microsoft ActiveX Data Objects
5) Spolupráce aplikací v rámci MS Office
6) Tvorba víceuživatelské aplikace
7) Zabezpečení databázové aplikace
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.