Monthly Archives: December 2013

Microsoft Access: How to Use the Append Query

So you’ve imported some data into your Microsoft Access database and now need to add that data to an existing table. It would be handy to copy and paste but using an append query does the trick and you can … Continue reading

Posted in Microsoft Access, Microsoft Office, Office 2010 | Tagged , , , , | Leave a comment

Microsoft Access: How to Use the Delete Query

As the names suggests this type of action query is going to delete data so if you are doing this for the first time try this on some data you are not worried about losing or on a copy of … Continue reading

Posted in Excel | Tagged , , , , , | 1 Comment

Microsoft Access: How to Use Make Table Query

Microsoft Access has different types of queries to do everything from just viewing selected data to archiving it using a make table query, deleting data, appending data and updating data. For the next few days I will be adding video … Continue reading

Posted in Microsoft Access, Office 2010 | Tagged , , , , , , | 1 Comment

Excel Using Text Functions

Excel is great for dealing with numbers but it also has functions for dealing with text. You can check in a bit of the text by extracting it using one of the functions like LEFT, RIGHT and MID. ¬†You can … Continue reading

Posted in Excel | Tagged , | 1 Comment

Excel How to Use Subtotals

Excel is packed with lots of great tools. One of my favourites is the Subtotals. Here you can take a list, sort it into order so that appropriate items are grouped together, then click a button and it will determine … Continue reading

Posted in Excel | Tagged , , , , | 1 Comment

Combining VLOOKUP and HLOOKUP Functions

HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and … Continue reading

Posted in Excel, Office 2010 | Tagged , , , , | 2 Comments

Free Apps, Songs, Books, TV Shows and Movies for your iPhone and iPad…

…with the free 12 days of Christmas app from iTunes. Everyday from the 26th December for 12 days there is one free item. I have done this now for the past few years and although not everything is something I … Continue reading

Posted in iOS, iOS 7, iOS6, iOS7, iPad, Iphone, iTunes | Tagged , , , , , | Leave a comment