Is your Microsoft Access Database running slowly? Do Queries take for ever to load? Read on for our great tips on optimising the performance of your Microsoft Access Database. Optimising General Table Performance To achieve the best performance results, apply the following guidelines for table design in your Microsoft Access Database: Design tables without redundant […]

The concept that collaborative planning is vital to successful development is gaining momentum, causing a shift away from traditional, top-down hierarchies toward collaborative team structures and dynamic methodologies like Agile. Microsoft Project Server, the web-based companion to Microsoft Project, provides tools that support collaboration among teams and workgroups, using the accessibility and availability of information

User-Defined Functions Microsoft Excel VBA Function Procedures can be used to standardise and simplify any type of calculation in Excel spreadsheets. As a user of Excel you will be aware that the application already comes with a vast library of functions. In Excel, whether you use a simple SUM() function or a more advanced one,

Linking a subreport to the data in the primary report Frequently, the data in a subreport supplements the data in the primary report. You might, for example, have customer data in a primary report and then use subreports to show the orders for each customer. In such cases, you will need to coordinate the data

With Microsoft Excel Power Query you can share and manage queries as well as search data within your organization. Users can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. Power Query Transforms Your Data You add your

We are pleased to announce the opening of our new Glasgow training venue, right in the heart of Glasgow city centre.  With the increase in the volume of courses we offer, and the continued growth in popularity of our highly rated training delivery, we had outgrown our previous site. From January 2017 we will be

Microsoft Project is a great tool to help you to plan projects, manage and update project information, and communicate the status once the project is under way. Planning with Microsoft Project help provides a good structure to help ensure project success. Getting Started The details of the project Tasks and associated Resources are entered into

Understanding Project Planning & Management At the heart of every project planning and management system is a scheduling algorithm. An algorithm is a mathematical or logical equation that solves a complex problem by breaking down the problem into simple steps. When scheduling resources and parameters are entered into it, the scheduling algorithm produces a project

If you know Microsoft Project well, or have been on one of our highly rated Microsoft Project training courses, this quick Microsoft Project crossword quiz should take you just a few minutes to complete. There are clues a few key words and some crucial Project terminology that every Microsoft Project user should know and understand.

Visual Basic Programming Design Standards Visual Basic Programming Design Standards for coding aren’t about rules that have been set in stone, they’re about practical guidelines that in the end will make your life as a programmer easier and your programs better. The intent in presenting this content isn’t to hand down a set of programming