|
Lecturer(s)
|
-
Kubát David, Ing. Ph.D., Ing.Paed.IGIP
|
|
Course content
|
Excersises: 1. MS Access: Database, relations. 2. MS Access: Tables. 3. MS Access: Question - part one. 4. MS Access: Question - part two. 5. MS Access: Forms - part one. 6. MS Access: Forms - part two. 7. Examination no. 1., MS Access: Reports - part one. 8. MS Access: reports - part two. MS Access: Macros. 9. MS Access: Modules. 10. MS Access: Communation with other systems. 11. MS Access: Internet. 12. MS Access: Tools. 13. Examination no. 2. 14. Work on project.
|
|
Learning activities and teaching methods
|
Self-study (text study, reading, problematic tasks, practical tasks, experiments, research, written assignments), Demonstration, Motoric and practical working skills training
- Class attendance
- 28 hours per semester
|
|
Learning outcomes
|
The aim of this module is to understand of the database systems MS Access 97 for the enterprise applications, relations between tables, quaries, forms and reports. Students will learn basic parts of Visual Basic.
Students obtain knowledge in given course in accordance with requirements and course programme. Students will understand database systems MS Access 97 for the enterprise applications, relations between tables, quaries, forms and reports. Students will learn basic parts of Visual Basic for Applications.
|
|
Prerequisites
|
Basic PC ability.
|
|
Assessment methods and criteria
|
Oral exam, Written exam, Student's performance analysis
Condition of credit: successful examination (minimum 70%), 80% attendance on seminars, semestral work.
|
|
Recommended literature
|
-
Microsoft - Microsoft Office Access 2003. Microsoft, 2003. ISBN 9780735615175.
-
MS Access - příručka uživatele, nápověda k programu.
-
MS Windows - příručka uživatele, nápověda k programu.
-
Kruczek Aleš. Microsoft Office Access 2007. Computer Press, 2007.
|