  |
|
| HOME | | | ABOUT US | | | TRAINING SERVICES | | | COURSE SCHEDULE | | | CONSULTING & DATABASE DEVELOPMENT | | | CONTACT US |
|
|
|
|
|
| DATABASES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Access Introduction ◄-- Click here for Course Outline Learn the basics of planning and designing databases by creating and modifying tables, creating and running queries, designing forms and generating reports. This course provides a great foundation for understanding the concepts of relational databases. Prerequisites: Windows Introduction or previous Windows experience, Word Introduction, and Excel Introduction.
CALL FOR ACCESS 2007 CLASSES Access Intermediate ◄-- Click here for Course Outline This course covers topics including table relationships, the Lookup Wizard; data integrity; input masks and validation rules, advanced queries including calculations, crosstabs, and parameters. Students also learn advanced form features including calculations and combo boxes, customizing reports; using functions and expressions; and macros. Prerequisites: Access Introduction.
CALL FOR ACCESS 2007 CLASSES Access Essentials of Table Design ◄-- Click here for Course Outline A little knowledge is dangerous - truer words were never spoken especially as they refer to designing a relational database like Access. A must class for database designers. Learn the five rules of "data normalization" that will save you grief and pain as you develop your database. Also learn how to make sure your database has integrity. Prerequisites: Access Introduction and Access Intermediate.
Access Advanced ◄-- Click here for Course Outline For the power users, this class will cover building advanced forms with grouped controls and subforms, creating advanced macros requiring user interaction and AutoKeys, writing and attaching basic SQL statements, Internet integration, and security fundamentals. Prerequisite: Access Intermediate and Access Essentials of Table Design.
NEW CRYSTAL REPORTS XI COURSES! Crystal Reports Introduction ◄-- Click here for Course Outline This two-day, hands-on class, teaches the basic features and functions of Crystal Reports XI. Students will explore the program environment and learn how to open, navigate, create, modify, and save reports. They will learn the fundamentals of formatting report objects, of sorting and selecting records, and creating groups and summaries. They will also learn how to create simple formulas and functions. Finally, students will work with experts and wizards, and learn how to export reports to various file formats. * The courseware publisher, Axzo Press, is an Approved Crystal Reports Content Provider for North America.
Prerequisites: Access Intermediate or equivalent experience with databases.
Crystal Reports Advanced ◄-- Click here for Course Outline This two-day, hands-on class, builds on the skills and concepts taught in Crystal Reports XI: Introduction. Students will learn how to create and use parameter fields, including cascading parameters. They will learn how to build advanced formulas using variables, advanced functions, and constructs. They will also learn how to create and customize charts and maps, apply advanced formatting options to report elements, and create alerts and subreports. Finally, students will work with the Business Objects Enterprise Repository and the Workbench, and they will learn advanced data access techniques including ODBC data sources and SQL query-building. * The courseware publisher, Axzo Press, is an Approved Crystal Reports Content Provider for North America.
Prerequisites: Crystal Reports XI Introduction or equivalent experience.
|