Software for Managers 2

Lecturer:

Tutor:

Supervisor:

Department of Economics, Management and Humanities

Synopsis:

Use of relational database management system ACCESS: basic database operations, relations, data import and export, basics of SQL, reports building, basics of programming in FoxPro, basics of user applications building.

Requirements:

Syllabus of lectures:

Syllabus of tutorials:

1. Database system (ACCESS) - introduction

2. Introduction to work with databases

3. Sorting, indexes and filters

4. Simple outputs and calculations

5. Relations setting

6. Reports

7. Queries (SQL) - introduction

8. SQL - continuing

9. Data import and export

10. Basics of programming

11. Application building - introduction

12. User menus

13. User dialogs - introduction

14. User dialogs - continuing

Study Objective:

Study materials:

[1] Program documentation

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans:

• Ekonomika a řízení elektrotechniky a energetiky-inženýrský blok (compulsory course)
• Ekonomika a řízení elektrotechniky a energetiky-inženýrský blok (compulsory course)