MS-Access and Mail Merge
When we talk about Address Labels, Form Letters, Mail Merge and so on, the name that comes into our mind is MS-Word, loaded with plenty of functions for the above tasks. It needs a database to provide source data for address labels, Form Letters etc. We can prepare a Table in Word Document and use it for Addresses or attach one from Microsoft Access or other database sources. Here, we are not going to use MS-Word for Address Labels, Form Letters and Mail Merge operations, we will do it in MS-Access. Yes, we will try Mail Merge too.

---

Access 2002
Microsoft Access is a relational database package that runs under Windows on microcomputers. This tutorial was prepared using Access 2002. Before using this tutorial, you should know the fundamentals of Microsoft Access and know how to use Windows. This tutorial teaches you some more-advanced Access skills you'll need to do database case studies. The tutorial concludes with a discussion of common Access problems and how to solve them.

---

Access 2002, How to disable mousewheel
Is there an easy way to disable the mousewheel, or change its functionality, within Access 2002 forms? I hate the way it scrolls through records, since most people are naturally inclined to use the wheel to scroll further down a document of form as they would in Word or Excel and are surprised that it behaves differently in Access. I have tried Mousehook.dll and it works, but I have to distribute an Access database to multiple users on multiple systems, and I don't want to distribute a dll and extra instructions with it--it needs to be as user-friendly and compact as possible. Is there any VBA code that will either disable its functionality or change it to a scroll-through procedure on a form?

---

Import an Access 95 database into an Access 2007 file
If you use an existing database in the Access 95 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). You can also import forms and reports that do not employ Microsoft Visual Basic for Applications (VBA) code. To import forms and reports that contain VBA code (and also modules), first convert your Access 95 database to the Access 2002 - 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000, and then use Access 2007 to convert that file to the Access 2007 file format. What do you want to do? * Import data from an Access 95 database * Convert an Access 95 database by using Access 2003, Access 2002, or Access 2000

---

MS access 2000
I am currently running xp professional with MS Access 2002. My problem is that I'm currently taking a class in MS Access 2000 and the requirement is that I must use MS Access 2000 not 2002. I don't want to spend big dollars on a a version of Access that's not current so what do I do? Any suggestions would greatly be appreciated.

---

Access 2002
Learn how to manage information efficiently and effectively with Access 2002. This 29-page chapter includes information about creating a database, filtering and querying data, and adding data through the Web. Create Microsoft PivotChart and Microsoft PivotTable dynamic views to analyze large quantities of data, and save these views as data access pages that can be viewed on the Web.

---

Microsoft Access 2002
New Perspectives on Microsoft. Access 2002 Tutorial. (ppt file format, install MS PowerPoint to view this tutorial).

---

ADO and DAO Library References in Access Databases
Access 2000 and 2002 do not include a reference, by default, to the DAO 3.6 Object Library. Instead, Microsoft has included the ADO 2.1 Object Library as the default library for data access in Access 2000 and 2002. This means that if you create a new database in Access 2000 or 2002 and then use VBA code which includes the commonly used Database object, the code will fail. The Database object is not the only object where this problem is likely to occur. TableDef, QueryDef, Workspace, User, Group, and Container objects, as well as their Collection objects, are also commonly used in VBA code to customize database applications. However, without a reference set to the DAO object library, any code that uses these objects will also fail. Microsoft finally listened to the screams of its customers on this issue, so the DAO library is returned to being a default checked reference in new databases created with Access 2003. By default, the DAO reference has a higher priority than the ADO library in Access 2003.

---

List of reserved words in Microsoft Access 97, 2002, 2002 and Access 2003
The following articles lists words and symbols that you should not use in field, object, and variable names because they are "reserved words."

---

Whats New In Access 2003
If you're upgrading from either Access 2000 or Access 2002 to Access 2003, you're in luckin most respects, Access 2003 looks and works almost the same as both Access 2000 and Access 2002.

---

Programming PivotTable Reports in Microsoft Access 2002
Discover the elements of a PivotTable report and learn how to programmatically build and manipulate PivotTable reports in Microsoft Access 2002. The event model for PivotTable reports will also be discussed. (29 printed pages)

---

