10 questions to ask before you build a database Access does amazing things. We can use it to store, analyse, report on, and manage data. We can get it to automate our business processes, to download CSV data from an FTP site and upload it again as a PDF. To allow users to input data [...]
Get over the limitations of the built-in CONCATENATE function in Excel.
In this post we take a look at writing an alternateive to Excel's concatenate function, which both overcomes the limit on the number of values that can be concatenated, and also allows a delmiter to be specified, such as a comma, beteween values.
Creating dynamic forms with Conditional Formatting
In this video tutorial we take a look at using conditional formatting to make Excel forms dynamically respond to user entries.
For example, display "Additional info" fields when users select a particular value, or display multiple sections based on user input elsewhere.
Get more from Excel's Conditional Formatting tools
Excel's conditional formatting tool really got beefed up with the new options introduced in Excel 2007. But in this video, we show you how to do more with conditional formatting - whether you're using Excel 2010 or Excel 97!
Learn how to... - Highlight a whole row of data based on a condition in one cell
- Change a value with a scroll-bar control
- Make conditional formatting more dynamic
A chance to say a big thank you!
It's been a packed few months for us at The IT Service. As well as developing multiple database for existing clients, we've had a great time meeting new customers too.
Whether it's an in-depth look at how an existing database can be better structured, or a whistle-stop tour around the key features of Office, an introduction to XML or a look at creating a system to link Outlook and Excel - we've seen it all in the past few months!
Here's just a little of what we've been up to, and who's joined us since the start of the year...
I love Microsoft Access. There, I said it. Thare are so many things I love about it that I wouldn't know where to start with listing them all. So, it's just as well that this article isn't about that. It's about fixing one of those things that's just a bit of a pain. Use prefixes [...]
The InputBox is one of the most commonly called functions in the whole of VBA. Whether you're writing a complete database application in Microsoft Access, or just adding bit of functionality to your Microsoft Excel workbooks, the odds are that you won't do much coding before you make your first call to the InputBox function.
So, I thought I'd dedicate this post to getting a little more from the InputBox - particularly in Excel, but also in Access.
Learn to build a database by building your database!Many of our customers come to us to ask for an Access training course. We talk about the sort of topics that they would like to cover, and it becomes clear that in very many cases the customer actually needs to learn how to build a database. [...]
The IT Service is delighted to announce another addition to our catalogue of courses - Microsoft Project training! As with all our training, our Microsoft Project courses are designed to give you exactly what you need. There's no sitting with a bunch of other people who all have different needs to you, but rather we [...]
We do all we can to give our customers unbeatable training. So, it's nice when we hear back from them to tell us that we've got it right. I wanted to share with you an email I received today following our recent visit to Rock-It Cargo, for whom we ran three days of Excel training [...]