Avery® DesignPro® User Guide
Legal Notices Copyright: Copyright © 2010 AVERY DENNISON CORPORATION. All Rights Reserved. No part of this document or the Software may be reproduced or transmitted in any form or by any means or translated into another language without the prior written consent of AVERY DENNISON CORPORATION. Certain digital image content © 1997-2007 Hemera Technologies, Inc. Other digital image content © 2001-2007 Avery Dennison Corporation. All Rights Reserved.
Images for any reason; (iv) rent, lease, sublicense, or lend the Images, or a copy thereof, to another person or legal entity (Customer may transfer all rights to use the Images to another person or legal entity, provided that Customer transfers all rights to the Software pursuant to Section 1 above); or (v) use any Images except as expressly permitted by this Agreement. 4.
10. U.S. GOVERNMENT RESTRICTED RIGHTS: The Software is provided with Restricted Rights. Use, duplication, or disclosure by the United States Government is subject to restrictions as set forth in subparagraph (c) (1) and (2) of the Commercial Computer Software-Restricted Rights at 48 CFR 52.227-19, as applicable. Manufacturer is Avery Dennison Corporation, 50 Pointe Drive, Brea, California 92821. 11.
iv DesignPro Legal Notices
Table of Contents Getting Started .............................................................................................. 1 Welcome to Avery DesignPro ............................................................................................. 1 DesignPro Features ............................................................................................................ 1 System Requirements ........................................................................................................
Start your design.........................................................................................21 How to create your design.................................................................................................21 Insert and format text ........................................................................................................21 Insert and format circular text ...........................................................................................22 Insert date and time .
Work with databases .................................................................................. 65 How to work with databases ............................................................................................. 65 Use databases in DesignPro ............................................................................................ 65 Create a new database ....................................................................................................
viii DesignPro Table of Contents
Chapter 1: Getting Started Welcome to Avery DesignPro Choose from over 2000 Avery Templates – more than any other software! DesignPro includes Avery Templates for your favorite Avery products and all the newest products. From creative cards and presentation materials to distinctive CD and mailing labels, DesignPro has everything you need. See the DesignPro online help for additional information about the features described in this guide, as well as information about several other DesignPro features.
System Requirements DesignPro 5.5 requires the following: Microsoft® Windows 7, VistaTM, Windows XP®, Windows 2000®, Windows Me®, Windows NT® 4.0 with Service Pack 6a or later, Windows 98® with Y2K update 2 or later • Internet Explorer 4.
administrators. The DesignPro CD may be required to access optional components. 5. Continue following the on-screen instructions to complete the installation. Note If the startup window does not automatically appear, start setup manually: 1. Select Start > Run from the Microsoft Windows taskbar. The Run dialog box appears. 2. Click Browse to locate your CD-ROM drive and click once to open it. 3. Double-click the Launch.exe file. The Run dialog box appears again. 4. Click OK to open the installer.
To prevent help from appearing each time you start DesignPro, select Tools > Options > General tab, and select the Bypass Help at Startup option. How to calibrate your print output The Calibrate Printer dialog box will appear the first time you start DesignPro. Click Yes to display the Print Output Calibration dialog box. The calibration steps are simple, and ensure that your design will print correctly on the Avery product. Each printer used with DesignPro should be calibrated separately.
User Registration To receive free Software Support, valuable updates and special offers, register on line at avery.com. Avery Support Avery provides a variety of product and software support services. Avery.com DesignPro includes templates for most Avery printable products. Check www.avery.com frequently for product updates, new templates and more. You can also find DesignPro Frequently Asked Questions, and Avery Software Support contact information on our Web site.
• How you tried to solve the problem. Visit avery.com for the Avery Software Support information in your country.
Chapter 2: Start your project How to use the Welcome Screen The Welcome Screen appears each time you start DesignPro and presents several options to help you start your project. Click Cancel to return to the Design screen without selecting an option. To return to the Welcome Screen at any time, select File > Welcome Screen . To prevent the Welcome Screen from appearing each time you start DesignPro, select Tools > Options > General tab, and select the Bypass Welcome Screen option.
Design from Scratch Select a blank Avery template and create your own design. Open Existing Project Select one of your previously saved projects. Visit www.avery.com/software Be sure to visit the software section of the Avery Web site. The Avery Web site offers great ideas on how to use Avery products. How to start your project Start your project from a pre-designed Avery Template, from a blank Avery template, from a previously saved project, or create a blank custom template.
2. Select a product category from the Format drop-down list. 3. To locate and select a template, type the product number in the Find Item Number field and click Find. 4. Select the item in the list and click OK or double-click the item. To open an existing project 1. From the Welcome Screen, select Open an Existing Project or from the Design screen, select File > Open . The Open dialog box appears. 2. Locate and select the previously saved DesignPro project on your computer.
10 Chapter 2 Start your project: How to start your project
Chapter 3: DesignPro Basics How to use the Design screen The Design screen contains your personal design area and tools. DesignPro provides powerful tools that allow you to create professional looking projects.
How templates are designed The template is the software layout for an Avery product. When the Design screen opens, your blank or pre-designed template is ready to design. The displayed template represents one label, card, divider, or sheet, depending on the product selected. Multiple panel products Some Avery product templates may contain more than one panel on the Master and product tabs.
How to use the Master and product tabs When you open a project, the Tab Bar below the work area contains a Master tab and one or more product tabs (Label 1, or Tab 1 through Tab 5, for example), depending on the template selected. The Tab Bar also contains navigation and command buttons. To use the Master tab The Master tab represents a master label or product panel (label, card, divider tab) and is bright red when active. The Master tab cannot be deleted or moved.
How to create identical and different labels You can create a set of identical labels or product panels, a set of labels or product panels with shared and different information, or a set of labels where each label contains different information. Note Items placed on the Master or Label tabs can only be edited from that specific tab. Identical labels or product panels To create identical labels or product panels, use the Master tab only.
Different labels or product panels To create different labels, add and design a tab for each different label or product panel. Do not use the Master tab. Create identical labels 1. To create a new project, select File > New > Project from Scratch . 2. In the Select Template dialog box, locate and select an Avery label product (for example, an address label), and then click OK. 3. To insert text, click Insert Text . Type your text.
6. Click the Label 2 tab. Click the Insert Text button again. Type the text for this label in the text box. This text will appear on Label 2 only. Add and design additional tabs that will have label-unique information. 7. Select File > Print . Select All Designed Labels. Under Number of Copies, select Sheets and enter 1 to create one sheet of all designed labels (Label tabs). Click Print Preview to view your project before printing. Create different labels 1.
Menus The DesignPro Menu Bar provides access to all tools and commands. Corresponding toolbar buttons or keyboard shortcuts appear next to the menu item. Toolbars Toolbars contain buttons for the most frequently used DesignPro commands. You can view Tool Tips for the buttons in a toolbar by placing the mouse pointer over a button without clicking it. The toolbars can be moved and repositioned. Navigation toolbar The Navigation toolbar contains the following buttons.
Standard toolbar The Standard toolbar contains the following commands. Zoom Redo Undo Paste Copy Cut Print Preview Print Save Open New Text toolbar The Text toolbar contains the following buttons.
Formatting toolbar The Formatting toolbar contains the following buttons.
Drawing toolbar The Drawing toolbar contains the following commands. Insert Date and Time Insert Serial Number Insert Bar Code Draw Polygon Draw Ellipse Draw Rectangle Draw Line Insert Circular Text Insert Text Select Database toolbar The Database toolbar contains the following commands.
Chapter 4: Start your design How to create your design You can insert and format text and circular text in a variety of font styles, sizes, and colors. Text can include symbols, database fields, in addition to date and time stamps. You can draw graphic lines and shapes. Your design can include images, including logos and clip art. You can generate serial numbers and create bar codes. You can link or embed objects using the Windows OLE (Object Linking and Embedding) feature.
To align text Top, Middle and Bottom alignments apply to all text in the box. Selected sections or paragraphs of text can be aligned individually to the Left, Center, or Right. If no paragraph is selected, all text in the box is aligned. 1. Select the text or click inside the text box to apply the alignment to all of the text. 2. Select Format > Alignment. Select Left , Center selected text or paragraph. Select Top , Middle placement of the entire text within the text box.
4. Change the Font, Font Size, Bold, Italic, and Font Color. 5. Click OK to insert the circular text. To format circular text 1. Select the circular text object and select Format > Circular Text or double-click the circular text object. The Edit Circular Text dialog box appears. 2. Make your changes. Text must be selected in the text field to apply any formatting changes. The alignment and flip attributes will be applied to all text. 3. Click OK to apply the changes.
2. Click inside a text box and position the cursor where the information is to be inserted. If a text box is not selected, one will automatically be created when the date/time is inserted. 3. Select Insert > Date and Time 4. Select a date/time Format from the list. 5. Select the Field option to insert a text field that will update automatically when a field is inserted, during printing, when opening the file and when View > Update Fields is selected. 6.
4. Select either the Numeric or Alphabetic serial number type. 5. Enter a Start Value, End Value and Increment number. Counting is always from the start value to the end value. 6. For numeric serial numbers, select Leading Zeros to display the number with leading zeroes. Enter the total Number of Spaces for the serial number. 7. Select the Current Serial Number Value option to save the serial number of the last label or product panel printed.
3. Click Reset and then click OK. Quick Tip Select and right-click a serial number field to access the Format Serial Number command. Insert images, logos, and clipart You can insert a graphic object containing an image, logo or clipart. The image must be in a graphic format supported by DesignPro. If the original size of the graphic object exceeds the size of the selected template, the image is automatically reduced to fit within the template.
To insert an image from the Clipart Gallery 1. Select Insert > Clipart Gallery 2. Select All Graphic Formats or select the specific type of file you want to insert. . The Clipart Gallery dialog box appears. 3. Click on the preview to select an image and click OK. The image is inserted in the design. Note If the clipart images were not installed to your hard drive, you will be prompted to insert the DesignPro installation CD when using the Clipart Gallery command.
3. Select File > Acquire > Acquire Image. The dialog box that appears will vary since this command uses the interface software provided by your device manufacturer. Capture and/ or select the image. 4. Close the dialog box. It may close automatically for some devices. The image is inserted in the design. Insert and create bar codes Create and print bar codes on your Avery product. DesignPro creates several bar code types. When DesignPro is installed, the default bar code type is set to Code 39.
• UPC-A • UPC-E • POSTNET To insert a bar code 1. Select the tab where you want to insert the bar code. To create identical bar codes on all labels or product panels, insert the bar code on the Master tab. 2. Select Insert > Bar Code 3. To create a pre-defined bar code object, left-click in the template. To create and size the object yourself, click where you want the bar code to begin, drag to draw a rectangle, and then release the mouse to complete the bar code object. 4.
8. Click OK. Quick Tip Right-click a bar code object and select Format Bar Code to open the Bar Code dialog box. To edit bar code content 1. Click in the bar code object. 2. Type the content you want. Rotated bar code objects temporarily rotate to horizontal orientation for easy editing. 3. Click outside of the object when finished. Rotated bar code objects return to the original position. To generate a bar code using a serial number 1. Click the Master tab to select it.
Chapter 5: Save and print your project Save and rename a project The first time you save a project, the Save As dialog box displays so that you can name your project. You can rename a saved project to leave the original project unaltered. If you close a project without saving it, all changes made since the last time you saved the project are lost. If you do not specify a folder, the file is stored in the default project folder.
How to print your project Print your project DesignPro prints professional looking projects using most laser and inkjet printers. You should calibrate your print output before starting the print process. Test print on a plain sheet of paper first. If you are printing multiple pages, begin by printing a single sheet. To check positioning, place the printed test sheet in front of the Avery product and hold them up to a light. Adjust your design as needed. General printing instructions are provided here.
• Click Setup to return to the Print dialog box to change the print settings. • Click Print to print your project. Print identical labels or product panels Print labels or product panels with an identical design. The easiest way to create identical labels or product panels is to design and print the Master tab only. Test print on a plain sheet of paper first. If you are printing multiple pages, begin by printing a single sheet.
Print different labels or product panels Print labels or product panels that are entirely different. To create different labels or product panels, design and print a tab for each specific label or product panel. Do not design or print the Master tab. Test print on a plain sheet of paper first. If you are printing multiple pages, begin by printing a single sheet. To check positioning, place the printed test sheet in front of the Avery product and hold them up to a light. Adjust your design as needed.
Before printing, review any special instructions included in the Avery product package, such as dry time. Also, review your printer literature to determine how to reinsert a sheet for twosided printing. Test print on a plain sheet of paper first. To print side one 1. On the Design screen, select the tab that contains the design for the first side of the product. 2. Select File > Print 3. Select your Printer from the drop-down list. 4.
Print Direct Print® Custom Dividers The easiest way to design and print a Direct Print® Custom Divider product is to start with one of the pre-designed Avery Templates. A pre-designed Direct Print® Custom Divider project has one product tab for each divider page (for example, 8-tab or 5-tab) and a tab for the Table of Contents page. If creating a divider project from scratch, be sure to add individual product tabs for each divider tab and one for the Table of Contents page.
Print to the edge of a product To successfully print to the edge of a product, the product must support printing to the edge and the design must overlap the template by at least .125" or .25" (or 3 mm to 6 mm). To support printing to the edge, products must have enough space between labels or product panels to allow for this overlap area.
6. For Number of Copies, select an option and type the number of Copies. For example, to print 20 labels, select How many of each? and type 20. To print 20 sheets of labels, select Sheets and type 20. 7. Click Options. The Print Options dialog box. 8. If the Clipping option was not automatically selected and a Bleeding for Clipping value was not entered, select the option and type at least .125" or .25" (or 3 mm to 6 mm). 9. Make any additional selections in the Print Options dialog box and click OK.
6. To display the field contents on the Master tab, select Database > Display Records. To print projects with database fields 1. Prepare your project as indicated above. 2. Select File > Print 3. Select your Printer from the drop-down list. 4. To check or change the printer settings, click Properties, change the settings, and then click OK. 5. For Selection, select Master to print the Master tab design. 6. For Number of Copies, How many of each? is selected by default.
10. Click Print Preview to view the project before printing. The Print Preview dialog box appears. • Click Close to return to the Design screen to adjust your design. • Click Setup to return to the Print dialog box to change the print settings or to change the Shrink to Fit options as discussed below. • Click Print to print your project. To change the Shrink to Fit settings 1. Prepare your project and enter the settings as indicated above. 2. Return to the Print dialog box. 3. Click Database.
Chapter 6: DesignPro Lessons Open a Microsoft Excel file and mail merge In this lesson, we will link a Microsoft Excel file in DesignPro and merge the data onto a label product. Review the General database tips to avoid common problems when opening an external database file. Step 1: Select a project and open a Microsoft Excel database in DesignPro 1. From the Design screen, select File > New > Project from Scratch 2. In the Select Template dialog box, locate and select a label product and click OK. .
3. Highlight a field name and click Insert. The field name is inserted in a text box. 4. Insert the remaining fields you want to add. Click Space, Tab, and New Line to add spaces, tabs or new lines to your field layout.
5. Click Close when finished inserting fields. 6. Resize the text box as needed. 7. Select and format the field text and add spaces or line breaks to finish creating the layout you want. 8. To view the merged database with the design, select Database > Display Records. Use the navigation buttons on the Database toolbar to view the individual records.
Note To disconnect the database from your project at any time, select Database > Deactivate.
Open and link a database using ODBC and mail merge In this lesson we will open and link a database created in another program using the ODBC filter on your computer. Once the database is opened, we will merge the data onto a label product. We will open a Microsoft Access database but the steps are similar for data files created in other programs. Dialog boxes discussed in this lesson may vary depending on your database program, the ODBC components, and your operating system.
Step 2: Open and link your database 1. Select Database > Open 2. Click Link Database. The Select Data Source dialog box appears. 3. Select the Machine Data Source tab. A data source list appears. 4. If you previously created a data source for your database, select it from the list, click OK and proceed to step 14. If you have not created a data source for your database, click New and continue with step 5. 46 . The Open Database dialog box appears.
5. In the Create New Data Source dialog box, select System Data Source, and then click Next. 6. Select the ODBC driver for the file type you want to open. In this lesson, we will select the Microsoft Access Driver (*.mdb) to connect a Microsoft Access database. Click Next. A summary of the settings appears. 7. Click Finish to confirm the settings. The ODBC Microsoft Access Setup dialog box appears. The dialog box that displays will vary depending on the ODBC driver you selected.
8. Define the details for the data source. Enter a name for your database in the Data Source Name field. For example, enter Customer Addresses. Note that some keywords are not permitted in database and table names, for example, “database” and “integer.” 9. Enter a description for your database in the Description field. 10. Click Select to connect your database file to the data source. 11. In the Select Database dialog box, navigate to your Microsoft Access *.mdb file and select it. Click OK.
2. Highlight a field name and click Insert. The field name is inserted in a text box. 3. Insert the remaining fields you want to add. Click Space, Tab, and New Line to add spaces, tabs or new lines to your field layout. 4. Click Close when finished inserting fields. 5. Resize the text box as needed. 6. Select and format the field text and add spaces or line breaks to finish creating the layout you want. 7. To view the merged database with the design, select Database > Display Records.
Customize a pre-designed greeting card DesignPro includes several pre-designed greeting card templates to help you customize and create professional looking card products. In this lesson, we will select a pre-designed greeting card template and customize it by replacing text and images on the front, back and inside of the card. Note Since two-sided products, such as greeting cards, have unique information on each tab, the Master tab is not used when designing these types of projects.
Step 2: Replace an image with a personal photo 1. To replace an image, click on the Front & Back tab to select it. 2. Double-click the image and the Replace Image dialog box appears or right-click the image and select the Replace Image command. 3. In the Replace Image dialog box, locate and select a personal photo on your computer (BMP, WMF, TIF, JPG, PCX, EPS, PCD, TGA, WPG, IMG are supported). Click OK. The photo automatically replaces the previous image. 4.
Step 4: Enhance the photo using the Effects Gallery 1. To enhance the photo appearance, click the photo and select Format > Effects Gallery available. 2. 52 or right-click the photo and select Effects Gallery. Several effects are In the Picture Adjust section under Image Effects, select one or more of the following: • Select Blur/Sharpen to adjust the sharpness and the blur intensities of the image. Make the adjustments with the slider control and then click Apply.
control and then click Apply. 3. When finished applying all adjustments, click OK. Step 5: Personalize the text 1. Click the Front & Back tab to select it. 2. Highlight the text you want to replace and type the new text. 3. Click the Inside Spread tab and use the same method to replace and format the text. Step 6: Preview your project 1. Click the tab you want to preview, Front & Back or Inside Spread. 2. Select File > Print 3. For Selection, select Current to print the current tab only. 4.
Create CD/DVD labels In this lesson, we will select a CD/DVD label template, add circular text, and insert a background image. Step 1: Select a template 1. Select File > New > Project from Scratch 2. In the Select Template dialog box, locate and select a CD/DVD label product and then click OK. . Step 2: Add circular text 1. 54 Click Insert Circular Text appears. to add circular text.
2. Type your text in the text entry field. 3. Select and format the text. The changes made in the dialog box are displayed in the work area. 4. To align the text along the bottom of the circle, click Flip Text down.
5. Move the text to the bottom of the circle. The Rotate Left button degree increments. Click this button four times. nudges text in 45 6. Click OK. The circular text is inserted and aligned along the bottom of the text object. 7. Adjust the circular text: • To resize the text and maintain proportions, hold down the Shift key, then click and drag one of the corner handles of the text box. • To move the text, click the object frame and drag to the new location.
3. With the image selected, select Format > Background > Set as Background . The image is moved to the background. Background objects created in this way cannot be selected or edited. They can only be deleted by selecting Format > Background > Delete Background. Note To create a background image that can be edited, use the Size to Template command. Select the image and click Size to Template . The image extends to the edge of the template.
Create Index Maker Clear Label Dividers In this lesson, we will select a 5-tab Index Maker Clear Label Divider product template and add text on the divider tabs. Tip Items placed on the Master or product tabs can only be edited from that specific tab. Step 1: Select a template 1. Select File > New > Project from Scratch 2. In the Select Template dialog box, locate and select a 5 tab Index Maker Clear Label Dividers product and then click OK. 58 .
Step 2: Add tabs and text 1. To add a new tab, right-click Tab 1 and select New Tab. Tab 2 is added. 2. Click Tab 1 to insert text on that tab. 3. Click Insert Text 4. Type your text. This text will appear on Tab 1 only. .
5. Click Tab 2 to insert text on that tab. 6. Click Insert Text 7. Type your text. This text will appear on Tab 2 only. 8. Add and design three additional product tabs to create a total of five different tabs - one for each of the tab dividers. again. Step 3: Preview your project 1. Select File > Print 2. For Selection, select All. 3. For Number of Copies, select Sheets and enter 1 to create one sheet of all designed labels. 4. Click Print Preview to view your project. 60 .
Create a Sign In this lesson, we will select a Sign product template, add text and replace graphics to create a sign. Step 1: Select a template 1. Select File > New > Pre-Designed Template 2. In the Select a Pre-Designed Template dialog box, select the Signs folder, and then locate and select a White Poster Board product. Click OK. . Step 2: Replace an image with another image 1. To replace an image, click the image to select it. 2.
Step 4: Preview your project 1. Select File > Print. 2. Under Print Selection, click an individual sheet to print only that sheet. Press the CTRL key to select multiple sheets. Note A selected sheet is white. The default setting is to print all the sheets unless otherwise indicated. 3. Under Copies enter the number of copies of the selected sheet to be printed. 4. Click Print Preview to view all the sheets of your sign.
Chapter 6 DesignPro Lessons: Create a Sign 63
64 Chapter 6 DesignPro Lessons: Create a Sign
Chapter 7: Work with databases How to work with databases You insert fields on the Master tab to merge information from a database. You can create a new database in DesignPro or link an existing database. You can browse and edit records in the database. You can sort and filter records to access specific database information. You can also insert images or create bar codes using database fields.
Create a new database The Create New Database wizard guides you through the process of creating a new database. The wizard provides three steps (1) create a new database, (2) create fields, and (3) add data to the fields. DesignPro databases are created in dBASE III file format (*.dbf). Once a new database is created, several features are available to help you edit and manage the data.
To add data and insert fields 1. Click 3. Enter Data. The Edit Records dialog box appears. 2. Type your text in the text fields. 3. To move to the next field, press the Tab key. 4. To move to the next new record, click New Record. The database entries are automatically saved each time you move between records. 5. Click Close when your information is entered.The Insert Field dialog box appears. 6. Select a field to insert in your design and click Insert. 7.
Open databases created in other programs using ODBC Open databases created in other programs using ODBC. ODBC stands for Open DataBase Connectivity. It is a tool that takes databases from different programs and puts them in a standard format. Follow our step-by-step Open and link a database using ODBC and mail merge lesson for additional help. When you open a database using ODBC, the data content and field names are linked to DesignPro.
To create a new ODBC data source If your database file is not listed on the Machine Data Source tab in the Select Data Source dialog box, you need to create a new ODBC data source. Dialog boxes vary depending on your database program, the ODBC components, and your operating system. Click Help in the ODBC dialog boxes to access the Microsoft ODBC Help system. 1. Open a project and click the Master tab to select it. You can insert database fields on the Master tab only. 2. Select Database > Open 3.
10. Click Select, locate and select your database file, and then click OK. The program- specific dialog box appears again. 11. Click OK to confirm and complete your data source definition. You can now select the file at any time from the Select Data Source dialog box list. 12. In the Select Data Source dialog box, select your new data source and click OK. 13. If the database file contains several tables, the Select Table/File dialog box appears. Select the table you want to use and click OK. 14.
appears. DesignPro suggests new field names for the conversion of longer names. You can accept these suggestions or you can type your own field names for the new *.dbf file, and then click OK. A message box displays a prompt to establish a connection to the database. 7. Click Yes. Insert fields and merge database information After you open a database in DesignPro, insert fields on the Master tab to complete the merge process. You can insert database fields on the Master tab only.
To view the entire project with the field and record content, select File > Print your print settings and click Print Preview. , enter To display and navigate between records 1. Select Database > Display Records. The field contents appear on the Master tab. 2. To navigate between records on the Master tab, click the navigation buttons on the Database toolbar, or select Database > Go To, and then click First Record, Previous Record, Next Record, or Last Record.
3. Type or select the new information for Field Name, Field Length, Field Data Type, or Decimal Places. 4. Click Add. The modified field appears in the list. 5. To change the position of the field in the list, select the field, and then click the up and down arrows. To delete a field 1. Select Database > Modify Database Fields. The Modify Database Fields dialog box appears. 2. Select the field name in the list and click Delete. 3. To delete all fields, click Delete All. 4. Click OK.
5. Click Close to return to the Design screen. Note To search for, select and print records that match a specific criteria, use the Filter command. To create a new record 1. Select Database > Edit Records 2. Click New Record. . The Edit Records dialog box appears. 3. Type the information for the new record in each field. 4. Click Close. To edit a record 1. Select Database > Edit Records . The Edit Records dialog box appears. 2.
3. Click Delete. A confirmation prompt appears. 4. Click Yes. 5. Click Close. Sort database records Sort the records in a database to organize them in a specific way. You can define up to three sort keys. When printing and navigating between records, the records are arranged in the specified sort order. The sort settings are saved with your project. To sort the records in a database 1. Open a project and open a dBASE III database or a database using an ODBC interface. 2. Select Database > Sort 3.
To filter records in a database 1. Open a project and open a dBASE III database or a database using an ODBC interface. 2. Select Database > Filter 3. Under Field, select fields for which you want to define filter conditions. 4. Under Compare, select an operator from the list and determine the way in which you would like to perform the query. 5. Under Compare With, type the condition or value that you want to compare with the field content.
5. Click outside the bar code object to deselect it. The bar code of the first record appears on the Master tab. 6. To define the bar code settings, right-click the object and select Format Bar Code. 7. Click OK. 8. To scroll through the bar codes on the Master tab, click the navigation buttons on the Database toolbar. Display database information Display information about the currently open database, such as file name, file path and status.
78 Chapter 7 Work with databases: Close or deactivate a database
Index adding 28 database fields 76 in fields 76 inserting 28 serial numbers 76 type 76 .AVD LabelPro database file 70 .BMP graphic files 26 .DBF dBASE III file 67 .LPD LabelPro files converting 70 .
databases 66 identical labels 14 label tabs 13 mail merge 65 new label tab 13 project from pre-designed template 8 project from scratch 8 text objects 21 custom divider template 58, 61 dividers 36, 58, 61 customizing pre-designed greeting cards 50 D data sources ODBC 68 databases adding 66 bar codes 76 closing 77 compressing 77 creating 66 dBASE III information 77 deactivating 77 fields 38, 71 filtering 75 information 77 merging information 71 name 66, 77 navigation 20, 72 ODBC information 77 opening 67 pr
F H fields adding 72 bar codes 76 changing 72 data type 66 deleting 72 inserting bar codes 76 inserting serial numbers 24 length 66 modifying 72 name 66 name list 71 order 72 parameters 24, 66, 72 rearranging 72 type 66 Help Fill Order 32 filtering criteria 75 records 75 flipping text 22 fonts point size 21 size 21 styles 21 formatting bar codes 29 date and time 23 serial numbers 24 text 21 getting started 7 horizontal print alignment 4 I identical labels 14 panels 14 printing 33 images from file 26 i
labels adding 14 different 15, 34 identical 14 identical and different 14 master label. See Master Tab 13 start position 33, 34, 38 Tab 11, 13 next record 20, 71, 73 previous record 20, 71, 73 new databases 66 projects 8, 31 records 74 tabs 13 template 8 landscape 4 next record 20, 71 last record 11, 71, 73 number active records 77 labels 14 records 77 Launch.
projects 31 print preview 32 printers calibrating 4 restoring database connection 77 printing 23, 54, 71 addresses 38, 45 database fields 38 databases 45, 75 different labels 34 Direct Print Custom Dividers 36, 58, 61 identical labels 33 mail merge 38 master label only 33 product panels 33 projects 32 records 38 serial numbers 25 sheets 33 to edge 37 two-sided products 34 rotation 22 angles 22 product panels printing 33 product tabs 13 Project Wizard 8 projects 7 pre-designed layout 7, 8 renaming 31 re
T Windows Vista 2 tab copying 14 Master 11, 14 tab bar label tab 11 master tab 11 Tagged Image File Format (.