Introduction to MS Access
All the information provided in this tutorial is based on MS Access 2002. (.doc file format, install MS Word to read this tutorial).

---

PivotTable Wizard: What's changed in Access 2002
The PivotTable Wizard in Access 2000 and earlier creates a form that allows you to rearrange row, column, and page fields to facilitate data analysis. The wizard in Access 2002 and later also creates a form that supports pivoting, but there are some fundamental differences in the way it works when compared to versions of Access 2000 or earlier.

---

Create mailing labels in Access
Microsoft Office Access 2007 gives you several different options for creating labels containing data stored in your Access tables. The simplest is to use the Label Wizard in Access to create and print your labels from a report you create. In addition, you can import data into Access from other sources, such as Microsoft Office Excel 2007 workbooks and Microsoft Office Outlook 2007 contact lists and "merge" that data or existing Access tables with a Microsoft Office Word 2007 document and then create and print labels from Word.

---

Import an Access 2.0 database into an Access 2007 file
If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). To import forms, reports, or modules into Office Access 2007, you must first convert the database by using an earlier version of Access, open the database in Access 2007, and then convert the database into the Access 2007 database format. The following sections in this article explain how to perform each of these tasks. What do you want to do? * Open an Access 2.0 database in Access 2007 * Import data from an Access 2.0 database * Convert an Access 2.0 database by using Access 2003, Access 2002, or Access 2000

---

Mail Merging Microsoft Access Data with a Word Document
We can use Microsoft Access data as the data source for a Microsoft Word Mail Merge document. The Access data can be used in exactly the way needed to create a personalised letter in Word. Often your database is going to be storing specific types of information; many times this information is going to be related to personal data such as names, addresses and other contact type information. If, for example, your personnel department were wanting to mail out information to each employee, they could print out information showing the employees names and addresses, and then re-key this information into a Microsoft Word document with the text of the letter.

---

Create Labels From Microsoft Access Reports
One of the most convenient Access features for many a user is automatically printing mailing labels from your database. The labels are really just a kind of report. These instructions apply to MS Access 97.

---

Understanding Relational Database Design
This tutorial show you how to plan and design a database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in Microsoft Access 2002.

---

Sort IP addresses in an Access database
This topic describes the procedure for sorting Internet Protocol (IP) addresses stored in a Microsoft Access database. If you work with IP addresses, you probably already know that it is not as straightforward as working with text or numbers. This is because an IP address is really a collection of four numeric values separated by a period (.), where each value is a number between 0 and 255.

---

Create labels from your database
Put your data to good use by creating standard-size and custom labels in Microsoft Office Access. After completing this course you will be able to: 1) Create standard labels with the Label Wizard. 2) Create custom labels with the Label Wizard. 3) Modify labels in Design view. (Microsoft Access 2003)

---

HXTT Password Recovery Tool for MS Access
HXTT Password Recovery for MS Access is a free toolkit for MS Access databases from 95, 97, 2000, XP, 2002, to 2003. MS Access uses underlying Jet Database Engine, which is used used in a variety of Microsoft products such as Money, Project, IIS, Exchange, and so on. That freeware can be used for those Jet database files too.

---

Design and Plan a Database with Access 2002
Before creating a database, it is very important to plan it carefully. You need to know what information the database will store and analyse how the information stored will be used. There are four steps in producing and using a database: -Define the tables in which to store the data. -Add data to the database - usually using a form. -Extract information from the database - using a filter or query. -Report - present the information in the database effectively.

---

Microsoft XML spreadsheet add-in for Access
You can now export your tables and queries from Access 2002 or later to Microsoft Excel 2002 or later by using the Microsoft XML Spreadsheet Add-in. This add-in provides an easy way for you to format your Access data to be recognized and used by Excel or any application that recognizes the XML Spreadsheet format. This article describes the difference between displaying an XML data file and an XML Spreadsheet file in Excel, as well as information about how to obtain, install, and use the add-in.

---

Free Access XP Tutorials
Microsoft Access is a powerful tool that you can use to create relational databases for storing and retrieving information. A relational database is an application that allows you to organize, manipulate, query and view your data, while building links between related topics. In the same way that a word processor helps you create a document, Access helps you create a database. A database is a collection of information relating to the same topic just like how a rolodex keeps a collection of names and addresses.

