PPi Learning Services courses

...Creating Fields in Design View, using Field Templates and existing fields. Field properties Table relationships Indexing fields Creating key fields Formatting...

...This course enables existing Access users to create database applications using Access forms and macros. Course content Create table relationships and default joins...

...changes to database object names. Creating forms using the Form Wizard and the autoform options, manually editing forms to format the appearance of...

...to command buttons Requery macros SendKeys and SetValue macro actions Exporting data using a macro...

...to hide the database window, remove in-built Tool bars and menus...

...list boxes, radio buttons, check boxes and group boxes onto a form. Create bound and unbound object frames to display graphics or documents...

...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...

...This course is designed to enhance the knowledge of existing Excel users and improve their skills. Course content Freezing and splitting worksheets...

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

...Building Formulas. Basic calculations and priorities. Inserting functions. Using AutoSum. AutoCalc. Calculating across Worksheets. Formatting...

...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...

...entering, editing and erasing cell contents, copying and moving cell contents, undo and redo Simple calculations and priorities, functions and the formula palette...

...Automatic Outline Hiding and Displaying Outline Working With Visible Data Only Linking Worksheets Consolidating Worksheets Creating Hyperlinks...

...with the Current File or All Excel Files Assigning Shortcuts Recording With Absolute or Relative References Assigning Macros to Buttons or Shapes...

...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...

...forms Form layouts Adding form controls Linking controls to data source elements Setting control properties Linking controls to databases Using colour...

...Students will learn how to create custom toolbars, customize the menu bar and Navigation pane, use advanced search options, set and remove filters...