COURSE SEARCH

HOME > COURSES > MICROSOFT VISUAL FOXPRO 6 INTRODUCTION

MEMBERS LOGIN

UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW

HOME

COURSE LIBRARY

QUESTIONS & ANSWERS

There are many excellent online courses. This has been hugely beneficial in my day to day work.

- Louise Nolan

MORE INFO

Microsoft Visual FoxPro 6 Introduction

Course Aims
The course is designed to introduce readers to the interactive and programming language of MS Visual FoxPro. The course readers will cover: how to use the interactive features of Visual FoxPro; understand the class and object structure of Visual FoxPro; be able to build a data dictionary with validation and security; design data input forms; create and use new classes; create and use new objects.

Assumed Knowledge
Readers from a FoxPro background should have several months experience of using FoxPro to search databases, to add and delete information and to crate reports. Readers from other backgrounds should have a year's experience of another visual development tool.

Course Audience
Existing FoxPro users for DOS, Windows, Macintosh or Unix who wish to move to using the Object-Oriented approach of MS Visual FoxPro. Users of other MS Visual tools who wish to use FoxPro for the database aspects of their work.

This course can be found in the following categories:

Courses > Databases > Foxpro
Courses > Microsoft > Visual Foxpro

Table of Contents

Course Content

Course Content

New Features

New Features in Visual FoxPro

New Features in Visual FoxPro 5.00

New Features in Visual FoxPro 6.00

Look at Data

Opening a Table

Memo Fields

Resize Fields

Rearrange Fields

Keyboard Short-Cuts

Two Views of a Single Database

Search

Move Through the Database

Locate

Using the Command Language

Using SEEK

Expression Builder

Functions

Fields

Table

Variables

Command Buttons

Add Data

Adding a New Record

Memo Fields

Saving Data

Using the Command Language

Modify Data

Change a Single Record

Change Many Records

Using the Command Language

Delete

Display Deleted Records

Delete a Record

Recover a Record

Using the Command Language

Queries

Select The Information That You Want

Query Designer

Query Wizards

Using the Command Language

FoxPro and dBase

Running SQL

Using SQL

Views

Creating a View

Update Criteria

Multiple Users

Reports

Producing a New Report

Report Designer

Quick Report

Modify the Quick Report

Moving Fields

Resizing Fields

Proportional Fonts

Field Names

Bitmaps

Circles

Ordering Data within Reports

Grouping Data within Reports

Hidden Objects

Multiple Groups

Sub-Totals and Summaries

Create a Report Variable

Types of Summary

Import / Export

Introduction

ODBC

Other Programs

Exporting Data

Save as HTML (Version 6.00)

Importing Data

Appending Data

Open Database Connectivity

Connections

Miscellaneous

Customising FoxPro

Permanent Changes

Command Window vs Menu System

Data Directory

New Data Types

Null Values

Creating a Database

Free Table

Database Table

Relate Tables

Window Layout

Collapsed Tables

Types of Index Key

Referential Integrity

Types of Referential Integrity

Editing Referential Integrity

Field-Level Validation

Validation Message

Delete, Insert, and Update Triggers

Using Triggers

Validation at Data Dictionary Level

Data Buffering

Buffering

Transactions

Programming

Constants

Problems with Constants

Variables

Assigning Values to Variables

Variable Types

Arrays

Defining an Array

Two Dimensional Arrays

Table Data in an Array

Scope of Variables and Arrays

Viewing Memory Variables

DISPLAY MEMORY

Releasing Variables

Program Control

Indentation

Comments

IF .. ELSE .. ENDIF

DO CASE

FOR loop

DO WHILE loop

SCAN loop

FOR EACH ... ENDFOR

Functions and Procedures

Functions

Procedures

Location

Using Procedures and Functions

Defensive Programming

Asserts

Object Oriented Concepts

Classes and Objects

Terminology

Properties, Events, & Methods

Properties

Events

Methods

User Methods

Inheritance, Encapsulation, and Polymorphism

Base Classes

Forms

Data Environment

Form and Control Properties

Version 5 Menu

Methods and Properties

Editing Methods and Properties

Converting from DOS and Windows

Controls

Container Objects

Adding Controls to a Container

Moving Controls in a Container

Editing in a Container Object

Grid Control

Editing a Grid Control

Timer Control

Container Controls Used by Wizards

Menu Builder

Designing a Menu

Leaving a Custom Menu

Quick Menu

Adding a New Entry

Actions Available from a Menu

Inhibiting Menu Selections

Changing an Existing Submenu

Run a Menu

Short-Cut Menu (V5.00)

Project Manager

Create a Project

Project Information

Project Manager Window

Tear-off Tabs

Add Component

Create New Component

Show or Hide Components

Building an Application

Object Programming

Change Properties in Program Code

Absolute Reference

Relative Reference

WITH clause

Object List

Run Methods from Program Code

Override Default Methods

Names of Objects

Using Classes

Types of Classes

Visual Classes

Non-Visual Classes

Create a Class Library

Use a Class Library

Modifying a New Class

Using Classes

Classes in Program Code

Class Browser

Objects in Program Code

Protected Methods and Properties

Protected Properties

Protected Methods

Hidden Methods

Toolbars

Foundation Classes (v6.00)

Component Gallery

Examples

Using the Application Framework

Appendix A Standards and Conventions

Names

General Guidance

Variable Names

Field Names

Object Names

Comments

Program Code

Skeleton for Procedural Code

Appendix B Further Reference

Books

On line

User Group

TRY BEFORE YOU BUY

BECOME A RESELLER

TERMS & PRIVACY

Monday 21st May 2012