Access 2003 provides a powerful set of tools that are sophisticated enough for professional developers, yet easy to learn for new users. Now everyone in your organization can create or use powerful database solutions that make organizing, accessing, and sharing information easier than ever.
Access and Use Information from Multiple Sources
Use information from a variety of formats and programs—all in a familiar interface.
- Incorporate a wide range of data sources. Access 2003 supports a variety of data formats, including Extensible Markup Language (XML), OLE, Open Database Connectivity (ODBC), and Microsoft Windows® SharePoint™ Services.
- Link business systems. Link tables so that you can access data from multiple databases at one time in Access 2003 forms, reports, and data access pages. Link tables from other Access databases, Microsoft Excel spreadsheets, ODBC data sources, Microsoft SQL Server™ databases, and other data sources.
- Get the most from your enterprise data. Incorporate Microsoft SQL Server-based data into your Access solutions. Use the Stored Procedure Designer to create and modify simple procedures stored in SQL Server without having to learn Transact-SQL
Depend on Access 2003
Reduce errors and get help when you need it.
- Give your forms a new look. Access 2003 supports themes from Microsoft Windows XP to give your forms a consistent design.
- View dependency information. Quickly find tables, queries, forms, or reports that depend on a particular database object.
- Help eliminate errors. The new error checking feature flags common errors in forms and reports, making testing and fixing errors faster. After errors are flagged, you are given options to correct the errors, saving time and helping you to create more accurate forms and reports.
- Update properties automatically. Change a field property in a table and all the forms or reports that have controls bound to it can be updated automatically.
- Analyze your information in powerful ways. Drag controls onto your Access form to create a Microsoft PivotTable® or Microsoft PivotChart® view, or a spreadsheet.
- Easily back up your information. In Access 2003, you can save a copy of the database you're working on to another location.
Share Information with Confidence
Design forms and reports that you can save and open in previous versions of Access, making it easier to share your information.
- Share information more efficiently. Export and import data, and link to lists on Windows SharePoint Services sites where other team members can access them. Building these sites requires Microsoft Windows Server™ 2003 running Windows SharePoint Services.
- Design Web pages using powerful tools. Publish forms and reports on the Web and bind your information to a record source to display, update, and work with data from your database.
- Use compatible file formats. Access 2003 uses Access 2000 as the default file format for new databases. Because Access version 2002 and Access 2000 can use and modify the same database, organizations can roll out Access 2003 while maintaining capability with existing Access users and solutions.