Instructor Led Aggregate Training Classes

MS Access Basic - Advanced ...L X The SELECT Command X The Predicate Option X SQL Aggregate Function X Advanced Forms X Tab Controls X Adding a Hyperlink to a Form X Adding Graphics to a Form X Modifying Default Control Properties X Properties of Forms X Setting the Format Properties X Setting the Data Properties X The Record set Type Property X The Cycle Property X Setting the Tab Order X  more...

Business Objects Universe Designer ...nctions Using Hierarchies Working With Hierarchies Aggregate Awareness Applying Aggregate Awareness To Objects Derived Tables And Indexes Using Derived Tables Applying Index Awareness Linking Universes Creating Links Between Universes Securing Universes Setting Access Restrictions On A Universe Managing Universes Documenting Universes Deploying & Maintaining  more...

SQL Fundamentals of Querying ...ge. * Recognize proper syntax for an SQL statement. * Use aggregate functions, column aliases, and mathematical expressions in a query statement. * Use the WHERE clause to select specific rows of information from a database. * Search for specific character strings or numeric data in a database. * Write queries that return both aggregate and non-aggregate information simultaneously. * Write  more...