PPi Learning Services courses

...Quick Access Toolbar, Tabbed Documents, * Status bar and Mini toolbar Database objects Creating Tables Using Table Templates and manually creating tables...

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

...Changing the joins between tables in a query to control the selection of records retrieved, creating calculated fields in queries, summarising data using...

...Forms Main/Subforms Split Forms Stacked and Tabular Layouts Customising the Navigation Pane Startup options Synchronising forms Macros Creating standalone...

...Use conditional macros to validate data input. Customise the database by creating a front end, custom tool bars and a custom menu. Change Start up properties...

...This course is designed to give course participants a good working knowledge of Access. Participants will learn how an Access database works and gain...

...tables Creating pivot tables Calculating in pivot tables Creating a pivot table chart Customising toolbars and menus Creating a template and protecting worksheets...

...applying borders, fonts and colour, format painter Previewing worksheets, changing the margins and orientation, setting the print area, print titles...

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

...and working with Databases and PivotTables. You will also learn how to customise the Excel menus and toolbars as well as create your own templates. Course...

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

...sorting records, searching for records AutoFilter and advanced filter, database functions, data tables Creating pivot tables, calculating pivot tables...

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

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

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

...Lists Proofing tools Hyperlinks Internal links External links Navigation bars and shared borders Renaming pages Images Images Photo galleries Image links...

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

...Email Routing slips Shared Attachments Scheduling. Delegate permissions Managing Resources Printing Calendar details vCalendar & iCalendar Online meetings...