You are here: UK Home > Technology > Software


Latest Technology News for the UK Accountancy Profession

Accountancy Profession is an accountancy news aggregation site created by accountants for accountants

Fully automated Accountancy Profession continuously collates the latest accounting news and headlines from over 150 sources and links straight to the best accountancy websites. Our mission is to enable accountants to see at a glance developments in the accountancy profession by providing links to all the accountancy news in one place and therefore saving the time consuming task of searching hundreds of sites and blogs.

If you know of a news, Twitter or YouTube feed which would be of interest to other accountants please contact us as the site is continually developing and new pages and feeds are added on a regular basis.

Microsoft Access Blog

  • Using a Combo Box to search as you type

    Using a Combo Box to search as you type

    Here's a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box. As the user types, the form filter updates to display full or partial matches for the value entered. This example uses a slightly m…
    Published - 18 days ago, 3 May 12, 3:27pm
  • Access 2010: How to write expressions for Web queries, forms, and reports

    Access 2010: How to write expressions for Web queries, forms, and reports

    Before Access 2010, Access supported a wide variety of expressions in different areas of the application.  Tables and fields, queries, form and report properties, controls, and macros can all use expressions to evaluate data or logic to drive the be…
    Published - 63 days ago, 19 Mar 12, 3:24pm
  • Q&A with Access developer Juan Soto

    Q&A with Access developer Juan Soto

    Working in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc.,  an Access development consulting firm. The ice cream factory's large Enterprise Resource Planning system required that he spend hours manually calculating whether a…
    Published - 93 days ago, 17 Feb 12, 4:55pm
  • Five Common Pitfalls When Upgrading Access to SQL Server

    Five Common Pitfalls When Upgrading Access to SQL Server

    Guest blogger Juan Soto, an Access MVP and founder of IT Impact, Inc., shares five tips on upgrading Access to SQL, including information about using the SQL Server Migration Assistant, adding tables, bit fields, and foreign keys. You can also rea…
    Published - 93 days ago, 17 Feb 12, 4:54pm
  • How to save your Access SharePoint password

    How to save your Access SharePoint password

    Recently, someone posted a comment on IT Impact Inc.'s blog asking how to get SharePoint to remember his password when he logged in via Access. He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew…
    Published - 26 Jan 12, 4:52pm
  • Display real-time information with the ControlTip Property

    Display real-time information with the ControlTip Property

    The ControlTipText property is usually associated with providing static information. But it can also be used to display real-time info in a wide range of scenarios. ...(read more)
    Published - 28 Nov 11, 7:00pm
  • An Updated Data Model Has a Choral Arts Group Singing

    An Updated Data Model Has a Choral Arts Group Singing

    When Donna took on the role of Director at Choral Arts (a non-profit singing ensemble), she inherited a disorganized database with redundant, unreliable data. We helped Donna devise a data model and import her data into a new set of normalized tables…
    Published - 21 Nov 11, 7:00pm
  • Full-featured Access Services solution at http://www.accesshosting.com

    Full-featured Access Services solution at http://www.accesshosting.com

    Our good friends at accesshosting.com are offering 30-day trials of two Access "cloud" solutions. Curious? Here's the deal......(read more)
    Published - 14 Nov 11, 7:00pm
  • Ways to use Access data in Excel

    Ways to use Access data in Excel

    When you need to use Excel to analyze data in an Access database, you have several options: you can copy and paste the data, create a data connection from Excel, or export the data to an Excel file. Your best choice depends on what you want to do. Co…
    Published - 6 Oct 11, 6:00pm
  • Date functions part 1: some common scenarios

    Date functions part 1: some common scenarios

    Many of you search Office.com for help using date functions in Access. Perhaps you want to select some portion of a date (e.g., the year). Maybe you want to format the display of date/time data, or find the difference between dates. In this post we…
    Published - 15 Sep 11, 6:00pm

