- Platform: Windows NT / 98 / 2000 / Me / XP / 95
- Media: CD-ROM
- Item Quantity: 1
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.
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.)