We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Office software Reviews
15,670 Reviews

Microsoft Access 2007

Around £180 as standalone

Manufacturer: Microsoft

Our Rating: We rate this 4 out of 5 User Rating: Our users rate this 5 out of 10

The most notable things about Access 2007 is that Microsoft has finally given it some long-overdue attention and beefed up its security tools while making the whole program more usable.

The most notable things about Access 2007 is that Microsoft has finally given it some long-overdue attention and beefed up its security tools while making the whole program more usable.

Click here to read our review of Office 2007.

While these tweaks won't totally stave off speculation about whether Microsoft intends to replace it with SQL Server and some fancy design tools, Access 2007 constitutes a major overhaul of the ageing database app, adding significant new features and streamlining the interface. For those who regularly manage data in Access, it's a worthwhile upgrade.

Access tames its Windows

Previous versions of Access have forced users to deal with a dozen floating windows at once. Access 2007 removes the clutter and organises windows into neat tabs. A navigation pane on the left lets users choose a database object to work with. The pane is permanently visible, but you can collapse it into a narrow bar if you want more workspace. The upshot is that working in the less congested new interface is much easier and more enjoyable.

Nor has Microsoft forgotten about old-school Access users. You can still bring back the overlapping windows - useful for viewing several database objects at a time. Access 2007 handles databases created in previous versions of the program without a hitch, though the new display environment and code security settings will force long-time users to adjust a bit.

Files in your database

One of the best new features is the Attachment data type, which permits you to embed entire files in your database. It's a great way to store pictures, documents and other files alongside a related record. However, databases are limited to 2GB so you can forget about using Access to store movies, music and other hefty files.

An attachment field can hold as many files as you want, so it can be used as an all-purpose container for extra bits of information. If you have a table of employees, you could associate a photo, CV or other items.

Simplified security

Great databases use code, and code can do bad things. Previous versions of Access handled buggy code by popping up a stream of warning messages that users had to click through every time they opened a database.

Access 2007 uses a simpler approach. When you open a database, the program quietly disables all potentially unsafe macro actions and code. A slim security message then appears at the top of the window, informing you that your database has been restricted. You can switch your code back on with a couple of clicks or place your database in a folder designated as a trusted location. After this you won't see an unnecessary security warning again.

Forms and reports

Designing data-entry forms and reports in Access can be a bit tedious. To get the exact arrangement of information you want, you have to drag each piece of information to the right place individually. Access 2007 improves this situation dramatically with a feature called layouts, which keeps information together in neat columns or tables.

Layouts are a dream to work with because Access includes a new Wysiwyg (what you see is what you get) form and report designer. Using these tools, you can apply formatting and see the results immediately - something previous versions of Access were crying out for.

Microsoft Access 2007 Expert Verdict »

500MHz processor
Windows XP with Service Pack 2, or Vista
2GB hard disk space
1,024x768 resolution monitor
  • Ease of Use: We give this item 8 of 10 for ease of use
  • Features: We give this item 9 of 10 for features
  • Value for Money: We give this item 8 of 10 for value for money
  • Overall: We give this item 8 of 10 overall

Access 2007 is a solid revision for long-time users and a tempting choice for anyone who needs to manage a large amount of information in a desktop environment.

  • LibreOffice 3.5 review

    LibreOffice 3.5

    LibreOffice 3.5, the latest version of the open source productivity suite, brings better Office interoperability and improved user experience, but some rough edges remain.

  • Microsoft Office 2007: the definitive review

    Microsoft Office 2007: the definitive

    Windows Vista may be taking the headlines, but Office 2007 is an equally ambitious revamp by Microsoft. We've tested its features and compared the suite with free alternatives.

  • FileMaker Pro 9.0

    FileMaker Pro 9.0

    Serious FileMaker developers, database and network admins, and managers who worry about tying different piles of company data together are going to be the big beneficiaries of major improvements in the latest update to the FileMaker family of products.

  • Serif WebPlus X2 review

    Serif WebPlus X2

    Serif WebPlus X2 is a feature-packed website-authoring tool that won't break your budget - but does it come up to scratch?

  • NetObjects Fusion 9.0

    NetObjects Fusion 9.0

    Fusion has long had a reputation as a sophisticated application that can produce competent results but is easy to use. It provides plenty of wizards and a wealth of tools to control some pretty advanced features for your site.

IDG UK Sites

LG G4 launch live! LG G4 launch live blog - What to expect from the LG G4 launch, LG G4 launch...

IDG UK Sites

Apple Watch release day: Twitter reacts

IDG UK Sites

QuarkXPress 2015 released: the DTP tool gets a speed boost and long-document tools

IDG UK Sites

Apple Watch buying guide, price list & where to buy today: Which Apple Watch model, size, material,?......