Due to our continued growth, we need to speak to you if you are a... Microsoft Access / SQL / VBA expert with great interpersonal skills This is a fantastic opportunity to make an impact in a dynamic company. We would love to talk to you if you have Real, in-depth understanding of relational databases [...]
Back in the height of the summer (such as it was) we promised to keep you up-to-date with our latest feedback each month. We've been a bit remiss since then - our list of happy customers has been growing, and we've been getting busier and busier - so this is the first chance we've had [...]
Following the success of our first three years, we're moving to London!
July marks our third birthday - and it's all change for us. Due to our continued growth and success, we've made the decision to move from our base just south of Guildford, and set up in bigger offices in the Wimbledon area.
It's a really exciting move for us - and one which we'd like you to help us celebrate with a special discount
Our feedback is a matter of public record.
Good or bad, we publish it.
Take a look - here's how we are doing on each of the questions we ask our delegates to answer.
Just a very quick post to say that we're about to announce some really exciting news....
Can't say anything more just yet, but watch this space, and we'll be telling you more very soon.
Perhaps the biggest thing to happen to us since The IT Service was founded three years ago...
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...