Microsoft Access 2002 [OLD VERSION]

by Microsoft

Product Details

• Shipping Weight: 7.2 ounces
• Shipping: Currently, item can be shipped only within the U.S. and to APO/FPO addresses. For APO/FPO shipments, please check with the manufacturer regarding warranty and support issues.
• ASIN: B00005B0BZ
• Item model number: 077-02012
• Date first available at Amazon.com: March 30, 2001
• Average Customer Review: 4.2 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #6,666 in Software (See Top 100 in Software)
  • #46 in Software > Business & Office > Database
• Discontinued by manufacturer: Yes

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

Product Description

Microsoft Access 2002. Whether you are creating a database for personal use, departmental use, or an entire organization, Microsoft Access 2002 offers a set of tools rich enough for the most experienced database developer, yet accessible enough for first-time users. By incorporating the innovations of Office XP, as well as introducing productivity and collaboration features such as the Data Access Page Designer and XML support, Access 2002 helps you store, organize, and share your data, so you and your team can make better decisions.

See all Product Description

Customer Reviews

Most Helpful Customer Reviews

24 of 24 people found the following review helpful:

4.0 out of 5 stars Great Windows product; many ease of use enhancements., April 26, 2002

By 

Randall L. Golden "randy_golden" (Woodstock, Georgia USA) - See all my reviews
(REAL NAME)   

This review is from: Microsoft Access 2002 [OLD VERSION] (CD-ROM)

Let's face it: as a cross-platform tool or large system database Access won't cut it as it comes out of the box, but if you are looking for something to create a pretty cool application for a windows platform, Access can't be beat. The database is flawless, string manipulation is easy, and designing the GUI is a breeze if you have done your up-front work (like giving the fields a meaningful text description).

The latest version, Access 2002 comes with improved wizards that are actually helpful. I created a small application in a day with just this product and the help text. It did not require much code (4 navigation macros that anyone with basic programing skills could write). We also flawlessly moved this application to a Windows 2000 server running IIS for an intranet.

Don't expect the best response time from Access 2002. A web query through what is called a "data access" page takes about 30 seconds on a 200,000 record file on a server with half a gig of memory and no other applications running.

Some of the other ease of use enhancements are better button control and improved macro coding, easier navigation throughout the product and improved help text with step by step procedures on how to create specific examples.

24 of 31 people found the following review helpful:

4.0 out of 5 stars Improved Application, April 28, 2001

By 

Andre Da Costa "A.Da Costa" (Jamaica W.I.) - See all my reviews

This review is from: Microsoft Access 2002 [OLD VERSION] (CD-ROM)

Improves PivotTable and PivotChart support; adds multilevel undo and redo in Data Access Page; increases keyboard shortcuts; provides better support for multilingual databases. In Access 2002, Microsoft has updated the file format yet again, sure to causee graning among the Access 97 faithful. But Access 2002 can open and modify Access 2000 databases without applying the new file format, which is a small concession at best. Access 2002 interacts with the new SQL Server 2000 Desktop Engine (formerly MSDE) for creating more scalable apllications and supports two-way XML support.

7 of 8 people found the following review helpful:

5.0 out of 5 stars Excellent for entry level, front end systems, April 16, 2003

By 

Mithu Singh (Calgary, AB Canada) - See all my reviews

This review is from: Microsoft Access 2002 [OLD VERSION] (CD-ROM)

This is an excellent entry level database for Windows platforms - very flexible and easy to learn. Also, this makes for one of the best front-end applications for Oracle, MySQL, SQL Server, etc. Microsoft's continued improvements in VBA in Access allow you to create very powerful data entry and data management solutions.