PPi Learning Services courses

...Database features and common terminology Designing a database and using Database Templates The Ribbon, Command Tabs, Contextual Command...

...content in web pages. Add custom toolbars and Menus to a Database to create a database Application, create a Main form to act as the front-end for a database...

...for editing or viewing and using Control Wizards to add combo boxes to forms. Producing printed reports using the Report Wizard, creating reports grouped...

...Integrity Cascade Updates and Cascade Deletes Linking to other databases Advanced Queries Updating a table via a query Querying queries IIFstatements Advanced...

...using the In-line If function. Concatenate text fields for display purposes. Use Domain Aggregate functions such as Dlookup to retrieve and filter records...

...See the effect of changing join properties between tables in a query. Create calculations in fields, summarise data by using query totals and cross tab queries...

...This course is designed to familiarise current Excel users with the advanced concepts of Excel. Course content Using string formulas Customising number...

...functions and the formula palette, using AutoCalc and AutoSum Changing column widths / row heights, changing value and date display, changing cell alignment...

...hiding and un-hiding files, rows and columns Conditional formatting Creating 2D and 3D charts Formatting charts Inserting and clearing data Naming cells...

...Working With Tables Database andLOOKUPFunctions Data Tables PivotTable and PivotChart Reports Pivot Table Calculating in PivotTables PivotCharts UsingXML...

...Page breaks, Page Break Preview and Page Layout view. Headers and footers...

...and 3D charts Setting Up / Editing Worksheets Inserting and clearing data Linking and Grouping Linking Worksheets Consolidating Worksheets Outlining Setting...

...This course is designed to familiarise current Excel users with the advanced concepts of Excel 97/2000. Course content Using string formulas Amending number...

...using AutoCalc and AutoSum Changing column widths / row heights, changing value and date display, changing cell alignment, applying borders...

...This course is designed to enhance the knowledge of existing Excel users and improve their skills. Course content Naming cells and creating 3D names Relative...

...This 2-day course is aimed at experienced Excel users, preferably with some awareness or experience of computer programming. This 2-day course is aimed...

...frames Modifying frame pages Layers and behaviours Applying layers Applying behaviours Data-driven pages Database wizards Web Parts Data Views Layout tables...

...Tables Applying tables Formatting tables Enhancing Web pages Page properties Themes Working withHTMLcode Working in Design view Working in Code view Publishing...

...data schemas to allow data to be merged with existing data storage systems. Course contentIntroduction toXML Structure ofXMLdata XMLSchemas Using InfoPath...

...forms, public folders, newsgroups, and Outlook's security features. This course is approved courseware for Microsoft Office Specialist certification...