Microsft Excel Blog

  • Split and merge data in URLs

    Split and merge data in URLs

    Issue: I have a list of URLs with their corresponding page views. The URLs include a section of the site and the date when the page was published. I'd like to calculate the total number of page views by site section and the total number of page views…
    Published - 4 days ago, 16 May 12, 9:43pm
  • Quick Trick: Resizing column widths in pivot tables

    Quick Trick: Resizing column widths in pivot tables

    Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how…
    Published - 6 days ago, 14 May 12, 4:39pm
  • Count values that meet a condition with the COUNTIF function

    Count values that meet a condition with the COUNTIF function

    Update: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages.You probably know how to use the COUNT function to count cells that contain a value. But what if you want to count only the c…
    Published - 16 days ago, 4 May 12, 4:39pm
  • Using multiple criteria in Excel Lookup formulas

    Using multiple criteria in Excel Lookup formulas

    If you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOK…
    Published - 24 days ago, 27 Apr 12, 1:01am
  • Merging and splitting cells or data

    Merging and splitting cells or data

    The title of this post sounds simple. Should be easy to do, right? But customers tell us that it's very confusing and not at all clear where to find the features to get the results they want. It all depends on what you want to merge or split. For exa…
    Published - 38 days ago, 12 Apr 12, 5:30pm
  • And the winner of the VLOOKUP Great White Shark Award is...

    And the winner of the VLOOKUP Great White Shark Award is...

    JP Pinto! Congratulations!His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week. He won a copy Bill Jelens book Microsoft Excel 2010 In Depth. You can find links to all seven posts and see the votin…
    Published - 39 days ago, 11 Apr 12, 9:13pm
  • Excel: Not just for geeks

    Excel: Not just for geeks

    Ugh. Excel. It's not as intuitive as a Word doc, and not as aesthetically pleasing as a PowerPoint presentation. If you're more creative than analytical, you might feel as though it's dry and boring and filled with numbers you'd rather not look at. H…
    Published - 44 days ago, 6 Apr 12, 4:46pm
  • VLOOKUP Week wraps up: Vote for your favorite post

    VLOOKUP Week wraps up: Vote for your favorite post

    VLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside--Excel experts created a crazy number of useful an…
    Published - 46 days ago, 4 Apr 12, 7:56pm
  • VLOOKUP Tutorial: Updating prices in a master price list

    VLOOKUP Tutorial: Updating prices in a master price list

    In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. This tutorial assumes you've heard about VLOOKUP and its benefits, but that you don'…
    Published - 53 days ago, 28 Mar 12, 8:39pm
  • Today's giveaway: Odes to VLOOKUP (It ain't over until the formulas stop singing)

    Today's giveaway: Odes to VLOOKUP (It ain't over until the formulas stop singing)

    Bill Jelen found it. Erica Rhein started it.  She posted a comment on Facebook declaring her complete dependence on VLOOKUP.  "I use Pivot Tables and VLOOKUP every day. I would be screwed at my job without it."  To Bill's formula-possessed mind th…
    Published - 54 days ago, 27 Mar 12, 7:15pm

