Jennings Roger. Using Microsoft Office Access 2003

Special Edition. – Que, 2004. – 1536 p.Getting Acquainted with Access 2003.
Access 2003 for Access 97 and 2000/2002 Users: What’s New.
Building a Simple Desktop and Web Application.
Navigating the Access User Interface.Learning the Fundamentals of Jet Databases.
Exploring Relational Database Theory and Practice.
Working with Jet Databases and Tables.
Entering, Editing, and Validating Jet Table Data.
Sorting, Finding, and Filtering Data.
Linking, Importing, and Exporting Data.Transforming Data with Queries and PivotTables.
Designing Queries for Jet Databases.
Understanding Jet Operators and Expressions.
Creating Multitable and Crosstab Queries.
Working with PivotTable and PivotChart Views.
Creating and Updating Jet Tables with Action Queries.Designing Forms and Reports
Creating and Using Access Forms.
Designing Custom Multitable Forms.
Working with Simple Reports and Mailing Labels.
Preparing Advanced Reports.
Adding Graphs, PivotCharts, and PivotTables.Upgrading to SQL Server Databases.
Linking Access Front-Ends to Jet and Client/Server Tables.
Exploring Access Data Projects and SQL Server 2000.
Moving from Jet Queries to Transact-SQL.
Upsizing Jet Applications to Access Data Projects.Publishing Data to Intranets and the Internet.
Exporting and Importing Data with XML.
Designing and Deploying Data Access Pages.
Converting Access Objects to Data Access Pages.
Integrating with InfoPath and SharePoint Services.Programming and Converting Access Applications.
Learning Visual Basic for Applications.
Handling Events with VBA 6.0.
Programming Combo and List Boxes.
Understanding Universal Data Access, OLE DB, and ADO.
Consuming and Providing XML Web Services.
Upgrading Access 97 and 2000/2002 Applications to Access 2003.
A Glossary.