Lecturer(s)
|
-
Kubát David, Ing. Ph.D., Ing.Paed.IGIP
-
Nejedlová Dana, Ing. Ph.D.
|
Course content
|
Lectures (topics): 1. MS Access: basic objects, tables, relations, referential integrity. 2. MS Access: relation N: N, database management and analysis, import and link sources. 3. MS Access: queries. 4. MS Access: forms. 5. MS Access: reports. 6. MS Access: macros, modules. 7. MS Access: communication, Internet. Seminars (topics): 1. MS Access: databases, relations. 2. MS Access: tables. 3. MS Access: queries. 4. MS Access: forms. 5. Test 6. MS Access: reports, macros. 7. MS Access: modules. 8. MS Access: communication with other systems. 9. MS Access: access and Internet. 10. MS Access: tools. 11. Project. 12. Test
|
Learning activities and teaching methods
|
unspecified
|
Learning outcomes
|
The aim of the subject is to introduce students to the database system MS Access and its applications in corporate management - databases, relations, referential integrity, tables, queries, forms, sub forms, graphs, macros, modules, compatibility with other programmes, outputs to the Internet and Intranet, and Visual Basic language.
|
Prerequisites
|
unspecified
|
Assessment methods and criteria
|
unspecified
|
Recommended literature
|
|