Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 

Microsoft Access 2007 (PC)

by Microsoft Software
Windows Vista / XP
2.5 out of 5 stars  See all reviews (4 customer reviews)

Available from these sellers.


  • Easily add and organize information with only minimal training using database templates
  • Create simple, easy-to-understand reports with one click
  • Filter, sort and group data easier using improved tools
  • Open large databases faster with improved file formats
There is a newer version of this item:
Microsoft Access 2013, Licence Card, 1 User (PC) Microsoft Access 2013, Licence Card, 1 User (PC) 3.9 out of 5 stars (13)
£81.75
In stock.

Customers Who Viewed This Item Also Viewed


System Requirements

  • Platform:   Windows Vista / XP
  • Media: CD-ROM
  • Item Quantity: 1

What Other Items Do Customers Buy After Viewing This Item?


Product details

  • Item Weight: 259 g
  • Delivery Destinations: Visit the Delivery Destinations Help page to see where this item can be delivered.
  • ASIN: B000HCVR12
  • Release Date: 30 Jan 2007
  • Average Customer Review: 2.5 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 2,202 in Software (See Top 100 in Software)

Product Description

Manufacturer's Description

With its improved interface and interactive design capabilities that do not require deep database knowledge, Microsoft Access 2007 helps you track and report information with ease. Get started quickly with pre-built applications that you can modify or adapt to changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Share information by moving your Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals.

Product Description

Office Access 2007 enables you to quickly track and report information with ease, using an improved interface and interactive design capabilities that do not require deep database knowledge. Get started easily using prebuilt database solutions-modify and adapt them to your changing business needs. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information to facilitate more informed decision m

Customer Reviews

2.5 out of 5 stars
2.5 out of 5 stars
Most Helpful Customer Reviews
18 of 19 people found the following review helpful
3.0 out of 5 stars Access 2007 25 Mar 2009
Despite having spent the last 10 years building databases with MS Access, I found this version tricky to get to grips with and found that many of the features I used were not automatically on the ribbon but needed to be added manually. That's fine if you've used previous versions and know that those functions are there, but if you're not aware of them, you're not just going to come across them.

However being in the position of having to use it for work, I have now got to grips with it and like it and I found the new multi valued fields very useful, however like any other function they do need to be used appropriately but there are instances where I have found this to be a genuine benefit. I have also found that the forms and reports produced have a much 'cleaner' look to them and that I do like very much.

However some of the plus points in designing reports are sometimes minus points too. When you move/resize fields in a report, the label automatically moves/resizes with it, and I have found it very fiddly when I've wanted to move things independently which has been annoying, but I've got there.

Overall I still think Access is brilliant and after a couple months of frustration have grown to like the latest version, but for me I don't feel that the benefits warrant the expense of upgrading if you don't need to.
Was this review helpful to you?
15 of 17 people found the following review helpful
1.0 out of 5 stars Why did they spoil it ? 15 Feb 2009
From the manufacturer's description:

"With its improved interface and interactive design capabilities that do not require deep database knowledge ... "

The terms "improved" and "interactive" clearly have a broad definition. The Access 2007 interface is actually intrusive and unintuitive. The core of a great product is still there (see Access 2003) but I can't see many persevering long enough to find out. Oh yes, there is also a new feature (multivalued fields) which controversially breaks a critical database design rule.

After a bit of time with the new Excel 2007 interface, you realise it works, but why oh why did they then apply it to everything else in the Office suite.

Don't buy or upgrade unless you have to.

Five stars for the best PC database product, minus 4 for a truly awful interface and multivalued fields.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
1.0 out of 5 stars Damn awful! Just stick with Access 2003 17 April 2011
I am a prolific user of MS Access with VBA with 15 years programming experience. I've been through all the versions since Access 97/2000/2003, and know them inside out. I am at pains to finally admit after extensive use of 2007 that the graphical front-end on this piece of dung is absolutely awful!

Microsoft have (as usual) gone a step backwards by reducing the customisability of the object views. To make matters worse, where it was extremely easy to set the options of the database to hide all the menu bars, navigation bars etc, they have now made that task incredibly difficult too. You have to create new system hidden tables with 'XML ribbons' to hide the usual navi-bars to get you DB to look like a regular app. Migrating existing 2000/03 databases will also give you new nightmares. A lot of old VBA functions don't work, and your database will be ridden with bugs upon migration from an older version - like sub-forms that become uneditable Read-Only for no reason if created previously in pre-2003.

