Outline of lectures
1) Basic terms and definitions of the informatics
2) Numeral systems, their conversions and coding
3) Basic components and classification of the computers
4) Classification of software
5) Database systems
6) SQL and its application of database management
7) Specification of enterprise informatics and its life cycle
8) Infrastructural enterprise applications
9) Enterprise resource planning
10) Applications of the external relationships management
11) Applications of the business intelligence in enterprise informatics
12) Management of the enterprise informatics
13) Effectiveness of the information systems
14) Safety of the information systems and of the communication technologies
Outline of exercises
1) Conception of the database structure in MS ACCESS
2) Design of the tables, data types and formats
3) Design of the relational database in MS ACCESS
4) Design of the concrete databases according to instructions
5) Retrieval, sorting and filter of the data
6) Conception of the queries
a. Selective queries
b. Selective queries with making calculations in the query
c. Action queries
i. Updating queries
ii. Deleting queries
iii. Creating queries
iv. Appending queries
d. Parametric queries
e. Cross queries
7) Design of the forms in MS ACCESS
8) Design of the reports in MS ACCESS
1) Basic terms and definitions of the informatics
2) Numeral systems, their conversions and coding
3) Basic components and classification of the computers
4) Classification of software
5) Database systems
6) SQL and its application of database management
7) Specification of enterprise informatics and its life cycle
8) Infrastructural enterprise applications
9) Enterprise resource planning
10) Applications of the external relationships management
11) Applications of the business intelligence in enterprise informatics
12) Management of the enterprise informatics
13) Effectiveness of the information systems
14) Safety of the information systems and of the communication technologies
Outline of exercises
1) Conception of the database structure in MS ACCESS
2) Design of the tables, data types and formats
3) Design of the relational database in MS ACCESS
4) Design of the concrete databases according to instructions
5) Retrieval, sorting and filter of the data
6) Conception of the queries
a. Selective queries
b. Selective queries with making calculations in the query
c. Action queries
i. Updating queries
ii. Deleting queries
iii. Creating queries
iv. Appending queries
d. Parametric queries
e. Cross queries
7) Design of the forms in MS ACCESS
8) Design of the reports in MS ACCESS