Using Your Data with Word and Excel
Access is designed to work well with other Microsoft Office programs. You can use Access with these programs to perform very powerful operations with your data. For example, you can use information in your Access tables with documents you have created in Word. Specifically, you can use Access and Word to create a mail merge that places the values stored in an Access table into appropriate locations within a Word form letter. In this way, you can quickly create a custom letter for each of your accounts.

---

Collecting and pasting multiple items
The Microsoft Office Clipboard allows you to collect text and graphic items from any number of Office documents or other programs and then paste them into any Office document. For example, you can copy some text from a Microsoft Word document, some data from Microsoft Excel, a bulleted list from Microsoft PowerPoint, some text from Microsoft FrontPage or Microsoft Internet Explorer and a datasheet from Microsoft Access, then switch back to Word and arrange any or all of the collected items in your Word document. Office Clipboard works with the standard Copy and Paste commands. Just copy an item to the Office Clipboard to add it to your collection, then paste it from the Office Clipboard into any Office document at any time. The collected items stay on the Office Clipboard until you exit Office.

---

How To Create a Microsoft Access Macro to Export Information to Excel or Word
End-users occasionally find it easier to work with Microsoft Excel or Word than Access if they need to perform calculations or add formatting. They may receive the data in raw format; however, once it is organized in Microsoft Access, they may need to perform additional data analysis in Excel or insert formatting available in Word.

---

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.

---

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.

---

Splash Screens in Microsoft Access
When Microsoft Access opens, the first object that opens up by default is the database window. Most of the time you would not like to give your users access the this window, so you can hide this and display your own form or switchboard. To enable you to show your own Microsoft Access form when the database opens you should create an unbound form and use the Access Start Up options to set this form to open up whenever the database is started.

---

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.

---

Operators and Operands
Microsoft Access and Microsoft Visual Basic are not case-sensitive. Therefore, any word we are going to use that involves a field, its name, and new words we will introduce in this section, whether written in uppercase, lowercase or a mix, as long as it is the same word, represents the same thing. Based on this, the words TRUE, True and true, as related to Microsoft Access, represent the same word. In the same way, if the words NULL, Null, and null are used in an expression, they represent the same thing.

---

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.

---

Four Things to Love About Microsoft Access 2007
For many years now, Microsoft Access has been one of the most popular of all desktop database programs. Along with its bigger cousin, Microsoft SQL, Microsoft Access has helped form the core of database development for many small, medium and large businesses, and with the new version, Microsoft Access 2007, on the horizon it is important for workers to learn about the new features and benefits of this new program. Those who have been using Access 2000, Access XP or Access 2003 will recognize much of the interface of Microsoft Access 2007, but there are some notable differences, and a new look as well. It is important for those considering upgrading to the new version to understand the unique features and benefits of the 2007 version of Microsoft Access.

---

Microsoft Access Custom Form Navigation
Customising Microsoft Access forms, adding your own menus and command buttons is part of creating a Microsoft Access database application and designing an Access graphical user interface. Microsoft Access forms can contain the built in Access navigation buttons and record counter, or you may wish to add your own.

---

Up to speed with the new Microsoft Office
When you open Microsoft Office Word 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, or Microsoft Office Access 2007, or when you create a new message in Microsoft Office Outlook 2007, you'll notice that the program window has changed. The old menu and toolbar design has been replaced. How do you use this rich, new design? Read on to find out - and to see how Microsoft Office has gotten simpler and better.

---

Importing a form from MS Word as an Access Report
I'm trying unsuccessfully to use a table form from MS Word in an MS Access report. I've tried copy and pasting, as well as converting the form to an image using Adobe Illustrator. The result is some sort of distortion of the original form that is unpredictable. Has anyone found an effecient way to do this. I'm attaching one of the forms I'm using from MS Word.

---

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.

---

Export data to Word
You can export data from your Microsoft Office Access 2007 database to a Microsoft Office Word 2007 document by using the Export Wizard. This article explains how to use the Export Wizard and how to save your export settings as a specification for later reuse. In this article * Exporting data to Word: the basics * Export data to Word * Understand how Access exports objects to Word