Microsoft Word Blog

  • Tricks from Word Expert Hilary Powers

    Tricks from Word Expert Hilary Powers

    If Hilary Powers can teach editors tricks about using Word, then we ordinary folk can definitely benefit from listening to her. Hilary's the author of Making Word Work for You , a handbook for editors, and the maker of creatures out of felt. As an ed…
    Published - 9 days ago, 11 May 12, 6:19pm
  • Office Tip Classics: Make table headers repeat, get a prom date (video)

    Office Tip Classics: Make table headers repeat, get a prom date (video)

    Edna Jean's parents aren't sure about Conrad taking her to the prom, even though he's her "hunky wunk". Then she tells them that in Word, he can make table headers repeat over multiple-page tables. Will this seal the deal with Edna Jean's parents?...…
    Published - 11 days ago, 9 May 12, 6:02pm
  • Webinar: Mail Merge

    Webinar: Mail Merge

    This week's webinar is a bit of cooking class. The dish? Fresh Mail Merge. This is a process, not just a few clicks. We'll show you some free tools at Office.com that we’ll show you, including a cookbook (of sorts). Go to http://aka.ms/offweb for…
    Published - 21 days ago, 30 Apr 12, 3:41pm
  • Word video: Convert a table to text

    Word video: Convert a table to text

    In Microsoft Word, you can convert a table into text, and vice versa. In this video, you'll learn how to change names and addresses in a table into a list separated by commas.   If you just want the text version of the instructions, re…
    Published - 53 days ago, 28 Mar 12, 11:38pm
  • Change the default line spacing in Word

    Change the default line spacing in Word

    When the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.15 spacing in Word 2007 and Word 2010, customers asked the inevitable: Why did the default line spacing change? And how do I change it back?…
    Published - 75 days ago, 6 Mar 12, 9:00pm
  • Tip: Add page numbers—and only page numbers—to your Word document

    Tip: Add page numbers—and only page numbers—to your Word document

    So why does the title of this post emphasize adding just a page number? Because in Word, you add page numbers to a header or a footer, which means to perform this simple task, you need to know how they work. ...(read more)
    Published - 76 days ago, 5 Mar 12, 6:06pm
  • Tip: Finding a job-specific resume template in Word

    Tip: Finding a job-specific resume template in Word

    When someone needs a new resume, he or she either starts from scratch or searches the Web for a template. What they don't know is that access to free resume templates is hiding in plain sight in Word. All you have to do in Word is click New, look und…
    Published - 83 days ago, 27 Feb 12, 5:20pm
  • Tip: How to cut and paste without messing up formatting

    Tip: How to cut and paste without messing up formatting

    Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste-like a fly returning to honey.That thing--the Paste Options button--is your friend, a w…
    Published - 10 Feb 12, 6:00pm
  • Making Valentine's Day Cards with Word

    Making Valentine's Day Cards with Word

    I want my Valentine's Day card to be as special as the special someone I'm giving it to, and I'm not so good with scissors and glue. So I'm going to start with a template from Office.com, and then I'm going to customize my card, make it more persona…
    Published - 7 Feb 12, 8:14pm
  • Customize! 5 table of contents tricks

    Customize! 5 table of contents tricks

    The Word 2010 gallery makes adding a basic table of contents quick: Click the References tab, click Table of Contents, and then click the gallery table of contents you want. But what if you want more? What if your table of contents needs to provide…
    Published - 18 Jan 12, 7:25pm

AccountingWEB uk - Excel

@IntuitUK

Intuit Small Business Matters

  • Intuit digs in!
    Intuit staff recently helped out with a garden makeover at Maidenhead Nursery School. The clean-up was organised by Windsor and Maidenhead Voluntary Action and was in support of World Earth Day. At Intuit, staff get four paid days off per year to car…
    Published - 3 days ago, 18 May 12, 7:41am
  • Financial Fitness workshops - Small business feedback
    This week, Intuit reached the milestone of helping 1,000 British businesses get financially fitter, just six months after launching its nationwide Financial Fitness initiative. The scheme launched in November 2011, in support of the Government’s Fi…
    Published - 4 days ago, 17 May 12, 10:30am
  • 1,000th business benefits from Intuit’s financial fitness training
    Intuit has now helped more than 1,000 British businesses get financially fitter, just six months after launching its nationwide Financial Fitness initiative. The Intuit scheme, which launched in November 2011, in support of the Government’s Finance…
    Published - 5 days ago, 16 May 12, 3:16pm
  • QuickBooks tips and tricks: Issuing delivery notes with QuickBooks Online
    Did you know you can easily issue delivery notes using QuickBooks Online? Here’s how: Simply go to: Customers > Invoice List and search using the “Show” and “Date” filters to list the invoices that you want to print a delivery note for. The…
    Published - 6 days ago, 15 May 12, 8:19am
  • Smile! Free professional corporate portrait when you sign up for a QuickBooks 30-day free trial
    Are you coming to the Business StartUp Show later this week? You could get a free corporate portrait taken by professional photographer, Sarah J. Carter. Claim your free portrait To get your free portrait, all you need to do is sign up for a QuickBoo…
    Published - 7 days ago, 14 May 12, 12:02pm

