MICROSOFT ACCESS TRAINING: BUILDING ACCESS LABEL REPORTS

Continuing with the Microsoft Access training 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 (Visual Basic for Application) 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];.
On the ribbon bar under the Create tab, click the Labels icon (Reports section) to start the Label wizard.
Microsoft Access Training
You will need to know either the stationary code for your labels (or other pre-defined paper size) or customise the dimensions if it is not standard.
I’m going to use Avery – product number: L7668 which has three columns.
Click the Next > button.
Step 2: In the next screen, you set the format for your text appearance:
Microsoft Access Training
I have changed the font size to 10 and increased the font weight to normal.
You can change this later in the design view mode.
Click the Next >button.
Step 3: In this step, you set by plotting the fields from the source file and position into the white interactive ‘Prototype label’ based on the dimensions of the selected product sheet.
Microsoft Access Training
You can have more than one field on the same line if desired or click in the space below (next invisible row) and then append the next field.
I’m going to add the full address (excluding Country) along with the Company Name and Contact Name.
Note: The ‘Prototype label’ white box should reflect the dimensions of the selected product number. If you realised that it is not the right size, use the < Back button twice and to re-select again. Click the Next >button.
Step 4: This screen is very basic and allows you to select one or more fields to sort by if you had neglected to do this in a Query or you have based your source directly on a Table then it will be more useful.
Choose the sort options by selecting a field to append (left pane to the right pane).
I’m not going to sort here (has been dealt with in my query).
Click the Next > button.
Step 5: This is the final step where you name your new report and then either run it or go straight to the design view to modify it further.
I’ve called my report UK Customers Labels and then clicked on the Finish button.
Microsoft Access Training
If you close the preview mode, you move into the design time view and here like with any report, change the properties (using the Property Sheet window) and other tools from the ‘Report Design Tools’ tabs on the ribbon bar.
Microsoft Access Training
Close and save the report.
More details - https://accessdatabasetutorial.com/microsoft-access-tutorial/

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