PPi Learning Services courses

...This course is designed to give delegates a good working knowledge of Access, so that they can create and edit Access databases. Course contentIntroduction...

...Change startup properties to hide the database Window, and to remove the built-In toolbar and...

...or sorted on one or more fields, producing summary information in a report and using the expression builder to generate calculations on reports...

...to develop a front-end application, and to design and use macros. Course Content Table Relationships Setting table relationships Multivalued Fields Referential...

...to these objects so that forms can be opened/closed and synchronised to display related records. Create macros, macro actions, group macros...

...using the expression builder. Sort and group data and print a report...

...and date formats Auditing tools Scenario manager Creating views Goal seeking Working with lists Creating a database Using data forms Adding...

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

...Setting manual and automatic outline Hiding and displaying outline Working with visible data only Linking worksheets Consolidating worksheets Hyperlinks...

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

...This course is designed to provide a new Excel user with a good understanding of the basic concepts of spreadsheet design, commands, data manipulation...

...This course is designed to provide an existing Excel user with further knowledge about building formulas and functions, outlining worksheets...

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

...and Absolute cell referencing Using IF and Nested IF Functions Lookup tables Subtotalling data Creating data series and custom lists Setting Manual...

...Worksheet Assigning Macros to Toolbar Buttons Adding Controls to a Worksheet Creating Custom Excel Functions The Visual Basic Editor The Project Explorer...

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

...and edit HTML code. Course content Getting started The FrontPage environment Page view Web page fundamentals Creating Web pages Page structure and formatting...

...forms Applying a form design to a SharePoint form library...

...Course content Managing Outlook Data Personal Folders Archiving Folder contents Field Chooser & Group By Sort/Filter Automatic Formatting Custom Views...