Also gone are the regular text menu bars in place with these wacky looking graphical icons. All the regular features have been shuffled around and I can't tell what's gone where.

I hate Access 2007 and hate Microsoft for their regular conventional screw ups. Microsoft's HQ's retarded logic dictates that you should create something good to start off with, then every 3 years ruin it step by step with worse versions.
Comment | 
Was this review helpful to you?
1 of 2 people found the following review helpful
5.0 out of 5 stars Great product for small businesses 10 Mar 2010
I've used a variety of database tools but for running a small business database app, you can't beat access for it's ease of use - hence the reason I stick with it. The fact that a free access 2007 runtime is available from Microsoft in the 2007 release and is great and a key financial factor for people running it on multiple desktops.

I upgraded from access XP. The new interface does take a bit of getting used to but the improved look and feel of the forms is so much better. Whether this is worth the money is debateable but as I mentioned above, the fact that you can simply purchase one copy for the developer might sway you.

Finally, just to comment on other people's comments. To mark a whole piece of software 2 out 5 because you can't get the packaging seems a little misleading to other buyers. I agree that it is annoying but let's be realisitic!
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.0 out of 5 stars  30 reviews
49 of 49 people found the following review helpful
3.0 out of 5 stars Access 2007 = Mixed Results 18 Aug 2008
By Richard Rost - Published on Amazon.com
I have been using Microsoft Access since the early 1990s, and I have been teaching it in the classroom and online for over a decade. I was a contract database developer for many years.

Access is one of my favorite programs. It has all the power that most people and small businesses need to create extraordinary databases, yet it's easy to use. You can be up and running with Access in just a few hours with the help of a good book or tutorial.

If you are new to Microsoft Access, and you have never used it before, you're going to LOVE Access 2007. The interface is clean. There are plenty of features, and you should have no problems navigating it - especially if you're familiar with the new interface in Word 2007 or Excel 2007.

If you have been using Access for a few years, and are used to previous versions, such as Access 2003 or XP, be ready for a new learning curve. It's going to take you a while to figure out where Microsoft put everything with the new "ribbon" menu system. Personally, I don't like it - but then again, I'm not used to it yet.

Do NOT purchase Access 2007 to upgrade your business database thinking it's going be a smooth, easy transition. Unless you have a few WEEKS to kill learning the new interface, upgrading your database, and ironing out the rough spots. Most of my databases upgraded without a hitch, but a few of them had VBA code that just wouldn't work in the new version.

DO purchase Access 2007 if you're new to Access, or you want to take the time to learn the new system, experiment with it, or build NEW databases. It is a wonderful program. I just wish that Microsoft would have kept those of us in mind who have been using their product for the past umpteen years before completely redesigning the interface.

Richard Rost
President
AccessLearningZone.com

Author of Microsoft Access 101 Video Tutorials & eBook

P.S. I've seen some other comments on here about using a "real" database like SQL Server or Oracle. Yes, I agree that Access doesn't have the most powerful database engine, but it's fine for 99% of small businesses. Plus, you can always upgrade later and keep your Access front-end attached to an SQL Server engine.
20 of 24 people found the following review helpful
4.0 out of 5 stars Good Product - takes time to get used to 30 Oct 2007
By Michael Bingle - Published on Amazon.com
I started using Access 2 in 1992. Before that I used DBASE, RBASE and Paradox. I didn't like Access and thought that RBASE was the best of the 4. However, as things go, Microsoft won and the others are dead, either entirely or mostly. So, I decided to stick with Access and have for the past 15 years.

Access is a good tool for many things and 2007 is a definate upgrade to 2002. However, getting used to it is a little bit of a challenge.

I've used access as a stand alone product or as a front-end to a DBMS like SQL Server so I could get a significant performance boost out of it.

I use it to manipulate data for data quality issues and for data exploration and dup checking. And, it works great.

I've also created some pretty complex and cost effective application with it over the years with lots of positive results.
26 of 32 people found the following review helpful
5.0 out of 5 stars Microsfot Access 2007 27 July 2007
By Albert E. Kremer Jr. - Published on Amazon.com
I upgraded from Access 2000, and noticed that I could no longer paste a Microsoft Word picture into an OLE Object field in my database. I searched Help for everything I could think of, but to no avail. So I took my computer to a repair shop and it cost me $50 to find out that I had to convert my datafiles to 2007 format. I think that Microsoft should have warned me to convert when I opened my datafiles for the first time.
7 of 7 people found the following review helpful
4.0 out of 5 stars Took me one day to upgrade from Access 97 15 Jun 2009
By keviny01 - Published on Amazon.com
My Access 97 backend/frontend database had over 700 objects and pretty complex reports and VBA code for an EDI translation application, so I was impressed when it only took me one afternoon to upgrade it to an Access 2007 database. First of all, after installing Access 2007, I downloaded and installed Office 2007 SP2 right way - I didn't even want to find out how an unpatched Microsoft product would behave. To upgrade an old database format, Access 2007 can automatically convert it for you to the new format, but you are likely going to have to do a few fixes yourself. The major caveats I encountered were:

* If you use DAO (data access objects) and try to add DAO to References in VBA, you can't - you will get a "Name conflicts with existing modules" error. Apparently, DAO is already built-in to Access, hence the "name conflicts" error when you try to add the DAO reference again. To make DAO work, change all "Dim r as Recordset" statements in your VBA code to "Dim r = DAO.Recordset". This can be easily done with find & replace.

* The "Cancel = True" statement in a BeforeUpdate event procedure causes "Property not found" error. Apparently, Cancel property no long exists in BeforeUpdate event even though the documentation says it does. The workaround is to replace "Cancel = True" with "Docmd.CancelEvent".

* The navigation pane in Access 2007 takes some getting used to. It shows all objects (table, queries, etc.) in one top-to-bottom list, so if you have hundreds of objects like I do, it can be a pain. It is always docked on the left side, and cannot be undocked. It spans from top to bottom, and its height cannot be adjusted, so it covers up major screen real estate. It can be collapsed or opened by pressing F11, but it is always on top of other windows. I hate to say it but this could be a deal-breaker for some people, in addition to the top ribbon bar that also annoys some users. Be sure to download a 30-day trial version of Access 2007 from Microsoft and try out the navigation pane yourself.

* If your Access 97 database has custom toolbars, Access 2007 will convert them also (!), but you won't be able to edit them as far as I can tell. The custom toolbars will be oddly placed under the "Add-ins" pull down menu. Clicking "Add-ins" will turn the entire ribbon bar into your custom toolbar(s). Another way is add your custom toolbars to the your "quick access toolbar" - go to Access options, Customize, All Commands, and find your custom toolbar name(s) to add. Again, I haven't found any way to edit custom toolbars, nor any way to create one in Access 2007.

* Compiling modules can sometimes crash Access 2007 - same thing can happen in Access 97. You just have to find the offending module(s) and recode or delete it/them.

Minor caveats:

* In the VBA window, you cannot compile individual module as in Access 97 - you must compile all modules in the database at once.

* In Datasheet view or Form view, if you press Ctrl-F to bring up the "Find" dialog, you won't see "Find first" like you do in Access 97. It is apparently gone. You can only "Find Next".

* Access 97 and 2007 can actually coexist; but opening Access 97 after you have installed Access 2007 will, for some reason, cause the Access 2007 reinstall dialog to come up the next time you open Access 2007.

* Not really a caveat, but in case you are too used to the unlimited installations of Office 97: You can only install Access 2007 on one PC with no hardware modifications, and you can only install on a different PC once every 120 days.
12 of 14 people found the following review helpful
5.0 out of 5 stars Acess -- not for the timid 24 Nov 2007
By Henry L. Green - Published on Amazon.com
This is an excellent program with a steep learning curve. You have to follow its rules exactly. Familiarity with the new ribbon interface is a must.

I found the book "Access, The Missing Manual" to be a big help.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
Access 2007 upgrade 0 30 Jan 2010
See all discussions...  
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
   


Look for similar items by category