Can't find what your looking for?

Call us on +44 (0)1273 622272 or contact us.

Courses

showing {{courseLimit}} of {{(courses | filter:query).length}} results Show All

Hide All

Categories

showing {{courseLimit}} of {{(tags | filter:query).length}} results Show All

Hide All

theBLOG

What's New in Access 2013?

Written by Andy Trainer – Tue 29 Jan 2013

Access-2013With Microsoft Office 2013 set for release very soon (and after our look at the new mobile excel apps), we thought we'd take a look at some of the new features to be added to its Access software.

The database powerhouse has undergone an overhaul and not just aesthetically. More app-focused, easily shareable and with a revised back-end, Access 2013 is set to build and develop upon the now three year old incumbent, Access 2010.

If you'd like to learn how to use Access from scratch, come on our Beginner's Access Training Course or if you have some experience but would like to brush up on your skills, try our 1 day Advanced Access Workshop.

So what exactly is different about Access 2013 compared to previous versions? And will these differences make the user experience better or worse?

App-Based

The biggest new feature to be brought in with Access 2013 is the focus on a more app-based system.

What with the introduction of  Windows 8 and Sharepoint's development into a realistic competitor to Google Drive and Dropbox, it's unsurprising that Access 2013 has such a focus.

In Access 2013 you'll be able to create an app (which can effectively be anything, but we'll assume an Access file!), upload it to Sharepoint and then allow access to anyone you like.

No extra login details are required; just those of  the business'/users' Sharepoint account.

Read More


Would You Use Microsoft Excel on Your Mobile?

Written by Andy Trainer – Thu 15 Nov 2012

Rumour has it Microsoft looks set to release a version of Office for iOS and Android devices early next year, and it's safe to say the preemptive reception is mixed. Whilst there has been no official announcement from Microsoft, The Verge broke the news after receiving various leaks from high-profile sources as well as posting an apparent screenshot of the app in use on an iPad (see pic below).

Office-on-iOS-screenshot

With the recent release of the Surface Tablet and Windows 8 as a multi-platform operating system, many are questioning the decision to release a flagship product on competitor devices. However, it would appear that the basic free version of Office set to be available on mobile devices will be nothing more than a document reader - editing functions will only come with an Office 365 subscription.

As no official details have been released as yet we can't go into depth on the functionality of the app, so instead in this article we'll be taking a general look at the potential impacts and usefulness of Office on iOS and Android.

Microsoft Office 2013 has already been released to coincide with Windows 8. We will be updating our Microsoft Office courses,  which includes our Excel Training and our Advanced Excel Trainingto use the latest software.

The question is: would you use Excel and other Office programs on your current mobile device? And if so, how much would you pay to use them?

Read More


Windows 8, Apps and Responsive Web Design

Written by Aaron Charlie – Thu 25 Oct 2012

New course just launched! Learn how to create iPhone apps with no prior coding experience on our iOS App Training for Non Developers course!

If Windows 8 proves to be as popular and widely adopted as Windows 7, it could be huge for apps and responsive web design, taking the formats from mobile to a mainstream desktop market.

windows-8-responsive-web-design-apps

The booming mobile industry (dominated by iOS and Android) has seen apps go mainstream in the last few years. It has also prompted a radical change in web design with a desire for responsive design that adapts to browser size.

However, the number of websites with responsive design is still miniscule, and apps are still mostly for personal use on mobile devices. True synchronicity between desktop and mobile, (and between work and home) is still a long way off.

Windows 8 could be the catalyst to take app development and responsive design from mobile to desktop.

Stay ahead of the curve with our range of mobile development courses. We run iOS App training and Android App courses for native app developers as well as our highly popular mobile web week workshop which includes a day on responsive web design.

Windows 8 Apps

Sorry developers, it looks like you're going to have to learn to make apps for Windows 8 on top of Android and iOS.

Taking Apple's latest OSX update a step further, Microsoft have unveiled an operating system to work on all devices, desktop and mobile, by focusing on apps. They're a bit late to the party, with Apple have had an App store on desktop for a long time. But despite Apple's break into the market, Windows is still by far the global operating system of choice, particularly in workplaces.

Like Apple's App Store and Google Play, Microsoft is launching its own closed app marketplace and this is expected to become the norm for downloading software as it's often seen as 'safer' than downloading straight off the web, and easier than going into a shop and buying a disk.

Read More


Free Excel and Word documents for your Link-Building Campaign

Written by Heather Buckley – Fri 01 Oct 2010

excel training toolbox

by Gerard Yap on Flickr

Every SEO Person Needs This in their Link-Building Toolkit

Link building is the process of trying to manipulate the inbound links that are directly aiming towards a site. It is an essential part of an SEO campaign but a lot of SEO people do not use or have the essential tools to do the job properly and thoroughly. Even so, the people with the right tools still don’t use them to their full potential and are making life difficult for themselves.

If you want to learn more about building your own spreadsheet then take our Excel Training course ( we also offer advanced excel training), also if you want to learn more about Search Engine Optimisation, then try our SEO Training course in Brighton, Sussex.

I have created an Excel document and a Word document to help you with your link building campaign. The Excel document includes different worksheets with different lists in to enter your data as you go along. For data entry, Excel will always be a useful tool to use as it allows you to switch from cell to cell while entering data with ease.

Normally, link building is an on-going practice and from time to time it can get boring and repetitive, but if you keep it all organised then you will find it a lot easier. Also, if you need to get someone else to do the link building for you, with these resources, you can easily pass on what you have done and they can just pick up where you left off.

You can download the resources at the bottom of this page, but here’s a breakdown of what is in them and what you should be considering when starting your link building campaign -

Read More


Changing Your Chart Style

Written by Andy Trainer – Wed 06 May 2009

Once you're happy with the chart type, you can also change the style so that the colours and fonts fit with the image you want to portray.

Again - select your chart and look at the "design" section of the ribbon. You will find the chart styles section on the right hand side of the ribbon. For more options, click on the “More” arrow as indicated below:

Excel Chart Styles 1

In our example, select layout 42 at the bottom of the list. Excel will then automatically apply this to your chart, like this:

Excel Vehicle sales graph 2

Read More