Category Archives: Microsoft Access

Open Favourite Documents Quickly in Word, Excel, PowerPoint and Access

We all have documents we use regularly and even though they conveniently appear on our recent file list we can make them even more prominent. This can be done by pinning these files in the recent files list. This is … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, windows 7, word, word 2010 | Tagged , , , , | Leave a comment

VBA: Using the IF Statement

The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications | Tagged , , , , | 1 Comment

VBA: Understanding Variables

If you are getting into macros then you need to know about programming in Visual Basic for Applications (VBA) and with that you need to know about variables. VBA is a great tool for automating so many tasks in Microsoft … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, PowerPoint, Uncategorized, VBA, Visual Basic for Applications, word, word 2010 | 1 Comment

How to Use Excel PivotTables

Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick … Continue reading

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

Microsoft Access: How to Use the Update Query

If you have been following my blog since the beginning of this week you will have seen that I have been looking at action queries in Microsoft Access. These are queries that are using for changing the data sets such … Continue reading

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

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