- Platform: Windows NT / 98 / 2000 / Me / XP / 95
- Media: CD-ROM
- Item Quantity: 1
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
Amazon.com Review
Intended for use on the corporate intranet or over the Internet, Access 2002 is the latest version of Microsoft's popular database application. Designed to integrate with a variety of sources and viewers (including Web browsers), Access users can convert forms and reports into Web pages, and edit these Data Access Pages from within their browsers. Access 2002 now includes support for XML, the Extensible Markup Language standard, allowing users to export their databases to an XML document that can be viewed in any browser with HTML 4.0 support. XML support runs both ways: XML documents can also be imported into a Jet or SQL Server database.
With this new version, Access users can link Data Access Pages or other database files to SQL Server services without the need to perform any programming. In fact, many projects in Access can be handled with minimal or no coding required. A variety of helpful wizards walk you through the steps of creating different types of project databases.
Although it uses a new format for its database files, Access 2002 can open and edit Access 2000 files without converting them to the new format. Access 2002 also allows new databases to be saved in earlier Access formats, making them easier to share with users of earlier versions of Access. When converting older Access files to 2002, Access keeps track of any problems in an error log, making it easier to solve problems as they occur.
New features on the design side include expanded undo and redo functions, which let users move back and forth through more changes when creating reports, forms, and Data Access Pages. There are also a variety of new keyboard shortcuts, including ones that allow users to move easily from one view to another. Access 2002 also includes speech support for dictation and menu navigation via voice commands (with surprisingly high accuracy).
Database tables and charts can now be expressed using PivotChart and PivotTable, two new dynamic and interactive views, just by dragging fields to the appropriate area within Access or selecting the option from the View menu. PivotChart and PivotTable expressions can also be saved as Data Access Pages for viewing via the Web. Tables and charts can also be converted to an Excel spreadsheet format simply by dragging the information to Excel.
Microsoft Access 2002 isn't a leaps-and-bounds improvement over Access 2000. But the bevy of new features--including XML support, PivotChart and PivotTable views, and Data Access Page creation--make it an appealing upgrade for the database designer. --J. Curtis
Amazon.com Product Description
Microsoft Access 2002 provides the tools to build solutions that integrate and leverage Internet standards to better allow for the sharing and presentation of data across the Internet and intranet. Access 2002 lets you integrate data sources across the enterprise. In an integrated application environment, business applications communicate seamlessly with one another. One of the key goals of Access 2002 is to provide an integrated application environment, which enables users to perform query and analysis of enterprise data sources from the familiar, easy-to-use Office interface. The new technologies and features of Access 2002 help businesses be more agile by enabling users to unlock the power of the organization's data. Using Access 2002, corporations can build data-driven business solutions quickly and deploy those applications into the environment that their end-users are using every day.
Access 2002 features conditional formatting, which provides support for negative and positive numbers, and values that can be expressed as less than, greater than, between, or equal to. In addition, users will be able to format based on user-defined functions. Based on the value, the user can set font, styles, banners, and colors. Name AutoCorrect automatically resolves the common side effects that occur when a user renames a database object. For example, when a user renames a field in a table, the change is automatically propagated to dependent objects such as queries and forms so the user can continue to work with the application. Convert databases to prior access version. Access users can now down-rev save a database into a previous version of Access, making it easier to share database files with users of different versions. In Access 2002, the database window was changed to accommodate the new objects exposed in Access 2002, enhancing usability and consistency with the new user interface metaphor used throughout Office XP. Subdatasheets provide a picture-in-picture view to focus on and edit related data all in the same window. Additionally, users can now export data from Microsoft Access to Microsoft Excel simply by dragging and dropping Access objects (tables, queries, etc.) from the database container to Microsoft Excel. This allows a fast way to export data into Excel quickly for further analysis.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
102 of 110 people found the following review helpful:
1.0 out of 5 stars
I wanted a refund after trying this product.,
By Stephanie Falcon (Los Angeles, CA United States) - See all my reviews
This review is from: Microsoft Access 2002 Upgrade [OLD VERSION] (CD-ROM)
Well I upgrade my Access 2000 to Access 2002. After entering in your product key it tells you it will only work for 50 days unless being activated by Microsoft. Ok, no big deal I did this via the internet. I had to reimage my PC recently due to it locking up and then it tells me it has already been registered on another PC and I need to call a number. Now this is irritating because I also like to use Access on a test machine of mine which tends to get reimaged a lot. Another problem is that I have to completely install Access 2000 before I install Access 2002. I know it's an upgrade, but if I ever need to reinstall why can't I simply use my old product key to enter to verify I had purchased the older version and not have to reinstall Access 2000?Now first of all there are not a lot of new features in Access 2002 and I've noticed the file sizes grow larger faster and I need to constantly recompact my database. Oh the product has a new look and it's a little prettier but it has no new "got to have it" features. Luckily one new feature is to save to the older versions of MS Access. I like to purchase my software but I feel like I'm being treated like a criminal by Microsoft and given a hassle. I've gone back to Access 2000 and next time I need a new database, it won't be Microsoft. Access 2002 is a big pain if you're upgrading and need to use on multiple machines.(Even if you only use one copy at a time like I do.)
42 of 44 people found the following review helpful:
3.0 out of 5 stars
Updated Review: MS Access 2002 (Room for Improvement),
By Andre Da Costa "A.Da Costa" (Jamaica W.I.) - See all my reviews
This review is from: Microsoft Access 2002 Upgrade [OLD VERSION] (CD-ROM)
Microsoft Access is one of the other core Office applications I use the most, but I'm a little frustrated when it comes to compatibility, Microsoft still has not gotten it right! They need to focus on consistency and not new features only (And there aren't many new features Access 2002 when it comes to the average user). One of my computers at home still uses Office 97 and I kept a copy of my music collection database in Access 97, in Access 2000 you were able to convert a 2000 database to 97 or vice-versa smoothly. In Access 2002 that feature has been giving me problems, when I convert a 2002 database to 97 it gets ruined. When I opened the converted database in 97 there is only one record (there should be 45 records in the table) in the database leaving me angry having to type back in every artiste data in Access 97 again! Don't think if you have the database in Access 2000 its smooth running all the way, it also gives minor and major problems converting with Access 2002. Now, if I had one little problem converting a database, think about the big business people who are keeping massive records of customers. Don't get me wrong, it's an easy to use application but I think it still has some jinx in it. Now Microsoft if only you would allow multiple installs in Office XP I would be able to upgrade that computer running Office 97. Please get it right!!!
15 of 17 people found the following review helpful:
1.0 out of 5 stars
Upgrade policy is too strict.,
By
This review is from: Microsoft Access 2002 Upgrade [OLD VERSION] (CD-ROM)
Microsoft is too bossy about their upgrade policies. I own Access 95, but the package says that I am not eligible for this upgrade. You have to have Access 97 or later in order to use this product.
Share your thoughts with other customers: Create your own review
|
|
