How to create mailing address database in access

**Raghu_K** · 25-06-2009

I want to create mailing address in access database. Which will help me to while sending mail to my clients. Is any one know how to create mailing address database in access ?

Thanks

**Mateja** · 25-06-2009

By using the Database wizard you can create a database on your computer. Choose one of the built-in templates from wizard and customize it to some extent. Then it creates a set of tables, queries, forms, and reports, and also a switchboard for the database. The tables do not have any data in them.

**Bosko** · 25-06-2009

Start by creating a simple report that is formatted to look like a mailing label. The report gets the address data from the table or query that stores the addresses. Printing the report will give you a single label for each address in the underlying record source.

Use the Label Wizard to create the report. You can then customize the layout of the labels, or write Visual Basic for Applications (VBA) code to extend the report to meet your needs. The last step would be to preview the labels.

In the Database window , click Reports
Click New on the Database window toolbar.
In the New Report dialog box, click Label Wizard.
ShowIf the wizard doesn't start
Click the table or query that contains the data for the labels, and then click OK.
Follow the instructions in the wizard

**Zecho** · 25-06-2009

In ms access you can store your data (name, addresses, telephone numbers) rather than write them down on vulgar that augment the mass of your papers. With a database, you can organize your data according to your criteria. For example, organize your customers according to the amount of turnover on each client, the population of his hometown. You define the types of customers. For each table there is a standardization to avoid duplication, each has an identifier represented by the primary key that gives each a unique identifier. It can link a table (the table customers, for example) tables using the customer data (invoices, orders, types of customers). When it appears in other tables, the primary key of the Customers table, for example, is called foreign key, the host table with its own primary key.