1. Introduction to the subject content, credit system claims. Object oriented database MS-Access. Object types, their use, data types, system possibilities and limits.
2. Data analysis, table schema, indexes and relationships. E-R model use for database desing.
3. Selection queries, query creating, virtual fields, data aggregation. SQL language use.
4. SQL language ANSI norm.
5. Creating of forms for data input. Control types, their use.
6. Creating of forms with subforms. Object manipulation methods.
7. Creating of reports, data grouping and aggregation.
8. System control (macros and modules, toolbars, menu bars)
9. VBA language, constants and values declaration, MS-Access object library.
10. Database security system, encrypting, workgroups, users and groups, permissions. Data replication, creating and synchronization.
11. Internet, web, hypertext design.
12. Server application, ASP technology and object model. ASP.NET technology.
13. Database connection, ODBC, ADO system.
14. Modern information systems design methods.
2. Data analysis, table schema, indexes and relationships. E-R model use for database desing.
3. Selection queries, query creating, virtual fields, data aggregation. SQL language use.
4. SQL language ANSI norm.
5. Creating of forms for data input. Control types, their use.
6. Creating of forms with subforms. Object manipulation methods.
7. Creating of reports, data grouping and aggregation.
8. System control (macros and modules, toolbars, menu bars)
9. VBA language, constants and values declaration, MS-Access object library.
10. Database security system, encrypting, workgroups, users and groups, permissions. Data replication, creating and synchronization.
11. Internet, web, hypertext design.
12. Server application, ASP technology and object model. ASP.NET technology.
13. Database connection, ODBC, ADO system.
14. Modern information systems design methods.