top of page
Ph.D. Miroljub Zahorjanski
Professor of vocational studies
I create presentations, database models and websites
BPwin - functional modeling
ERwin - information modeling
MS Access - application modeling
Programming languages: VBA and C#
SQL - query language
Web Programming and Web design
Electronic distance learning
Course content
BPwin - functional modeling IDEF0 standard
- Creating a context diagram
- Decomposition of the main activity by levels
- Activity tree
- Improvement of the business model graphically
textual documentation
MS Access - application modeling
- Work with tables
- Creation of forms for data entry, features and
events
-Defining queries over data
- Creating reports
- Automating objects by coding events
- Creation of menus and control panels
Electronic distance learning
Preparatory courses for distance learning, professional studies
Web Programming
- Basics of HTML
- Creation of static web pages
- Development of dynamic web applications
- Creation of professional web portals
ERwin - information modeling IDEF1X standard
- Entity creation
- Adding attributes and primary keys
- Connecting entities
-Database schema generation
VBA - programming language
- Working with variables
-Functions and procedures
- Control structures
-Associating VBA code with objects
C# - programming language
- Simple forms
- Console applications
- Complex forms
- Working with databases
SQL - Query Language
- Queries over one table
- Using operators
- Queries over multiple tables
-Functions for aggregation
- Creating tables from queries
Providing help from: BPwin, ERwin, MS Access, E-learning, VBA, SQL, Visual C#, ASP.NET
bottom of page