---

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.

---

Showing or Hiding Microsoft Access Subforms
You can hide or display a Microsoft Access subform in various ways, by using an event of the form or a form control, using a command button or using a toggle button. In many cases, your computer monitor's screen estate may be at a real premium, with many elements and form controls vying for position. In this case, the simplest and most convenient solution may be to hide objects or controls until they are required. This article shows a simple approach of hiding a Microsoft Access Sub Form if the object is not required.

---

Understanding the New Features of Microsoft Access 2007
Microsoft Office has long been one of the flagship products of the company, and the long awaited Microsoft Office 2007 product will soon be making its debut on the scene. From new versions of Word and Excel to an enhanced email and calendaring program, Microsoft Office 2007 has much to recommend it. Some of the most dramatic, and most welcome, changes have taken place within Microsoft Access 2007, and users of this powerful database program should begin to prepare for these changes before planning an upgrade.

---

AutoExec Macro in Microsoft Access
In Microsoft Access you can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file. You can also use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

---

Launch Microsoft Word from Access
How can I launch Microsoft Word from an Access 2003/XP/2000/97 database?

---

Text2Clipboard(), Clipboard2Text() - 32-bit
To collect data from an Access form for pasting to your your word processor, how about a double-click on the form's detail section? How to programmatically copy text to/from the Windows clipboard in a Microsoft Access database. For Access 95 and later.

---

Viewing a Live Web Page on Microsoft Access Form
With so many companies and individuals having presence on the internet, it is more likely that your customers could have their own web sites. If we build a Microsoft Access table that will store our Customer information, this table can easily save each Customers web site address in a single field that stores the URL. If we want to have immediate access to the web sites as you view your customer data in a Microsoft Access form, we can view it in a Web Browser control that we place on the form design.

---

Use a table or query as a mail-merge data source
You can create a mail merge operation by using the Microsoft Word Mail Merge Wizard. This wizard is also available from Microsoft Office Access 2007, and lets you set up a mail merge process that uses a table or query in an Access database as the data source for form letters, e-mail messages, mailing labels, envelopes, or directories. This topic explains how to start the Mail Merge Wizard from Access and create a direct link between a table or query and a Microsoft Office Word 2007 document. This topic covers the process for writing letters. For step-by-step information about how to set up a mail merge process, see Office Word 2007 Help.

---

How to create a User Login Form in Microsoft Access
In my Microsoft Access database I have a table of Users, each with a user name and password, and a login form set up. I want the user name and password entered into the login form to be compared against those stored in the Microsoft Access table. If a match is found the user is allowed to access to the system, if not the system should exit. Answer » The following details one procedure that could be applied to this scenario. There are many more approaches to this and also other areas that will need to be secured within your database environment. You should also look into Disabling/Enabling the Shift Bypass Key.

---

Microsoft Access 2000
Quick Start - Tables and Forms; Introduction to Queries; Parameter Queries; Introduction to Reports; Exporting from a Report to Word; Merging Access Data with Word Documents; Calculations using Field Data; Creating Field Totals (Avg, Sum, etc); Queries Based on Fields; Defining Relationships Between Tables; Setting Relationships Between Existing Tables; Compacting your Database

---

Microsoft Access Introduction
Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works. This tutorial will help you get started with Microsoft Access and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Access, or go to Microsoft's web site located at for further assistance.

---

Free MS Access Tutorials
In Microsoft Access you can create different views of data using a select query, create a form in Microsoft Access and use it to enter and edit records, re-organise records in datasheet view using sorts and filters, create tables in Microsoft Access 2000 and few hints and tips about designing your database table.

---

Microsoft Access Articles
Topics: Distributing a Microsoft Access Application, Creating a Resolution Independent Microsoft Access Application, Custom Menus, Toolbars and Pop-Up Menus, repair/recover a corrupt database, use DAO with Microsoft Access 2000 or higher, handling images with Microsoft Access.

---

