Description
This course will allow you to fully master the features and capabilities of Visual Basic. All essential aspects of the language will be covered, including object programming, interaction with databases and Active X Data Objects. At the end of this course, you will be able to create professional applications.
Who is this training for ?
For whom ?Developers, application designers. Participants wishing to approach VBA for the development of applications linked to the Office Pack must go to another course.
Prerequisites
Training objectives
Training program
- Positioning Visual Basic (vb, vba, vbscript)
- Building user interfaces.
- Accessing databases.
- Using and creating components.
- Developing Internet/Intranet.
- Improve application design with object programming
- Classes and objects.
- Graphical objects: shapes, controls.
- Properties, methods, events.
- Event-driven programming.
- The Visual Basic development platform
- Recurring principles.
- Windows, menu bar, toolbar.
- Online help and supplements.
- The code editor.
- Steps in creating an application.
- The different types of files.
- Practical work Getting started with the interface, recording and compilation.
- Visual Basic, le langage
- Variables.
- Data types and conversions.
- Scope and lifetime of variables.
- Tables and user data types .
- Constants.
- Object variables.
- Naming conventions.
- Event and general procedures.
- Scope of procedures: standard modules.
- Passing arguments.
- Visual Basic functions.
- Operators.
- Control structures.
- Practical work rnCreation of procedures, passing arguments.
- Creation of 'a date checking function.'}
- Windows, menus and dialog boxes
- Principle of MDI (Multiple Document Interface), shapes and controls.
- Modal shapes.
- Predefined shapes.
- Loading and display.
- Main events, methods and properties.
- Menus, popup menus.
- The msgbox and inputbox functions.
- Practical work Creation of shapes and a presentation menu.
- Management of shapes loading and unloading events.
- Graphical components (controls)
- Standard controls, Active X controls.
- Input and display: label, text box, masked edit.
- Buttons: command, check box, option.
- Lists: list box, combo box.
- Presentation: Tool Bar, Status Bar, Image List, Scroll Bar, Progress Bar.
- Dialog boxes standard: common dialog.
- The timer: timer.
- The Drag and Drop.
- Source object and target object.
- Events mouse.
- Source properties.
- Events on the target.
- Practical work Management of an input form, validity checks.
- Manipulating lists.
- Launching procedures.
- Moving a control on a shape.
- Moving an element from one list to another list.
- Error handling
- Handling logical errors: debugging.
- Breakpoints.
- Spy expressions.
- Debugging windows.
- Step mode and procedures.
- Handling runtime errors.
- Catching and error handlers.
- The Err object.
- Practical work Intercepting an execution error.
- Getting started with the debugger.
- Access to data
- File handling.
- Sequential, direct, binary access.
- Opening, closing.
- Read/write instructions.
- Relational database architecture and objects.
- The SQL language.
- The Data Environment.
- The client-server architecture.
- Access providers: ODBC and OLE-DB.
- Data access objects: ADO (Active X data access).
- Tools 'data access.
- Data Environment.
- Data Control.
- Data Report.
- Data Form Designer.
- Data-dependent controls.
- Data Grid, Hierarchical Flex Grid.
- Data List, Data Combo.
- Practical work Creation and manipulation of a file in sequential access (records of variable size).
- Using data access controls.
- Final touch
- Resource files.
- Saving application settings.
- Generate an executable and distribute it.
- Program optimization .
- Practical work Creation and use of a resource file.
- Using the registry to maintain dynamic parameters.
- Deployment of an application.
