Visual Basic & Access

Go Back

This course highlights the various features of Microsoft Access and Microsoft Visual Basic to create an appreciation for the types of applications that can be developed. By the end of the course, you will be able to use your Access and Visual Basic knowledge to build client/server database applications.

The Microsoft Access portion of the course will cover the following:

Introduction to Access

• Introduction of database concepts
• He fundamentals of database design
• The Access environment

Creating Relational Databases

• Accessing your clients’ needs
• Building the Access database
• Adding data

Using Queries

• Query types
• Query by Example and Form
• Using Query Wizards
• Using Query Wizards with SQL
• Linking to and querying a SQL Server database

Using Reports

• Using Reports Wizards
• Creating useful and effective reports

Application development with macros

• Designing effective macros
• Creating buttons to run macros

The Visual Basic portion of the course will cover the following:

Introduction to Visual Basic

• The VB environment
• What is an application?
• Opening, closing and saving projects and forms

Building the Application

• Adding controls and other display objects
• Manipulating control and object properties
• Writing event procedures
• Compiling and running the project

Data Types and Procedures

• A look at different data types, variables and constants
• Adding conditions, loops and comments
• Creating subroutines

Other VB goodies

• Creating menus and dialog boxes
• Using the debugging tools
• Using timers, graphs, cursors and icons

SURELINK COMPUTER ACADEMY

We are your Key to Academic Excellence

Created on April 20, 2000
Last Updated on June 19, 2000