---

MS Access - Creating and Working with a Database
Stop typing lists of information in Microsoft Word or Excel! In this tutorial, you will learn how to create databases that can store names, addresses, and any other type of information that you can think of. You will be pleasantly surprised to find that creating a database isn't all that difficult. Microsoft Access even comes with a Database Wizard that takes you step by step through the process of creating a database.

---

What to do when you see file names instead of images in your Access database
I upgraded from Access 2000 or Access 2002 to Access 2003, and now instead of seeing images, I see file names. What's up?

---

Merge Access data with Word
ou can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data.

---

Change the default file format
When you create a new, blank database in Microsoft Office Access 2007, you are prompted to provide a name for the database file. By default, the file is given the ".accdb" extension - it is created in the Office Access 2007 format and is not readable by earlier versions of Access. In some cases, you may prefer to create files in an earlier Access format. In Office Access 2007, you have the option of creating files in either the Access 2000 format or the Access 2002-2003 format (both with the extension ".mdb"). Then, when you create a new database file, the resulting file is created in the earlier Access format and can be shared with others who use that version of Access. This can be helpful if you have upgraded to Office Access 2007 but you share files with others who have not.

---

Print Mailing Labels in Microsoft Access
One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.

---

Convert Microsoft Access Tables, Forms, and Reports
Several changes introduced by Microsoft Access 2002 might affect the behavior of your version 1.x or 2.0 applications. This tutorial provides more information about those changes.

---

Access 2003: Creating Labels
Learn how to create labels by using the information in your Access database This document offers some tips on understanding and creating relationships in Access 2003. (pdf file, install Acrobat Reader to read this tutorial)

---

Export addresses from Access to Word
You can start the merge operation from either Microsoft Access or Microsoft Word. If you are using Access, you can merge data in one of the two ways described in this article.

---

Convert a database to the Access 2007 file format
You can convert a database that was created by using Microsoft Office Access 2003, Access 2002, Access 2000, or Access 97 to the new Microsoft Office Access 2007 file format. You should use the new file format whenever possible because it supports new features, such as multivalued fields and attachments. However, a database in the new Access 2007 file format (.accdb) cannot be opened or linked to with earlier versions of Access, and the new format no longer supports replication or user-level security. If you need to use your Access 2007 database with earlier versions of Access, or if you need to use replication or user-level security, you must use a file format from an earlier version.

---

Analyzing data using Microsoft Access 2002
Whether you are recording grades for your students, tracking attendance, doing research, or evaluating survey data, you can make more sense of the information by analyzing it within a database program. Download this 15-page tutorial to learn how to make effective use of data.

---

How to Create Labels From Reports
Creating labels from an Access report is less time consuming that hand-addressing envelopes or cutting and pasting items from one program to another. To create your labels, follow these instructions.

---

Sort IP addresses in Access 2007
This topic describes the procedure for sorting Internet Protocol (IP) addresses stored in a Microsoft Office Access 2007 database.

---

Microsoft Access and Microsoft Word
Mail Merge: Mail merging allows you to use data on your database to create letters, labels, envelopes, and other documents that require external data originating from another document.

---

Splitting a Microsoft Access Database
One of the important decisions that must be made before a Microsoft Access Database can be distributed is the form that the database will assume after the deployment. In this article, it addresses the pros and cons of splitting the database, and implementing the Database Splitter to create a front and back end database.

---

Snapshot Viewer
If you use Access 2002 or later, you have an easier and cheaper alternative to distributing printed copies of your reports. You can simply create a snapshot of the report that users can view in the Snapshot Viewer.

---

Access to Word mailmerge, record IDs appearing instead of record labels
I have 2 tables in an MS Access database. One table (table01) contains a list of items while the other table (table02) contains other data with 1-6 of these items (from table01) associated with them. There is a relationship between these two tables. In Access, regardless of the form, report or query, everything is OK. However, when I use MS Word to do a mailmerge, everything is OK except the items from table01 appear as the ID numbers instead of the contents of the fields. Any suggestions on how to have the contents of the fields appear instead of the ID numbers?

---