Applied informatics

The course introduces the operation of modern databases and ways of collecting information.

The student learns how to design relational databases and how to implement the designed database in a database program.

The student also learns how to search for information in databases.

Exercises:

1) Introduction to databases. Relational database model.

2) Database design - tables, queries, forms and reports.

3) Searching and filtering information in an existing database.

4) Designing an example database.

5) Implementation of the project database in MS Access.

6) Creating a graphical interface for database support. Creating simple reports.

1) K. Bluttman, W. S. Freeze: Access Data Analysis Cookbook (ebook), O'Reilly Media, 2007

2) A. Michael, R. Kusleika: Access 2019 Bible, Wiley, 2019

3) P. McFedries: Microsoft Office Access 2007 Forms, Reports, and Queries (Business Solutions), O'Reilly Media, 2007

the graduate knows and understands:

Student has knowledge of the constructure and operation of relational databases.

the graduate is able to:

Student is able to use available databases to search and select the information needed.

Student is able to design a simple database based on a relational database model as well as implement the project in a specific solution by creating the necessary queries, forms and reports.

the graduate is ready to:

Participant is aware of the importance of programming skills and database using in self-improvement and self-education.

Practical skill test (grade on a 2-5 scale) -100%