155-0338/01 – Programming in Database Environment (PRGDB)

Gurantor departmentDepartment of Applied InformaticsCredits3
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Study languageCzech
Year of introduction2002/2003Year of cancellation2008/2009
Intended for the facultiesEKFIntended for study typesMaster
Instruction secured by
LoginNameTuitorTeacher giving lectures
NOV21 Ing. Vítězslav Novák, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 1+2

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


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


Other requirements


Subject has no prerequisities.


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

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation Credit 85 (85) 0
        Project Project 85  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2004/2005 (M6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 3 Choice-compulsory study plan
2004/2005 (M6209) Systems Engineering and Informatics (6201T004) Economics P Czech Ostrava 3 Choice-compulsory study plan
2003/2004 (M6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 3 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner