MICROSOFT ACCESS TRAINING: BUILDING ACCESS LABEL REPORTS

Continuing with the Microsoft Access VBA programming series, building Access label reports is pretty straight forward (especially with the built-in wizard tool).
As a snapshot and quick peek into my Microsoft access database eBook, here’s some more information to help establish your options.
This type of report can be used for printing label address information to fit a pre-defined or custom defined label sheet (normally an adhesive or plain paper sheet). It can be based on a Table, Query or another external data source altogether (i.e. Excel or Outlook).
It can also be used for creating badges, product labels, category name cards and other simple types of data layout reports.
Some users will use Microsoft Word’s Mail Merge feature instead of the basic Access Label report where data from an Microsoft access database can support other Office applications.
If you are going to take advantage of the ‘one-stop’ solution, then keeping it all within the Microsoft access  database environment makes sense and therefore the Label report option will be your way forward.

There are three ways to produce such a report:

1. Using the Label report wizard tool – quick and essay to use.
2. Building a Label report from scratch – requires a plan and time.
3. Using Microsoft access database VBA code to dynamically generate your Label report – the most effective but some programming is required.
This article covers just the first one as we have already shown you how to build Microsoft access database report and therefore you can extrapolate this information should you wish to attempt one.
The third option requires some VBA (Microsoft Access VBA programming) code knowledge and is outside the scope of this guide.
In any case, the first option is the simplest and quickest way to proceed and is highly recommended. You can always then tweak it in design view mode giving you full design control.
Step 1: Make sure you have identified the source for your report; a Table or Query and select the object in the Navigation Pane (but do not open it).
I’m going to locate all my ‘UK’ customers and therefore will use a simple query first which I’ve called qry_Customers_UK.

SQL for my query:

SELECT Customers.[Customer ID], Customers.[Company Name], Customers.[Contact Name], Customers.[Contact Title], Customers.Address, Customers.City, Customers.Region, Customers.[Postal Code], Customers.Country FROM Customers WHERE (((Customers.Country)=”uk”)) ORDER BY Customers.[Company Name];.

34 Edgwarebury Lane,Edgware,Middlesex,HA88LW,UK

Comments

Post a Comment

Popular posts from this blog

Microsoft Access Queries: An Action Query

Image
You use this type of query to change data in tables, saving the need to manually edit records or use any of the manual tools namely,  Find  and Replace . Examples for this action could be to reset data, change prices, increase volume and correct data migration and population issues. One of the more commonly used examples is to carry out some sort of calculation and change prices for a range of products. The above example increases all products for UK suppliers by 10% using the  [Unit Price]  field containing the original price value multiplied by 1.1 (an increase by 110%). Just remember, this is an action query which means changes to any data values cannot be reversed once actioned which is why you should normally see a warning first. However, it is always a good idea to take a copy or back up of your data files before running  Microsoft Access VBA programming  of this nature. There are many other types of queries too and the more you know about Access queries, the more f
Read more

How To Run Microsoft Access On A Mac PC Using CrossOver Software – Alternative Options

Image
Firstly, let’s clarify that Microsoft Office for Mac does not include the  microsoft access database  application which is why we have to take such steps. The alternatives and work around could include: 1.  Using the free runtime version for an exectuable file only or a third party web app which is now available for the iPad so you can load Access as a viewer only should you need to just read information. 2.  Installing VMWare (or similar) which is a virtual image software tool that creates a separate instance on your Mac PC and therefore can have several versions as a quick way to restore a default environment. However, it will require you having a licenced copy of Microsoft Windows operating system whereas CrossOver has this already included 3.  Using some sort of remote access software like LogMeIn or SplashTop (which there is a free version. There are others too but the two mentioned I have used are very effective indeed but will require a live internet connection to a
Read more

Microsoft Access Tutorial: Creating A Many-To-Many Relationship

Image
Microsoft access tutorial In a relational database, a many-to-many relationship exists when a record in one table can be referenced by one or more records in another table and vice versa. You need to have two or more tables to create relationships. To link these tables, you will have to create another table (a third) which will be your interceding or junction table. Here are the steps again in creating a third table: 1.  Go to the Create tab. 2.  Click on Table Design. A new table will be opened. 3.  Create two fields (plus any additional supporting fields). NOTE:  The two key fields are going to be the primary keys from the two tables that you have created which are in effect known as secondary or foreign keys (duplicates OK). To identify the primary key from a table: Click on the existing table and select View on the upper left corner of MS Access. You can identify the primary key when you click on one of the fields and see the Primary Key button, right next to the
Read more