CD-ROM 1

Navigating Visual FoxPro’s Interface

1.1 Interface Overview

1.2 Using Visual FoxPro’s Menu System

1.3 Using Toolbars

1.4 Using the Command Window

1.5 Using Shortcut Menus

1.6 Using Properties Windows

1.7 Using Help

Configuring Visual FoxPro

2.1 The Options Dialog Box

2.2 Review of Tabs

Visual FoxPro Databases

3.1 Understanding Database Terminology

3.2 Steps to Database Design

3.3 The Database Wizard

3.4 The Visual FoxPro Database Designer

CD-ROM 2

Creating Visual FoxProTables

4.1 Working with Tables

4.2 Modifying Table Structures with the Table Designer

4.3 Creating Persistent Relationships

Creating Views in the Database

5.1 What Is a View?

5.2 The View Designer

5.3 Viewing SQL Code

5.4 Creating Parameterized Views

5.5 Queries vs. Views in Visual FoxPro

CD-ROM 3

The Visual FoxPro Project Manager

6.1 The Project Manager

Working with Visual FoxPro Forms

7.1 Designing Forms with the Form Designer

7.2 Adding Controls to Your Forms
7.3 Specifying the Data Environment

7.4 DataSessions

7.5 Understanding PEM programming

7.6 Building an Actual Form

Creating Reports in Visual FoxPro

8.1 Creating Reports with the Report Designer

Appendix: Using the One-to-Many Report Wizard

Appendix: Modifying Reports with the Report Designer

CD-ROM 4

The Visual FoxPro Language

9.1 Understanding Programming Terminology

9.2 Operators

9.3 Program Flow Constructs

9.4 Dealing with the Year 2000 Problem

Appendix: Table/Data Oriented Commands and Functions

CD-ROM 5

The Visual FoxPro Database Container

10.1 What Is a Data Dictionary?
10.2 Referential Integrity
10.3 DbGetProp() and DbSetProp()
10.4 The GENDBC Program
10.5 Updateable Views
10.6 Top N views
10.7 Outer Joins

Using SQL in Visual FoxPro

11.1 Why Use SQL?
11.2 SQL SELECT
11.3 SQL UPDATE
11.4 SQL DELETE
11.5 SQL CREATE
11.6 SQL INSERT

CD-ROM 6

Multi-User Programming

12.1 What’s the Real Challenge in a Multi-User Environment?

12.2 Implicit vs. Explicit Locking

12.3 Buffering Data

12.4 Data Functions in Visual FoxPro

12.5 Transaction Processing

12.6 Resolving Conflicts

CD-ROM 7

Introduction to Object-Oriented Programming

13.1 A Word About OOP

13.2 Understanding Object-Orientation Terminology

13.3 Analysis and Design in an Object-Oriented World

13.4 Using the Visual FoxPro Tools for Class Design

CD-ROM 8

Advanced Form Design

14.1 Coding Methods in a Reusable Way

14.2 Grids

14.3 Page Frames

14.4 Timers

14.5 OLEBoundControl and OLEControl

CD-ROM 9

The Visual FoxPro Menu Designer

15.1 Creating Menus Using QuickMenu

15.2 Adding Application-Specific Options

15.3 Customizing a Menu

15.4 Shortcut (Right-Click) Menus

Testing and Debugging Visual FoxPro Applications

16.1 The Debugger as a Developer’s Tool

16.2 Testing Scenarios

16.3 Coverage and Profiling Analysis

CD-ROM 10

Programming Standards and Conventions

17.1 Understanding the Costs of Development

17.2 The Value of Conventions

Understanding the Value of Good Database Design

18.1 Characteristics of a True Relational Database

18.2 Data Normalization

Designing User Interfaces

19.1 Interface Design Principles

19.2 User Hostile Interface Design

CD-ROM 11

Accessing Remote Data

0.1 What Is Client/Server Development?

20.2 Configuring ODBC Drivers

20.3 Accessing Remote Data

20.4 Designing Visual FoxPro Client/Server Applications

OLE Drag-and-Drop

21.1 What Is OLE Drag and Drop?

21.2 The Objects Involved

21.3 Examples

Visual FoxPro and the Internet

22.1 Internet Terminology

22.2 What Is HTML?

22.3 Publishing Visual FoxPro Data on the Internet

Appendix: Saving As HTML