F1
About F1Course ScheduleOther ServicesSite MapContactHome

Visual Basic

 
Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
FoxPro 2.6 Data User - 1 day  
(Print Flyer in PDF format)  What is PDF?         

Target Audience: This course is designed for new users of FoxPro 2.6 systems or non-technical staff who will be involved in analysing data from a FoxPro 2.6 system or the FoxPro environment.

Pre-requisites: As an End-User to FoxPro, this course has no pre-requisites. However, familiarity with a computer keyboard and mouse, and simple DOS/Windows commands would be an advantage.

Purpose: To give the end-user an insight into the capabilities of the FoxPro 2.6 Relational Query By Example (RQBE) module, and the ability to use the powerful in-built reporting features to the full.

COURSE OUTLINE:

Database Concepts
Understand the definition of a database
Why use a database
Understand the benefits of the FoxPro 2.6 Database Management System

Use FoxPro Interactively
Understand the Menu layout
Be aware of the Command window
Use windows and dialogs
Understand the terms Database, Table, Record, Field, Index and Relation

Configure FoxPro
Control the FoxPro environment using the View Window
Change the on/off settings
Change the file locations
Change the international and miscellaneous options
Save the current settings to a .VUE file and directory

Create and Use Indexes
Summarise informationn Group information
Output to screens, reports or graphs
Link to datafiles
Using Multiple Related Databases

Create Reports with the Report Designer
Create simple reports using the Quick Report option
Understand and Modify report layouts
Move and align report objects
Use the Text tool, Field tool, Line and Box tools to enhance the design
Change Fonts and Font sizes and styles
Group & subtotal complex reports
Use variables in report layouts

Output Reports
Preview report output
Send reports to a printer
Set printer options

RQBE
Specify search and select criteria for fields and records
Order information
Browse selected records
Output to a quick report
Group and subtotal outputs
Output to a Graph
Query several tables simultaneously

Particulars:
Cost: £330(
528) excluding VAT
Platform: Windows NT
Numbers: Maximum of 6 people on each course at F1’s training facilities in London, Bath and Manchester

Adobe Acrobat (PDF) Reader is a free application which enables people to view and print flyers just as they would have been professionally printed .You can down load it from the site below:

Adobe Acrobate Reader      Table of all F1 Flyers in PDF format
© F1 Computing Systems 2001