@Sage (UK) Limited

Sage Blog

  • The Business Startup Show
    It’s that time of year again for one of the largest events for small businesses in the UK - The Business Startup Show and The Great British Business Show. So, we’re busy packing our bags and heading down to Excel, London to exhibit at the show…
    Published - 5 days ago, 16 May 12, 9:30am
  • Wonga’s wake up call for Britain’s banks: it’s time to lend to small businesses
    Last week’s news that lender Wonga (a provider of high cost short term personal loans) has launched a business loans service, promising to make funds of £3,000 to £10,000 available within 15 minutes of an application is a signal to banks and the…
    Published - 7 days ago, 14 May 12, 12:06pm
  • A day in the life of a Telesales Executive
    For the first of our Sage Career blogs Louise Piggott from our Recruitment Team looks at a typical day for a Telesales Executive within our Small Business Division. If this sounds like the career for you then check out our recruitment pages for more…
    Published - 13 days ago, 8 May 12, 10:18am
  • Getting real with Real Time Information
    If you run your payroll then you need to know that there is a big change heading your way and that change is called RTI. Real time Information or RTI is a new system that's being introduced by HMRC to improve the operation of Pay as You Earn (PAYE).…
    Published - 20 days ago, 1 May 12, 10:57am
  • Dealing with business debt
    The economy is in yet another challenging year, testing the strength of even the most robust of businesses. But what should you do if your business is struggling with debt? Nicola Connop, team manager at Business Debtline, offers her advice...
    Published - 28 days ago, 23 Apr 12, 10:41am
  • Control your cash on the move with our free app
    As part of this campaign we've developed Sage Record Keeper, a free iPhone mobile app designed to help small businesses keep convenient and simple cash records in one place, Sage Record Keeper is a free and easy way to enter and track income and exp…
    Published - 34 days ago, 17 Apr 12, 11:10am
  • New regulations affecting your business
    Every April a number of new regulations come into force, and while they can sometimes be quite small changes, as part of our Sage People Advice team I thinks it important that every business is aware of them and act upon them where appropriate.
    Published - 40 days ago, 11 Apr 12, 8:50am
  • Getting your company pension scheme ready for auto-enrolment
    Our guest blog is from Simon Griffiths from Mercer. We’ve recently started working with Mercer to launch Sage Employee Benefits, a new service designed to make it easier and more affordable for small businesses to introduce staff benefits packages…
    Published - 48 days ago, 3 Apr 12, 8:07am
  • Customer service critical to success
    Our latest Sage Business Index revealed that competition around customer service is set to intensify with over half firms stating that it has become more important to their company over the past 12 months.
    Published - 52 days ago, 30 Mar 12, 2:34pm
  • Formula 1 comes to Sage
    Last week our Newcastle office received visits from Top Gear's Original Stig, a F1 car and a premiership manager. Who says business software is dull?
    Published - 56 days ago, 26 Mar 12, 12:58pm