Refresh or requery data
If you are using a Microsoft Access project, or a Microsoft Access database that's shared on a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Access updates the data you see at regular intervals. However, you can immediately display the most current data by refreshing the records.

---

Sending E-Mails from a Microsoft Access Form
Often, processes that are performed in Microsoft Access require that others be notified. The automation of E-Mails from a Microsoft Access Database Form is a prime example of this. This is particularly true when assigning individuals to specific duties/tasks, such as managing the relationship with a new customer or processing a helpdesk ticket. Because notification in most organizations means sending an email, the low-tech approach of creating and sending an email outside of your Microsoft Access database, especially if you are dealing with a high volume of notifications, can be incredibly inefficient and means the duplication of workload. Luckily these instances provide a classic opportunity to use technology to improve your productivity and in general make your job less aggravating. This article will demonstrate how to implement vb-code that will automate the sending of emails (via Outlook) from a Microsoft Access database. Because the authors experience with emailing notifications has involved a helpdesk, the objects in this database will have the most relevance for a helpdesk using Microsoft Access. However, once you understand the code and how to implement it, this capability can be adjusted to suit the needs of any Microsoft Access database system.

---

RunApp Macro Action
You can use the RunApp action to run a Microsoft Windows-based or MS-DOS-based application, such as Microsoft Office Excel 2007, Microsoft Office Word 2007, or Microsoft Office PowerPoint 2007, from within Microsoft Office Access 2007. For example, you may want to paste Excel spreadsheet data into your Access database.

---

Create a hyperlink
When you create a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) by using any of the following methods, Microsoft Access creates a label control on the form or report. Although hyperlinks in a report won't work when viewed in Access, the hyperlinks will work when you output the report to Microsoft Word, to Microsoft Excel, or to HTML.

---

Open a Microsoft Word document
How can I open a particular Microsoft Word document from an Access 2003/XP/2000/97 database?

---

Introduction to Microsoft Access
Microsoft Access is a computer application used to create and manage computer-based databases on desktop computers and/or on connected computers (a network). Microsoft Access can be used for personal information management (PIM), in a small business to organize and manage all data, or in an enterprise to communicate with servers. TOC: Microsoft Access Interface, Microsoft Access Database File, Overview of Database Objects, Microsoft Access Help.

---

Database Tutorial Using Microsoft Access
This tutorial is in .doc form (MS Word document).

---

Microsoft Access Tutorial
This tutorial consists of the following lessons: About Microsoft Access; Create a Database; Create a Table; Adding Data; Create a Form; Modify a Form; Create a Query; Modify a Query; Create a Macro; Convert Access Database to Excel; Microsoft Access versus SQL Server.

---

Hiding Microsoft Access Database Forms
I have a Microsoft Access form with four command buttons that display specific forms using the DoCmd.OpenForm action. I want to hide the main database switchboard form whenever one of the four buttons is clicked on and then restore the main form when the user closes the form opened by the command button.

---

Microsoft Access 2003
Microsoft Access is a development environment used to create computer databases for the Microsoft Windows family of operating systems. This site provides lessons, examples, and links on how to use and explore MS Access. We also provide some guidance on VBA, the programming language that ships with Microsoft Access.

---

Backing up an Access Database
If you're a Microsoft Office power user, you might be familiar with the encryption features of Word, PowerPoint and Excel. These programs all allow file owners to easily apply encryption. Unfortunately, Microsoft Access doesn't offer similar functionality, but it still has relatively powerful security functionality. In this article, we'll take a look at Microsoft Access user-level security, a feature that lets you specify the level of access to grant each individual user of your database.

---

Importing and Exporting XSD Data in Microsoft Office Access 2003
Microsoft Office Access 2003 introduces a feature that allows you to import an XSD document and create an XSD document on export. This article explains what an XML schema is, describes the XSD elements that Access supports, and describes the data type conversion during import and export. This article looked at how Access imports and exports XML and XSD data. It also described the data type conversions that occur during these operations. Using XSD documents aid in ensuring that your XML documents are valid documents and that you can successfully interchange data with other departments and organizations.

---