PPi Learning Services courses

...in tables Subdatasheets Creating Select Queries Single table queries Multiple table queries Common query criteria Calculating fields Advanced Select Queries...

...prevent incomplete or inconsistent data by establishing referential integrity, set and use Cascading updates and deletions. Link to tables in other databases...

...query totals and crosstab queries, using action queries to enable repetitive updates or deletions in tables. Using name autocorrect to track and manage...

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

...Perform batch updates on data by learning how to use action queries. Use control wizards to create a user-friendly form by placing combo boxes...

...editing and deleting records Sorting records, searching for records AutoFilter and advanced filter Database functions Using Lookups with a database...

...managing workbooks Moving to and selecting cells, entering, editing and erasing cell contents, copying and moving cell contents, undo and redo Simple calculations and priorities...

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

...This course is designed to familiarise the delegate with the Advanced concepts of Excel. This includes viewing specific worksheet data, using Goal...

...Changing column widths / row heights. Changing values and date display. Changing cell alignment. Applying borders, fonts and colour. Live Preview...

...The Display Freezing and splitting worksheets Hiding and unhiding files, rows and columns Utilities The Watch Window Charting Creating and formatting...

...creating a pivot table chart Toolbars, menus Creating a template...

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

...Stack Setting Watches Viewing Variable and Array Values in Break...

...effects Templates and components Style sheets Creating style sheets External style sheets Forms Creating a form Collecting form results Frames Applying...

...and security Publishing a Web site Managing Web security...

...Creating views Page Setup Managing Form Templates Previewing form designs Protecting form designs Managing form versions Saving form designs Publishing...

...This course teaches advanced-level functions and features of Outlook 2003. Students will learn how to create custom toolbars, customize the menu bar and Navigation...