Course: Database and Presentation Systems

» List of faculties » DFJ » KID
Course title Database and Presentation Systems
Course code KID/PDPSP
Organizational form of instruction Lecture + Tutorial
Level of course Bachelor
Year of study not specified
Semester Summer
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Rejsek Ondřej, Ing.
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
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.
  • Oppel, Andrew J. Databáze bez předchozích znalostí : [průvodce pro samouky]. Brno: Computer Press, 2006. ISBN 80-251-1199-7.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Transport Engineering Study plan (Version): Electrical Engineering and Electronic Systems in Transport (2014) Category: Transportation and communications 2 Recommended year of study:2, Recommended semester: Summer
Faculty: Faculty of Transport Engineering Study plan (Version): Electrical Engineering and Electronic Systems in Transport (2013) Category: Transportation and communications 2 Recommended year of study:2, Recommended semester: Summer