Support - Sage 50 Accounts

  • Budget 2012
    This page explains what impact the 2012 budget may have on your software.
    Published - 3 days ago, 18 May 12, 11:51am
  • Sage 50 Accounts 2012 - Reports Only Backup and Layouts Only Backup available to download
    If you need to restore the standard reports or layouts in Sage 50 Accounts 2012, you should download these backup files.
    Published - 3 days ago, 18 May 12, 11:51am
  • My data
    The My data website is there to help you with any data corruption queries relating to Sage Accounts.
    Published - 3 days ago, 18 May 12, 11:51am
  • Sage Accounts updates
    A list of all available updates for your Sage Accounts software.
    Published - 3 days ago, 18 May 12, 11:51am
  • Sage 50 Mobile
    Access your Sage 50 Accounts data wherever you are with the free Sage 50 Accounts Mobile App.
    Published - 3 days ago, 18 May 12, 11:51am

Support - Sage Line 100

Support - Sage 200

  • Re-Release of Sage 200 2011 Service Pack 2 CRM 7.1 Patch D Hotfix 1
    We have recently re-released Sage 200 2011 Service Pack 2 CRM 7.1 Patch D Hotfix 1. Important Note: If you are using Sage 200 CRM we have re-released the 7.1d Hotfix 1 zip file, if you have installed this patch previously please review this news it…
    Published - 3 days ago, 18 May 12, 11:51am
  • Re-Release of Sage 200 2011 Service Pack 2 CRM 7.1 Patch D Hotfix 1
    We have recently re-released Sage 200 2011 Service Pack 2 CRM 7.1 Patch D Hotfix 1. Important Note: If you are using Sage 200 CRM we have re-released the 7.1d Hotfix 1 zip file, if you have installed this patch previously please review this news it…
    Published - 3 days ago, 18 May 12, 11:51am
  • Sage 200 2011 Service Pack 3 Release!
    We're pleased to announce the release of Sage 200 2011 Service Pack 3. Click here for further information.
    Published - 3 days ago, 18 May 12, 11:51am
  • 03.05.2012 - Sage Support Newsflash
    The following was sent out as a newsflash to all our registered business partners on 3rd May and it affects the Sage 200 Suite, Sage MMS, Line 100, Sage Manufacturing, Sage Construction.Please click on this link to view additional information.
    Published - 3 days ago, 18 May 12, 11:51am
  • 15.03.12 - Incident Management Utility
    Over the last few months we’ve been working hard to bring you phase 1 of a project to help you manage the incidents you have with our Technical Support Team. After a recent trial with some of our partners we are pleased to launch this for all of ou…
    Published - 3 days ago, 18 May 12, 11:51am

Sage on YouTube

NHBC Sage CRM case studyNHBC Sage CRM case study
NHBC Sage CRM case study
See how NHBC uses Sage CRM throughout their business
- 3 days ago, 18 May 12, 10:51am -
How Sage 1000 helps Knights of Old compete in the distribution industryHow Sage 1000 helps Knights of Old compete in the distribution industry
How Sage 1000 helps Knights of Old compete in the distribution industry
Sage have a range of solutions designed to help our customers in the distribution industry manage and integrate every aspect of their operation, from their supplier through to their accounts. Our customers tell us the challenge is to compete with nar…
- 5 days ago, 16 May 12, 12:32pm -
Sage Instant PayrollSage Instant Payroll
Sage Instant Payroll
Sage Instant Payroll Annual Licence Plans are simple payroll software combined with award-winning support. Ideal for businesses with up to 10 employees, it requires no in-house expertise and allows you to run your payroll in a little as 15 minutes.
- 18 days ago, 2 May 12, 7:57pm -
Sage UK CSR - volunteeringSage UK CSR - volunteering
Sage UK CSR - volunteering

- 20 days ago, 1 May 12, 12:25pm -
Sage UK - CSR: Working with our communitiesSage UK - CSR: Working with our communities
Sage UK - CSR: Working with our communities

- 20 days ago, 1 May 12, 12:18pm -
Sage UK's Jayne Archbold on corporate responsibilitySage UK's Jayne Archbold on corporate responsibility
Sage UK's Jayne Archbold on corporate responsibility

- 20 days ago, 1 May 12, 12:13pm -

@QuickBooks uk