Access 2002

• Platform:   Windows 2000 / 98 / 95 / NT / Me
• Media: CD-ROM
• Item Quantity: 1

Access is a sophisticated database package that should please beginners and experienced users alike. The focus is increasingly on supporting data-driven Web sites--e-commerce operations with ever-growing customer lists spring to mind. And even non-programmers should find it simple to weave Web pages linked to both Access and SQL Server databases.

Data Access Pages allows you to save any form or report in HTML/XML format meaning that you can instantly transform any of your forms into Web pages. And analysis and presentation of data is simplified with the PivotTables and PivotCharts features. Simply drag the fields you want to analyse to the relevant area and they will be displayed as a table or chart. --John Rennie

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. Microsoft 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 Microsoft 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 Microsoft Access 2002 help businesses be more agile by enabling users to unlock the power of the organization's data. Using Microsoft 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.

Microsoft 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 Microsoft Access 2002, the database window was changed to accommodate the new objects exposed in Microsoft 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.

See all Product Description

• Software > Business & Office > Office Applications > Databases
• Software > Microsoft > Programming & Web Development
• Software > Programming & Web Development > Databases & Reporting > Access