MS Access 2010

Lecturer:

Vladimír Hlaváč (gar.), František Král

Tutor:

Vladimír Hlaváč (gar.), František Král

Synopsis:

A database relation to the real world. Data types, integrity constraints. The table, relation of the data. Queries, reports, forms. MS Access 2010 - environment, control, help. Working with guides, system design, data entry. OLE 2. Visual Basic. SQL Query - types of commands; insert into tables using SQL. Part of the task is one of the typical applications for MS Access, for example: library, car rental agency, training organization agency, or booking tickets.

Requirements:

Syllabus of lectures:

a pilot run - will be specified later

Syllabus of tutorials:

Study Objective:

Study materials:

Note:

Time-table for winter semester 2011/2012:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Fri	roomT4:A1-404 Hlaváč V. 17:45–19:15 (parallel nr.1) Dejvice Poc.ucebna 404
Thu
Fri

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: