HomeSoftwareMicrosoft Access 2007 [OLD VERSION] |
|  | | | Customer Reviews: | | | Average Customer Review: ( 25 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
47 of 47 found the following review helpful:
 Access 2007 = Mixed Results Aug 18, 2008
By Richard Rost
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 found the following review helpful:
Good Product - takes time to get used to Oct 30, 2007
By Michael Bingle
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 found the following review helpful:
 Microsfot Access 2007 Jul 27, 2007
By Albert E. Kremer Jr.
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 found the following review helpful:
Took me one day to upgrade from Access 97 Jun 15, 2009
By keviny01
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 found the following review helpful:
Acess -- not for the timid Nov 24, 2007
By Henry L. Green
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.
See all 25 customer reviews on Amazon.com
|
| | |
|
|
![Microsoft Access 2007 [OLD VERSION]](http://ecx.images-amazon.com/images/I/41HVTNAWJBL._SL250_.jpg "Microsoft Access 2007 [OLD VERSION]")
