In Level 1, you will learn to plan, create, and modify tables, views and databases and create forms. You will use the Application Wizard and Builder to build applications quickly. Create information from your data with queries and reports. Understand the fundamentals of programming including operators, expressions, program flow, branching and looping. Be productive working with code using IntelliSense, QuickInfo, hyperlinks, keyboard shortcuts, Beautify, document view and bookmarks. Manage programming tasks with the Task List Manager.
Visual FoxPro Training Prerequisites
Familiarity with a high-level programming language is recommended.
Visual FoxPro Training Audience
Web designers and administrators.
Visual FoxPro Training Course Duration
2 Days
Visual FoxPro Training Course outline
Working with Data
- Understanding Database Terminology
- The Visual FoxPro Database Designer
- Working with Tables
- Modifying Table Strctures with the Table Designer
- Creating Persistent Relationships
Data Views
- What Is a View?
- Using the View Wizard
- Expanding the Power of Views
- The View Designer
- Viewing SQL Code
- Creating Parameterized Views
- Top N Views
- Queries vs.Views in Visual FoxPro
Reports
- Creating Reports
- Using the Report Wizard
- Using the One-to-Many Report Wizard
- Modifying Reports with the Report Designer
- Creating Reports with the Report Designer
- Printing Reports
Applications
- Introduction to Frameworks
- The Application Wizard
- The Application Builder
- The Project Manager
- Running the Application
Programming
- Understanding Programming Terminology
- Literals, Constants, and Variables
- Operators
- Variable Scoping
- Program Flow Constructs
- The Visual FoxPro Code Editor
- The Task List Manager
Forms
- Using the Form Wizard
- Using the Component
- Gallery Templates
Objects
- Designing Forms with the Form Designer
- Specifying the Data Environment
- Adding Controls to Your Forms
- Understanding PEM Programming
- Data Sessions
- Finding the Owner
