how to create labels using a microsoft access data file? · pdf filehow to create labels using...

Brother QL Label Printer tips produced by Brother International Corporation USA pg.1

How to create labels using a Microsoft Access data file?

Step 1. a) Open a new layout. b) Select the size of the label.


Step 2. The next step is to open the Access file containing the data you wish to put onto the label. In the menu bar, click on “File”; go down to “Database” and select “Connect”.


Step 3. Locate the Access data file in the “Open Database” dialogue box and then click “Open”.


Step 4. In the “Select Database Editing Mode” dialogue box, select “Connect as read only.” or “Connect to original file and allow editing.” and then click “OK”.

After clinking OK the selected Access file will open up in the P-touch Editor.


Step 5. Connect the fields (Jointing the fields) that you wish to go onto the label. By connecting the fields together this will allow us to have one format for all the connected fields; the text on the label will be uniform. This does not change the columns of the database. If you do not connect the fields, each field can have individual format (font type, font size, font style, etc.). a) Click on a record on the database table.

Please note: The options in the menu bar have changed. b) In the menu bar, click on “Database” and select “Connect Fields”.


Step 6. In the “Define Joined Fields” dialogue box, click “Add”.

Step 7. a) Select the first field you want on the layout. b) Click “Add”.


Step 8. a) Select your next field and click “Add”. Please note: You can use spaces, “,”, and “Enter” to arrange the fields. For example, put a space between “First Name” and “Last Name”. After “Last Name” press the “Enter” key to go to the next line to add the “Company” field. b) Continue adding all fields you desire on the label.

Step 9.

Click “OK” when you are finish adding all the fields you desire.


Step 10. After clicking OK the “Define Joined Fields” dialogue box will appear with the fields you have selected. Next click “Close”.

Step 11. In the menu bar, click on “Database” and select “Merge into Layout”.


Step 12. a) In the “Merge Fields” dialogue box, select the “Jointed Fields”. b) For “Merge Type” select “Text”. c) Click “OK”.

Step 13. After clicking OK an image of a record appears on the layout. Click on the line border around the image, eight boxes will appear on the border. At this point you can click on one of the boxes, keep the mouse button down and move it to resize the border.


Step 14. Add a POSTNET barcode to the layout.

a) Click on a record on the database table. b) In the menu bar, click on “Database” and select “Merge into

Layout”.


Step 15. a) In the “Merge Fields” dialogue box, select “Zip”. b) For “Merge Type” select “Bar Code”. c) Click “OK”.


Step 16. After clicking “OK” a barcode appear on the layout. It may not be the correct barcode type. To change the barcode type:

a) Click on the barcode on the layout. b) Click on the “Properties” icon .


Step 17. a) In the “Bar Code Properties” dialogue box, click on the “Protocol”

tap. b) Select the “POSTNET” protocol. c) Click “OK”.


Step 18. After clicking OK it will bring you back to the P-touch Editor window. In this view, you can reposition the barcode on the layout. Click on it, do not release the button and move the mouse with the button held down.


Step 19. Save the layout, click on “File” in the menu bar and select “Save”.


Step 20. a) In the “Save” dialogue box, for “File name:” type in a name for the new

layout. b) In “Save as type:” select “Layout File (*.lbl)”. c) Click “Save”. Please note: Once you saved the layout, whenever you open the saved layout, it will also open the Access database file.


Step 21. To print, click on “File” in the menu bar and select “Print”.

Step 22. In the “Print” dialogue box, select the “Print Range” and click “Print”.

how to create labels using a microsoft access data file? · pdf filehow to create labels using...

Documents