PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
User
Business Professional
DATES:
CONTENT AND OBJECTIVES:
Terms and Concepts
Examine the concepts and terminology of a database and MS Visual FoxPro.
Getting Started
Start and exit from FoxPro.
Display the help and search the documentation for a command.
Templates and Wizards
Create a simple application using a built-in template.
Display the attributes of an existing database.
Working with Databases
Create a new database and store data in a table.
List the attributes of the database including the location.
Creating Tables
Create a table using the wizard.
Create a table using the design mode.
When creating the tables, use several different column types.
Load sample data into the table.
Working with Tables
List the values created in the previous exercise.
Create multiple views of the data.
Select specific records and certain columns.
Change the values in the table.
Setting Field Properties
Create and test several validation rules and defaults.
Create an input and output mask.
Simple Queries
Create a query using a wizard.
Create a query in design mode.
Operators in Queries
Code and test a complex query using boolean logic.
Code and test a query using character pattern matching.
Designing Advanced Queries
Retrieve data and calculate a derived named column.
Create a parameterized query and ask the user for the values.
Creating Basic Forms
Create a simple form with a Form Wizard.
Create a form in design mode and make several modifications.
View and edit data with the form.
Editing Forms
Search the field list and make several modifications to the displayed and calculated fields.
Add a graphic object to the form.
Creating Basic Reports
Code a report with the Report Wizard.
Code a report using the design view.
View and print the report.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
