|
Lecturer(s)
|
-
Kubát David, Ing. Ph.D., Ing.Paed.IGIP
-
Nejedlová Dana, Ing. Ph.D.
|
|
Course content
|
Lectures: 1. MS Access: Basic objects, tables, relations, referential integrity 2. MS Access: Relation N:N, management and analysis of database, import and tables linking 3. MS Access: Questions 4. MS Access: Forms 5. MS Access: Reports 6. MS Access: Macros, modules 7. MS Access: Internet 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
|
Monological explanation (lecture, presentation,briefing), Dialogue metods(conversation,discussion,brainstorming), Self-study (text study, reading, problematic tasks, practical tasks, experiments, research, written assignments), Written assignment presentation and defence
- Class attendance
- 42 hours per semester
|
|
Learning outcomes
|
After completing this course students will be able to: creating objects like tables and relations, queries, forms and subforms, graps, reports, macros and modules. Essentials of Visual Basic. Integration MS Access with others programs. Outputs to Iternet and Intranet.
Students obtain knowledge in given course in accordance with requirements and course programme. After completing this course students will be able to: creating objects like tables and relations, queries, forms and subforms, graps, reports, macros and modules. Essentials of Visual Basic. for Applications.
|
|
Prerequisites
|
Basic PC ability.
|
|
Assessment methods and criteria
|
Oral exam, Written exam, Student's performance analysis, Practical demonstration of acquired skills
Condition of credit: two successful examinations (each minimum 70%), 80% attendance on seminars. Condition of exam: make and tenable of project.
|
|
Recommended literature
|
-
Kruczek Aleš. Microsoft Office Access 2007. Computer Press, 2007.
|