New for Access 2002

New for Access 2002

An Access project does not contain any data; it's a file that contains code-based database objects stored in a SQL Server database.

Access 2002 has several new features that make it even easier to view and share information from a databas 23123q161x e. These features include:

PivotTable and PivotChart views.   If you're already familiar with PivotTable and PivotChart reports in Microsoft Excel, you'll be happy to know that they are now available in Access 2002. With PivotTable and PivotChart views, you can dynamically change the types of data that you can compare and analyze in a chart or table format.

Compatibility with Access 2000.   You can work with and modify Access 2000 files in Access 2002 without converting the file format.

New keyboard commands in Access 2002 include: F8, in form or report Design view, displays the field list. ENTER, after selecting a field in the field list in form or report Design view, automatically adds the field to the form or report design surface. CTRL+TAB moves the focus from a form or report section to a subsection.

Conversion error logging.   If you encounter problems when converting from Access 95 and other versions prior to Access 2000, Access 2002 will create a table that lists information about each error, making it much easier to identify and solve problems.

Multiple undo and redo.   You can now undo or redo multiple actions in Design view in all objects (such as tables, queries, and reports) in your Access databases.

XML support.   You can easily import and export XML data between Access databases and other databases, such as Microsoft SQL ServerT.

Extended property support with Microsoft SQL Server 2000.   Integration of Access 2002 and SQL Server 2000 includes support for extended SQL database properties from within an Access project. Using extended properties makes it easy to save column widths, row heights, and fonts from one Access project to another. You can also use extended properties to migrate your education data applications from Access databases to Access projects connected to SQL Server.

Improved accessibility features.   There are new keyboard commands. In addition, two powers (1,000 percent and 500 percent) have been added to the Zoom option in Print Preview.