Consolidating data in access Live free chat with fat girls

(Full information on some of these methods can be found on the Excel Tips site: .) The other option is to forego Excel and place your data in a real database program, such as Access.

There you can do many types of processing—just as you can with an SQL database—in order to create views of information (queries) that can be used as the source data for a Word mail merge.

By Karen Knox Do you have a database full of names and addresses that you want to use as mailing labels?

Have you tried to do this in Access, only to discover it is a cumbersome process, especially when you want to modify the labels?

First, create your Select Query with any necessary filter criteria. You will be prompted to indicate what table you want to add records to.