نسخه access97-نسخهaccess2000or xp

Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views, stored procedures, functions, and forms. You can now perform data analysis and build rich PivotTable and PivotChart view solutions more quickly than ever before. PivotTable and PivotChart views can be saved as data access pages that can be viewed by anyone who has Microsoft Internet Explorer 5 or later. You can also use subforms in PivotTable and PivotChart views in exactly the same fashion that they are used with forms in Datasheet view today. Developers will also find it easy to write code behind forms in PivotTable and PivotChart views and take advantage of new events available in PivotTable and PivotChart views.

XML Support

In addition to being the standard technology for interchanging data on the Web, Extensible Markup Language (XML) is quickly becoming the preferred technology for exchanging data between business software applications. Microsoft Access 2002 provides powerful, intuitive ways of sharing XML data regardless of differences in the platform, data format, protocol, schema, or business rules. By using Access' familiar user interface, you can easily create XML data or schema documents from Jet or SQL Server structures and data. You can also use XML data from other applications in your forms, reports and data access pages. For example, suppose your data is scattered across a wide variety of sources — internal SQL servers, Excel spreadsheets, and other data providers like SAP. Since these sources use XML as their data interchange format, you could create a series of aggregation queries in Access to pull this data into views and then design forms and reports by using those views.

Access also provides methods for easily controlling your data by making it simple to create and apply schemas and style sheets. Access allows you to easily describe and deliver rich, structured XML data to and from any application in a standard, consistent way. For example, you can use Access to create a schema that describes the structure of your data and then send the schema to your vendors so that they know exactly how to expect your data to appear in their invoices.

Extended Property Support with Microsoft SQL Server 2000

The built-in integration between Microsoft Access 2002 and Microsoft SQL Server 2000 has improved significantly by the inclusion of support for extended SQL database properties from within your Access project. By using extended properties in your Access 2002 projects, you can implement such features as lookup relationships, validation rules (also called constraints), text formatting, and subdatasheets. You can use extended properties with tables, views, stored procedures, and functions, just like you can with similar objects in Access data files. Using extended properties makes it easy to save column widths, row heights, fonts, and input mask settings from one Access project session to another. Extended properties make it even easier to migrate your business applications from Access databases to Access projects connected to Microsoft SQL Server.

More new features in Access

Round-tripping

You can now work with and modify Access 2000 files in Access 2002 without converting the file format. This allows you to easily share different versions of database files with other Access users.

Multiple Undo and Redo

You now have the ability to undo and redo multiple actions in Design view in all objects in your Microsoft Access databases and in views, stored procedures, and functions in your Microsoft Access project.

Batch Updates in Access Projects using Microsoft SQL Server

You can now have Access 2002 projects batch all data entry and send it to the server when the user navigates from a record, closes a form, or selects a command. You can also create a button on your form that saves all records or undoes all changes to records, programmatically.

Updateable Off-line Data Access Pages

You can now take the data access pages in your Access project offline, make changes to them on your laptop, and have them automatically synchronize when you reconnect to the SQL server. Changes to the off-line pages are made to an Access project connected to a local Microsoft SQL Server 2000 Desktop Engine (formerly MSDE).

Conversion Error Logging

If problems are encountered when converting from Access 95 and later versions, Access 2002 will now create a table that lists information about each error, making it much easier to identify and solve problems.

Subforms/Subreports that Live in Design view

You can now open subforms or subreports in their own Design view window directly from within the form or report or from the View menu. Scrolling has also been improved so that it is easier to work with subforms and subreports in Design view.

Password Security in an Access Project

You can now change the logon password specified in an Access project connected to a Microsoft SQL Server 6.5 or later version database directly from within your Access 2002 menu.

The Linked Table Wizard

The Linked Table Wizard guides you through the process of linking your tables to a SQL Server database, and does this all from within your Access project.

Improved Support for International Complex-scripts

Access 2002 now exposes complex-script interface items easily, which means that with a simple click, you can switch the reading direction from left-to-right to right-to-left in language-specific objects.

Improved Accessibility Features

Access 2002 now provides even greater ease in working with forms and reports.

Pressing F8 in form or report Design will now display the field list.

Pressing ENTER after selecting a field in the field list in form or report Design view will automatically add the field to the form or report design surface.

Pressing CTRL+TAB will move the focus from a form or report section to a subsection.

Two additional powers (1000% and 500%) have been added to the Zoom option in print preview.