PROGRAMMING IN A PC-ENVIRONMENT
 
Lectured in 2de jaar Toegepaste informatica
Theory [A] 25.0
Exercises [B] 12.5
Training and projects [C] 0.0
Studytime [D] 100
Studypoints [E] 4
Lecturer Karine SAMYN
Co-lecturers  
Reference EGTOIN02A00172
 
Key words
Programming in a PC-environment

Objectives
Students have to be able to realize fully database-driven applications with several screens, menus and error handling.

Prerequisites
Knowledge of SQL is necessary.

Topics
  • IDE environment
    Summary of the series of products in VB. How to work with the development environment. What are properties, events and methods.

  • Forms and Controls
    A summary is given of forms and the intrinsic controls, the basic components of every program you make in Visual Basic. Also, it is stated how to make your VB programs interactive. You see how to make your programs react on different actions of the user.

  • Programming in Visual Basic
    Summary of programming instructions, structures and variables in the Visual Basic programming language. Working with files.

  • Project management
    Working with several forms. Activex components and object libraries. Design of a multiple document interface. Making of an executable file and a setup program.

  • Error handling and debugging
    How can errors in a program be traced and corrected? How can it be avoided that a program encounters unexpected errors during the execution, so that it has to be ended?

  • Menus
    The making of a menu, tool bars with frequently used programming functions and context menus.

  • Working with databases via ADO
    Here, the basics of client/server applications are dealt with. ADO is Microsoft’s most recent contribution concerning data access. In the first part, you learn how to make database-driven programs in a simple way with the use of ODBC and the controls ADO Data Control, DataGrid and DataList. In the second part, you make use of the ADO object interface. Those are objects which you can use to manipulate data directly from the code. The object interface is more powerful and flexible.


Teaching Methods
Lectures with Powerpoint presentations and demos.

Materials used
  • slides, available on Blackboard
  • optional book: “Het complete handboek Visual Basic 5, Brian Siler & Jeff Spots, Academic Service, price € 40 up to € 50
  • additional optional literature:
    VB6 Interactive course, Spenik & Indovina & Boutquin & Jung, SAMS (1130 pages)
    Visual Basic Programmer’s Guide, MICROSOFT (898 pages)
    Visual Basic Component Tools, MICROSOFT (796 pages)
    VB6 Databases, WROX (881 pages)


Study guidance
The student must give demos of his exercises periodically and has to explain the code.

Assessment
The theoretical examination covers 1 semester and is written.

Permanent evaluation: During the classes, a few graded exercises are given. The marking of those exercises happens during class, except for the last exercise. All exercises with source code are handed in in one file.

Second semester 100%, of which 50% goes to the written exam and 50% to the permanent evaluation.

Study costs
The costs are equal to the number of photocopies of the course and can be estimated at a cost below € 12.50 at the official unit price of € 0.030 / sheet.

Lecturer(s)


Language
Dutch