|
Lecturer(s)
|
|
|
|
Course content
|
Working in PowerPoint presentations. Basic database terms. Fundamentals of Microsoft Access. Creating a database. Creating tables. Relations between tables, reference integrity. Working with data, sorting and filtering data, expressions. Creation of queries. Creating forms. Creation of print sets. Data web sites. Macros.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Demonstration, Projection, Skills training
|
|
Learning outcomes
|
The main goal of discipline is to familiarise students with the presentation software MS Power Point and with the database software MS Access, including the necessary theoretical background. Students should prove their knowledge passing the final test and successfully presenting their seminary work (defining and creating a database in MS Access without help of the Access Wizard tool). The MS Power Point will be used for presentation of the seminary work.
The student controls the majority of the database functionality of Microsoft Access upon the completion of the course. They can define and solve their own routine work in Microsoft Access. The student also uses all common functions of the presentation program of Microsoft PowerPoint.
|
|
Prerequisites
|
The basic knowledge of Microsoft Windows operating system and Microsoft Word and Excel.
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation
The condition for granting a credit is active work during the seminars, passing two computer tests and the submission of seminary work. For more information see the document, which is available for download in IS STAG.
|
|
Recommended literature
|
-
Kruczek, Aleš. Microsoft Office Access 2007 : podrobná uživatelská příručka. Brno: Computer Press, 2007. ISBN 978-80-251-1608-1.
-
Lambert S., Lambert III M. D. and Preppernau J. Microsoft? Office Access? 2007 Step by Step. Computer Press, 2007. ISBN 978-0735623033.
-
Oppel, A. Databases Demystified. McGraw-Hill Osborne Media, 2004. ISBN 10- 00722-5364-1.
-
Oppel, Andrew J. Databáze bez předchozích znalostí : [průvodce pro samouky]. Brno: Computer Press, 2006. ISBN 80-251-1199-7.
|