Progressive Training & Development courses

...at demystifying Microsoft Office 2007 and getting you up to speed quickly. Your experienced trainer will point out the main differences between versions of the software...

...Message Toolbars The Advanced Toolbar Mail Creating Messages Mail Customization Opening And Replying Contacts Tasks... Learn about: Microsoft Office...

...Records Navigating around a table Entering Data Deleting Records Modifying the datasheet Moving Columns (Fields) Hiding/Unhiding Fields Understanding Table...

...settings Resizing and moving objects Adding subtotals and averages Making cosmetic changes to a report...

...along with getting an introduction to SQL (Structured Query Language), a look at some other Query types and options, and create forms from scratch...

...(or Switchboard), and learn how to use macros in Access. Please note that macros are not VBA. DESCRIPTION This course looks at setting databases up for other people to...

.../ Fields Table Relationships Entity-Relationship (ER) model Primary and Foreign Keys Referential Integrity Data Integrity Data Normalisation Table indexing...

...This course will provide the opportunity to write and test a range of SQL queries within MS Access. One of the sections adopts a more theoretical approach...

...Modules Writing your Functions Using functions in Queries and Forms Form-Event Procedures Using Form Events Code Behind Forms Changing Form Properties...

...of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence...

...Folder Creating New Accounts Editing an Account Account Views Business Contacts Opening the Business Contacts Folder Business Contact Views Skill Sharpener...

...Text Formatting Numbers Manipulating Data Formatting Columns And Rows Formatting With Colours And Patterns Adding And Editing Borders Using Autoformat...

...DESCRIPTION This course takes the beginner into more of the time saving features of Excel, exploring many different types of built in functions...

...Validation Documentation CUSTOMISING EXCEL 2003 Configuring Excel 2003 Options Customising The Excel Environment Working With Workspaces COLLABORATION...

...Financial Functions (PMT and FV) Understanding Logical Functions Applying Logical Functions Using SharePoint Creating a Document Workspace Accessing...

...Using AutoFormat Applying your own Style Setting Table Options Grand totals for columns and rows AutoFormat table Subtotal hidden Page items Merged Labels...

...DESCRIPTION A further look at the power of Pivot tables and Pivot Charts, introducing getting your data from multiple sources, and opening the door to OLAP Cubes!...

...basic for Applications (VBA) PREREQUISITES You need to have Intermediate to Advanced Pivot Table knowledge. You should have attended Excel VBA Level 1 at a minimum...

...Creating a New Web File VIEWS Moving Around the Workspace Changing the Page Window TOOLBARS The Standard Toolbar The Formatting Toolbar TEXT Adding...

...Standard Workspace Creating a Standard Workspace Sending and Accepting Workspace Invitations Working in the Workspace Members Pane Changing the Role...