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.)