Pocket Guide: MS Access Samples and Wizards from Microsoft

• Access 2003/2002/2000 Sample: Multiple Column Reports database The Multiple Column reports sample database for Microsoft Access contains sample reports that demonstrate creating telephone book style multiple column reports.
• Access 2003 Sample: Inside Out Sample Files This download contains sample files that accompany articles excerpted from the book Access 2003 Inside Out.
• Access 2003/2002/2000 Sample: Basing One Combo Box on Another Sample Database This sample database, for the Basing One Combo Box on Another column on Office Online, includes an example form that demonstrates how to limit what appears in one combo box based on the choice you make in another combo box.
• Access 2003/2002 Sample: Using Parameters with Queries and Reports Sample Database This sample Microsoft Access database provides example forms, queries, and reports that demonstrate using query parameters, as well as using a custom form to supply parameters to a query or report.
• Access 2000 Sample: Database of Sample Forms The Access 2000 Database of Sample Forms provides sample user forms that demonstrate how to perform a wide variety of tasks such as bringing a subtotal from a sub form to a form, and how to disable command bar items.
• Access 2003 Sample: Using Automation with Access and Outlook This download provides a sample Access file for use with the MSDN article "Using Automation in Microsoft Office Access 2003 to Work with Microsoft Office Outlook 2003."
• Access 2003/2002/2000 Sample: On time and how much has elapsed Use this sample database file to learn how to calculate elapsed time.
• Access 2000 Sample: Query Topics The Access 2000 Sample: Query Topics database contains examples of useful database queries, including crosstab, union, and join queries.
• Access 2000 Sample: Report Topics The Access 2000 Sample: Report Topics database contains sample reports that demonstrate how to perform a variety of reporting tasks.
• Access 2003 Sample: Animating Microsoft Office Access 2003 Learn different methods of animating Microsoft Office Access 2003. These include using the Animation ActiveX control, the Timer control, and animating the Office assistant.
• Access 2003 Sample: Performing Mail-Merges Using XML Data Learn how to perform a mail merge programmatically from Microsoft Office Access 2003 using an external XML data file and the Mail Merge feature of Microsoft Office Word 2003.
• New XML Features in Access 2003 Sample Use these files to learn how to import, export, and transform XML data programmatically into Access.
• Access 2002 Add-In: Security Manager The Microsoft Access 2002 Security Manager enables the database-security administrator to make knowledgeable security decisions as the database and its workgroup evolve.
• Access 2000 Add-In: Security Manager The Microsoft Access 2000 Security Manager enables the database-security administrator to make knowledgeable security decisions as the database and its workgroup evolve.
• Office 2003 Sample: XMLCase Study (Contoso)Learn how to create an XML solution using applications from the Microsoft Office System in the context of a pharmaceutical company.
• Access 2002 Sample File: Design Databases with Forms and Excel Learn how to use Excel to create prototypes of your Access databases with this sample spreadsheet.
• Access 2002 Sample File: Design Databases with Forms and Excel Learn how to use Excel to create prototypes of your Access databases with this sample spreadsheet.
• Access Workflow Designer Call-Tracking Sample Team Solution This sample is provided in conjunction with the MSDN Library article, "Microsoft® Access Workflow Designer Call-Tracking Sample Team Solution.
• Microsoft Jet SQL for Access 2000 - Sample 1 These three downloadable samples are provided in conjunction with a series of MSDN Library articles that discuss how to use Microsoft® Jet SQL with data from an Access 2000 database.
• Microsoft Jet SQL for Access 2000 Sample 2 These three downloadable samples are provided in conjunction with a series of MSDN Library articles that discuss how to use Microsoft® Jet SQL with data from an Access 2000 database.
• Microsoft Jet SQL for Access 2000 - Sample 3 These three downloadable samples are provided in conjunction with a series of MSDN Library articles that discuss how to use Microsoft® Jet SQL with data from an Access 2000 database.
• Northwind Traders Direct Sample Application Northwind Traders Direct is a simple e-commerce application that uses data access pages, frames, and cookies. It was created using Microsoft® FrontPage® 2000 and Microsoft Access 2000.
• Using ADO with the Microsoft Jet Provider Sample Provides a guide to revising code that uses Microsoft Data Access Objects (DAO) into code that uses Microsoft ActiveX Data Objects (ADO), as well as a guide to writing new code using ADO with the Microsoft Jet Provider.
• Access 2002: Create Dynamic Reports in Access Sample Files Sample files for use with the article Create Dynamic Reports in Access Using Linked Tables.
• Access 2002 Update: Additional Help Files This downloadable file contains the most current Microsoft Access 2002 Help files and replaces the existing ones.
• Access 2002 Add-in: Expanded Help File Access 2002 online Help with pre-expanded content for screen readers.
• Access 2000 and SQL Server 2000 Readiness Update The Access 2000 and SQL Server 2000 Readiness Update improves the way in which Microsoft Access 2000 works with Microsoft SQL Server 2000.
• Access 97 White Paper: Internet Replication
• Access 97 Internet ActiveX Sample Database
• Access 2.0 Sample Database Containing 19 Modules of Access Basic Code
• Access 7.0 Sample Database Containing 19 Modules of Visual Basic for Applications Code (Neatcode.exe) Neatcode.mdb is a Microsoft Access for Windows 95 version 7.0 sample database that contains 19 sample modules of Visual Basic for Applications code. Topics include complex math, statistics, OLE Automation, data access objects, and more.
• Access 7.0 Add-in: Replica to Regular Database Wizard (Wzrplrgl.exe) This file contains an add-in for Microsoft Access 95 that enables you to convert the Design Master database from a replica set to its original, nonreplicated state.
• Access 97 Add-in: Replica to Regular Database Wizard (Wzrprg97.exe) This file contains an add-in for Microsoft Access 97 that enables you to convert the Design Master database from a replica set to its original, nonreplicated state.
• Access 7.0 White Paper: Porting 16-bit Applications to 32-bit Versions (Accport.exe) The Accport.exe file contains a document which discusses how to port 16-bit Microsoft Office applications (with code written in the Microsoft Excel macro language (XLM), WordBasic, Visual Basic for Applications, or Access Basic) to 32-bit versions for use in Windows 95 and Windows NT.
• Access 97 Knowledge Base Help Files Knowlege Base (KB) Help file containing all KB articles for Microsoft Access 97 published on or prior to April 18, 1997.
• Access 97 Document: Conversion White Paper Contains a Microsoft Word document called "Microsoft Access 97 Conversion White Paper." This document contains a discussion on potential issues arising from the conversion of Microsoft Access version 1.x, 2.0, and 7.0 databases to Microsoft Access 97.
• Access 7.0 Viewable Wizard Code: WzTool70.mda (wztool70.exe) In the retail version of Microsoft Access for Windows 95 version 7.0, you can't view the Visual Basic for Applications code for wizards. This file contains a special version of the wizard that has viewable wizard code for developers to use as a learning tool.
• Access 97 Treeview Control Wizard (WzTreevw.exe) The WzTreevw.mde file is a Treeview Control Wizard for Microsoft Access 97. When you insert a Treeview Control on your form with this wizard installed, the wizard will guide you through configuring the Treeview Control.
• Excel 5.0 DLL Files for Developers To Access Excel 5.0c: Xlodbc.xla and Xlodbc.dll (Xlodbc.exe) These files are made available to allow third-party developers quick and easy access to these files in the event that they do not have access to the full version of Microsoft Excel version 5.0c.
• Excel 2000 Help File: Running Excel 4.0 Macros Download the complete Help file for the Microsoft Excel 4.0 macro functions (XLM macro functions). You can then access this information from the Office Assistant when you use these functions in Microsoft Excel 2000.
• Import and Link Exchange/Outlook Wizards for Access 97 Use the Import Exchange/Outlook Wizard or the Link Exchange/Outlook Wizard to import or link a Microsoft Exchange or Microsoft Outlook folder or address book to a Microsoft Access table.
• Partial Replica Wizard for Access 97 With the Partial Replica Wizard, you can create a partial replica without programming. Specify a filter expression for a table, and the wizard sets the Data Access Objects (DAO) properties and uses the DAO methods for you.
• Access 2000 Tutorial: Northwind Traders Sample Database You can use the Northwind Traders sample database as a tool to help you learn Access 2000. Experiment with the data stored in Northwind, and use the forms, reports, and other database objects as models for your own database.
• Access 97 Relationship Print Wizard In response to a long-standing request from our developers, Microsoft® Access proudly presents the Print Relationships Wizard.