- Norton 360 2013--only £24.99 when you spend £30 or more. Spend £30 or more at Amazon.co.uk and you can get Norton 360 2013 - 1 User 3 PCs for just £24.99 when you enter the promo code 'NRTN2013' at checkout. Here's how (terms and conditions apply).
- Visit the Microsoft Office Resource Centre for all the information you need.
System Requirements
What Other Items Do Customers Buy After Viewing This Item?
Product details
Would you like to update product info or give feedback on images?
|
Product Description
Product Description
Microsoft Access 2010 is all about simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as your data grows.
 |
 Access 2010 empowers you to make the most of your information--even if you're not a database expert. Click to enlarge. |
 The enhanced Expression Builder greatly simplifies your formulas and expressions with IntelliSense. Click to enlarge. |
 Conditional formatting now supports data bars and you can now manage your conditional formatting rules from a single intuitive view. Click to enlarge. |
Access 2010 empowers you to make the most of your information--even if you're not a database expert. And, through newly added Web databases, Access amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.1
Build databases faster and easier than before
Forget the learning curve. Out-of-the box templates and reusable components make Access 2010 a fast and simple database solution.
- Get started in just a few clicks. Find new built-in templates you can start using without customisation, or select templates from Office.com and customise them to meet your needs.
- Build your databases with new modular components using new Application Parts and add prebuilt Access components for common tasks to your database in a few simple clicks.
Create more impactful forms and reports
Access 2010 brings you the innovative tools you'd expect from Microsoft Office to help you easily create professional, informative forms and reports.
- Conditional formatting now supports data bars and you can now manage your conditional formatting rules from a single intuitive view.
- The addition of Office themes in Access 2010 gives you the ability to coordinate numerous database objects in just a couple clicks and makes formatting a breeze.
Get easier access to the right tools at the right time
Locate the commands you need when you want them and where you want them.
- Easily customise the improved Ribbon to make the commands you need most accessible. Create custom tabs or even customise built-in tabs. With Access 2010, you're in control.
- Manage your database and obtain a faster, more direct route to your database tools from the new Microsoft Office Backstage view. The Backstage view replaces the traditional File menu in all Office 2010 applications to provide a centralised, organised space to manage your database and customise your Access experience.
Add automation and complex expressions without writing a line of code
Access 2010 empowers you to be your own developer by bringing you simplified and easy-to-use tools--even if you consider yourself a database novice.
- The enhanced Expression Builder greatly simplifies your formulas and expressions with IntelliSense. Reduce errors and spend more time focusing on building your database.
- With the revamped Macro Designer, it's now even easier for you to add basic logic to your database. If you're an experienced Access user, you'll find the enhancements are more intuitive for creating complex logic and enable you to extend your database application
Get a centralised landing pad for your data
Access 2010 offers easy ways to bring your data together and increase work quality.
- Include Web Services and Microsoft SharePoint 2010 Business Connectivity Services data right in the applications you build. You can now connect to data sources via newly added Web Service protocol.2
- Import and link data from a broad range of other external sources such as Microsoft Excel, Microsoft SQL Server, Microsoft Outlook, and more. Or, collect and update your data via e-mail--no server required.
Access your database in new ways
Newly added Access Services on Microsoft SharePoint Server 2010 enables you to make your databases available on the Web with new Web databases.
- Start collaborating right away. Post your databases online and then access, view, and edit them from the Web. Users without an Access client can open Web forms and reports via a browser and their changes are automatically synchronised.
Whether you're a large corporation, small-business owner, nonprofit organisation, or if you're just looking for more efficient ways to manage your personal information, Access 2010 makes it easier to get what you need done more quickly, with more flexibility, and with better results.
1 This feature requires Microsoft SharePoint Server 2010 to publish and share a Web database.
2 Support for Microsoft SharePoint 2010 Business Connectivity Services is configured in SharePoint Server 2010.
Customer Reviews
Most Helpful Customer Reviews
18 of 18 people found the following review helpful
By J. White
Format:Software|Amazon Verified Purchase
I purchased Access 2010 after difficulties with a competing database. Access was so easy to use that, within 8 hours, the original database was entirely reassembled in it. The trick is to export the original tables of data as spreadsheets (or as CSV text files), then import them into Access and finally check the field types (whether numbers, decimal points, text, and so on). The queries and reports had to be manually recreated in Access, but this problem was trivial with the Wizards. The only problem that I had at any stage was the tedious task of getting the formatting (ie, the layout) of the reports just right.
Access 2010 is remarkably slick and easy in operation. The program often anticipates what you are going to do - for example, automatically linking the correct fields of three tables for my relational database.
I was surprised by some of the criticism of this product that I have read elsewhere. One reviewer gave it two stars because she damaged the DVD trying to get it out of the wrapping. I had no such trouble, and in any case the packaging tells you how to contact Microsoft in order to obtain a replacement for a damaged DVD. Others have complained that the product is a download, or that you need to link to the Internet to activate the product. I have received a DVD, devoid of any instruction manual, which was installed onto a computer that, for security reasons, is not connected to the Internet. No problem, the product supplies you with a free telephone number to dial, with a lengthy string of characters to type in, and an automated registration system provides the correct activation code over the phone. Just write it down (you can replay missed sections of code.)
Others have criticised Access 2010 on the grounds of being difficult to use. It is unquestionably true that *any* relational database is a formidable challenge for a first-time user, but Access is the easiest I have encountered. Anyone who is not familiar with relational databases should buy an explanatory text book, several written specifically for Access 2010 are available from Amazon. Again, Access 2010 includes Microsoft's new Ribbon menu system. Tedious to navigate, if you have not encountered it before, but familiar to any user of Word or Excel since their 2007 versions.
I had some difficulty with (optional) coding with the Visual Basic supplied with Access, since it took a while to understand the concepts of database access in VB, but all became clear within a few hours of perseverance. At long last, Microsoft seems to have grasped a key concept for its Help files, that one worked example is worth a thousand words of verbiage, most of which used to read like a description of alien plants in a Martian orchard. If you look up 'recordset', for example, you get three short examples of worked code. Simple from there.
The only disappointment for me has been the inability to connect/import from an old Access database which used the now-obsolete `Jet' database driver. Access 2010 is also not suitable for organisations that handle large amounts of data (limit of 2 GBytes data and 255-byte restrictions on some field-sizes, according to the Help file which tells how to connect to external databases.)
Access 2010 is remarkably slick and easy in operation. The program often anticipates what you are going to do - for example, automatically linking the correct fields of three tables for my relational database.
I was surprised by some of the criticism of this product that I have read elsewhere. One reviewer gave it two stars because she damaged the DVD trying to get it out of the wrapping. I had no such trouble, and in any case the packaging tells you how to contact Microsoft in order to obtain a replacement for a damaged DVD. Others have complained that the product is a download, or that you need to link to the Internet to activate the product. I have received a DVD, devoid of any instruction manual, which was installed onto a computer that, for security reasons, is not connected to the Internet. No problem, the product supplies you with a free telephone number to dial, with a lengthy string of characters to type in, and an automated registration system provides the correct activation code over the phone. Just write it down (you can replay missed sections of code.)
Others have criticised Access 2010 on the grounds of being difficult to use. It is unquestionably true that *any* relational database is a formidable challenge for a first-time user, but Access is the easiest I have encountered. Anyone who is not familiar with relational databases should buy an explanatory text book, several written specifically for Access 2010 are available from Amazon. Again, Access 2010 includes Microsoft's new Ribbon menu system. Tedious to navigate, if you have not encountered it before, but familiar to any user of Word or Excel since their 2007 versions.
I had some difficulty with (optional) coding with the Visual Basic supplied with Access, since it took a while to understand the concepts of database access in VB, but all became clear within a few hours of perseverance. At long last, Microsoft seems to have grasped a key concept for its Help files, that one worked example is worth a thousand words of verbiage, most of which used to read like a description of alien plants in a Martian orchard. If you look up 'recordset', for example, you get three short examples of worked code. Simple from there.
The only disappointment for me has been the inability to connect/import from an old Access database which used the now-obsolete `Jet' database driver. Access 2010 is also not suitable for organisations that handle large amounts of data (limit of 2 GBytes data and 255-byte restrictions on some field-sizes, according to the Help file which tells how to connect to external databases.)
17 of 17 people found the following review helpful
A Kid's Review
Format:Software
I purchased Office 2010 Professional, which included Access. It is brilliant - very easy to use with the new Ribbon interface. However, if you are moving to 2010 from 2003 or before, be warned. It is very different.
If you are going to buy other Office 2010 programs, go for the suites - it saves money. Though buying Office 2010 Home and Student and Outlook separately is cheaper than buying Office 2010 Home and Business, which just adds Outlook...
Microsoft Office 2010 Home and Student, 3 Users (PC DVD)
Microsoft Office 2010 Home and Business, 1 User (PC DVD)
Microsoft Office 2010 Professional, 1 User (PC DVD)
Microsoft Outlook 2010 (PC DVD)
If you are going to buy other Office 2010 programs, go for the suites - it saves money. Though buying Office 2010 Home and Student and Outlook separately is cheaper than buying Office 2010 Home and Business, which just adds Outlook...
Microsoft Office 2010 Home and Student, 3 Users (PC DVD)
Microsoft Office 2010 Home and Business, 1 User (PC DVD)
Microsoft Office 2010 Professional, 1 User (PC DVD)
Microsoft Outlook 2010 (PC DVD)
15 of 16 people found the following review helpful
By M. Short
Format:Software
I occasionally develop small Access apps as part of my work, extensively use Access as a tool for editing systems control/admin databases. I also make extensive use of ODBC connections to link to an IBM iSeries database.
All sorts of problems encountered.
*XML strings corrupted when editing.
*The very useful environ function (I know the arguments for and against using this!) no longer works in queries, unless you write a UDF in VBA. It used to just work!
*Problems restricting the UI and setting up custom menus.
*Solutions written in 2002/2003 need some hefty modifications in order to work. Backwards compatibility for older databases should be a given - and it's not!
Hmmm. Office 2002/2003 was pretty well the pinnacle of Microsoft's offering with most of the errors, blues screens of death from Office 1997/2000 fixed. Come on Microsoft, this is meant to be an improvement on the largely flawless Access 2002/2003!
It's taken some getting used to, but the problem I have is that there's also a lot I like about it, such as the new ACE database engine which replaces the older JET engine (Up to 2003). A mixed review on this one - not necessarily an improvement, just different.
All sorts of problems encountered.
*XML strings corrupted when editing.
*The very useful environ function (I know the arguments for and against using this!) no longer works in queries, unless you write a UDF in VBA. It used to just work!
*Problems restricting the UI and setting up custom menus.
*Solutions written in 2002/2003 need some hefty modifications in order to work. Backwards compatibility for older databases should be a given - and it's not!
Hmmm. Office 2002/2003 was pretty well the pinnacle of Microsoft's offering with most of the errors, blues screens of death from Office 1997/2000 fixed. Come on Microsoft, this is meant to be an improvement on the largely flawless Access 2002/2003!
It's taken some getting used to, but the problem I have is that there's also a lot I like about it, such as the new ACE database engine which replaces the older JET engine (Up to 2003). A mixed review on this one - not necessarily an improvement, just different.
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 63 reviews
3.7 out of 5 stars
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
4.0 out of 5 stars
What you'd expect
Straightforward, reliable software from Microsoft as always. No reason to look elsewhere for a database package. What more need be said? Read more
Published 26 days ago by Dorothy Taylor
1.0 out of 5 stars
Disappointed
After many attempts this item would not work on my computer therefore I am highly disappointed with this particular product.
Published 2 months ago by Mrs Lorna Kyle
5.0 out of 5 stars
Access 2010
Actually ordered 2003 version, was surprised to receive 2010 version, so thanks for that, working well at the moment, no complaints
Published 3 months ago by Ian Akers
5.0 out of 5 stars
MS Acess 2010
This was a good upgrade for me at a reasonable price. Loaded and works seamlessly.
I am very happy with this purchase.
I am very happy with this purchase.
Published 4 months ago by BriML
5.0 out of 5 stars
Pre Purchase Query
I am looking to purchase the stand alone version of Access 2010. Could someone please advise me is it single licence only or is it possible to install it on a desktop and... Read more
Published 5 months ago by Welsh_John
5.0 out of 5 stars
Easy to use
Access is now so well developed that it is easy to use and straightforwards to work with. As an I T professional I use access in many of my projects.
Published 5 months ago by Roy
5.0 out of 5 stars
MS Access works for me
What can I say. More features. Better mechanisms for selecting data. I love it. A tool for doing serious amounts of work.
Published 6 months ago by James Davidson
5.0 out of 5 stars
Possibly the best software purchase I've made :)
Much more easy and powerful than other end-user, desktop database applications. Can easily create forms, reports, etc. even programme macros and SQL statements.
Published 10 months ago by Linenfinity Ltd
5.0 out of 5 stars
Access
Everything you could ever want from a database program. Payment all went very smoothly. Arrived on time. All Good. I would not hesitate to buy in the future.
Published 14 months ago by Tonyinthedoghouse
3.0 out of 5 stars
Decent Upgrade from Access 2000, but...
I mainly bought this to stay current (Access 2000 is a bit long in the tooth now) but also hoped to get a better development environment. I am happy on both counts. Read more
Published 14 months ago by A. Ormston
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
Listmania!
|
|
