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

Gurantor departmentDepartment of Applied InformaticsCredits2
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year3Semestersummer
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

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

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation Credit 85 (85) 0 3
        Project Project 85  0 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2007/2008 (N6209) Systems Engineering and Informatics (1802T001) Applied Informatics P Czech Ostrava 1 Choice-compulsory study plan
2007/2008 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Choice-compulsory study plan
2007/2008 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 1 Choice-compulsory study plan
2006/2007 (M6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 3 Choice-compulsory study plan
2006/2007 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Choice-compulsory study plan
2006/2007 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 1 Choice-compulsory study plan
2005/2006 (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

Assessment of instruction

Předmět neobsahuje žádné hodnocení.