155-0327/01 – Windows Database Applications (ADPW)

Gurantor department	Department of Applied Informatics	Credits	2
Subject guarantor	doc. Ing. Ludmila Kalužová, CSc.	Subject version guarantor	doc. Ing. Ludmila Kalužová, CSc.
Study level	undergraduate or graduate	Requirement	Choice-compulsory
Year	3	Semester	summer
		Study language	Czech
Year of introduction	2004/2005	Year of cancellation	2009/2010
Intended for the faculties	EKF	Intended for study types	Bachelor

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
KAL70	doc. Ing. Ludmila Kalužová, CSc.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Credit	0+2

Subject aims expressed by acquired skills and competences

- To apply relational structure in database system Access. - To create the simple queries, the summarizing queries. - To use queries for updating data and creating new tables. - To design forms and reports in Access. - To apply calculated fields in forms and reports. - To create a simple economic application in Access.

Teaching methods

Summary

Předmět rozšiřuje znalosti základů Accessu v návaznosti na předmět Informatika s cílem zvládnutí tohoto databázového systému na takové uživatelské úrovní, aby studenti byli schopni vytvořit komplexní jednoduchou ekonomickou aplikaci. Rozvíjí znalosti tvorby datové základny v Accessu včetně zajištění integrity dat. Prezentuje tvorbu jednoduchých i souhrnných dotazů, využití dotazů pro aktualizaci dat a vytváření nových tabulek. Dále zahrnuje problematiku navrhování formulářů pomocí průvodce, ale i možnosti vlastních úprav vlastností formuláře, vkládání vypočtených polí a návrh formulářů s více tabulkami. Pro vytvoření komplexní jednoduché ekonomické aplikace je rovněž prezentován návrh výstupních sestav, vkládání vypočtených polí do sestav a definování skupin záznamů.

Compulsory literature:

1.Kaluža,J.,Kalužová,L.,Maňasová,Š.: Informatika, VŠB TU Ostrava 2001,ISBN 80- 7078-394-X 2.Písek, S.: Access 2002, podrobný průvodce začínajícího uživatele, Grada Praha 2002, ISBN 80-247-0439-0 3.Písek, S.: Access 20003, snadno a rychle,Grada Praha 2004, ISBN 80-247-0787- X 4.Feddema, H.: Mistrovství v Microsoft Access 2002, Computer Press, Praha 2002, ISBN 80-7226-725-6

Recommended literature:

Additional study materials

Study supports in the EduDocs system

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

bude doplněno později ...

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

bude doplněno později ...

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. 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 year	Programme	Branch/spec.	Spec.	Form	Study language	Tut. centre	Year	Type of duty
2009/2010	(B6208) Economics and Management	(6208R020) Business Economics	(00) Business Economics	P	Czech	Ostrava	3	Choice-compulsory	study plan
2009/2010	(B6208) Economics and Management	(6208R020) Business Economics	(01) Business Economics	P	Czech	Valašské Meziříčí	3	Choice-compulsory	study plan
2009/2010	(B6208) Economics and Management	(6208R011) Economics and Law in Business		P	Czech	Ostrava	3	Choice-compulsory	study plan
2008/2009	(B6208) Economics and Management	(6208R020) Business Economics	(00) Business Economics	P	Czech	Ostrava	3	Choice-compulsory	study plan
2008/2009	(B6208) Economics and Management	(6208R020) Business Economics	(01) Business Economics	P	Czech	Valašské Meziříčí	3	Choice-compulsory	study plan
2007/2008	(B6208) Economics and Management	(6208R020) Business Economics	(00) Business Economics	P	Czech	Ostrava	3	Choice-compulsory	study plan
2007/2008	(B6208) Economics and Management	(6208R020) Business Economics	(01) Business Economics	P	Czech	Valašské Meziříčí	3	Choice-compulsory	study plan
2006/2007	(B6207) Quantitative Methods in Economics	(6207R015) Managerial and Decision Making Methods in Economics		P	Czech	Ostrava	2	Optional	study plan
2006/2007	(B6208) Economics and Management	(6208R020) Business Economics	(00) Business Economics	P	Czech	Ostrava	3	Choice-compulsory	study plan
2005/2006	(B6207) Quantitative Methods in Economics	(6207R015) Managerial and Decision Making Methods in Economics		P	Czech	Ostrava	2	Choice-compulsory	study plan
2005/2006	(B6208) Economics and Management	(6208R020) Business Economics	(00) Business Economics	P	Czech	Ostrava	3	Choice-compulsory	study plan
2005/2006	(B6208) Economics and Management	(6208R020) Business Economics	(02) Business Economics	P	Czech	Valašské Meziříčí	3	Choice-compulsory	study plan
2005/2006	(B6208) Economics and Management	(6208R020) Business Economics	(05) Business Economics	P	Czech	Ostrava	3	Choice-compulsory	study plan
2004/2005	(B6208) Economics and Management	(6208R020) Business Economics	(02) Business Economics	P	Czech	Ostrava	3	Choice-compulsory	study plan

Occurrence in special blocks

Block name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

2009/2010 Summer