Database Manager User manual
Contents
1. 4 Click Connection Setup Add database connection Advanced mode Connection setup Connection string Provider Microsoft Jet OLEDB 4 0 Data Source C Program Files Codesoft 845 amples Labels Fruits mdb Persist S ecurity Info False 5 Click the Provider tab of the dialog box Connecting to database files Chapter 1 3 6 Select the required provider B Data Link Properties Provider Connection Advanced All Select the data you want to connect to OLE DE Providerls MediaCatalogDB OLE DB Provider MediaCataloghMengedDB OLE DB Provider MediaCatalogy ebDOB OLE DB Provider Microsoft IS amp M 1 1 OLE OB Provider Microsoft Jet 3 51 OLE OB Provider Microsoft Jet 4 0 OLE OB Provider Microsoft OLE OB Provider For Data Mining Services Microsoft OLE OB Provider for Indexing Service Microsoft OLE OB Provider for Internet Publishing Microsoft OLE DE Provider for OO BC Drivers Microsoft OLE OB Provider for OL4P Services Microsoft OLE DE Provider for OLAF Services 8 0 Microsoft OLE OB Provider for Oracle Microsoft OLE OB Provider for SQL Server Microsoft OLE OB Simple Provider Microsoft Project 9 0 OLE OB Provider MSD ataShape OK Annuler Alde 7 Click Next gt gt The choice of provider changes according to the system s type of database 8 Click the search button 9 Select a file 10 Click Open Chapter 1 4 Database Manager User manual E Data Li2. LOGONAME SCALE ONITSPERE 3 Click Query For a better view of the query application you can increase the size of the data display area by reducing the height of the Fields Filter and SQL Query tabs Create a filter using predefined data Database Manager must be open at the Filter tab in the Database Query window 1 Click on the Add row button Fields Fiter SQL Query Select filte Conditions table Logical Operator 2 Click in the Field field 3 Click the drop down list button 4 Click on the data required Chapter 4 22 Database Manager User manual PSA T NUM NAME LOTHUM LOGUNAME SCALE UNITSPERB 5 Click in the Operator field 6 Click the drop down list button 7 Click on the value required Operator AAMAR Il IF Database queries Chapter 4 23 Table 1 Description of operator functions Operator Lookup Equal to lt gt Different from gt Greater than gt Greater than or equal to lt Less than lt Less than or equal to NOT IN LIKE NOT LIKE BETWEEN NOT BETWEEN 8 Click in the Value field 9 Enter the value required Trailor re r re 10 Click Query Chapter 4 24 Database Manager User manual Apply a logical operator to several filters Database Manager must be open at the Filter tab in the Database Query window Several filters must exist 1 Click in the Logical field 2 Click the drop down list button 3 Click on the d
3. Sestiia IM aC hen r PO Hr amaeth Fa OR Birmingha Mil 48011 Duplicate selected record ER e 5 Delete selected record Modify a record Database Manager must be open in the Edit Database window 1 Click on the data you want to modifiy 2 Enter the data required 3 Click Apply Sort a series of records by alphanumerical order Database Manager must be open in the Edit Database window There must be at least two records in the table 1 Click on the name of the field required LOTNUM LOTNUM f LOTNUM E 1011 1999 1030 1001 1001 1026 1999 1002 1025 1003 1002 1024 1007 1004 1023 1005 1005 1011 1004 1007 1003 1008 1024 1011 1005 1002 1004 1002 1002 1025 1002 1026 1001 1030 1030 0999 Chapter 3 18 Database Manager User manual To sort records in descending order click on the same field again Delete a record Database Manager must be open in the Edit Database window 1 Click the database cursor for the required field 2 Right click the database cursor for the required field 3 Click on Delete Record in the context menu Delete selected record s 005 galt CHAPTER Database queries Database Query window Database Manager E E a olx File view Tools Database Query Database Table Query IDENTITY zi BE IDENTITY 7 FREJ Identity 1 gt A Select fi Add query ERE Unused fi
4. be set e SERIALQTY defines the number of times the label series will be printed e LABELCPY defines the number of times the label selected will be printed e PAGECPY defines the number of times the page of labels will be printed Printing Chapter 5 33 Launch printing Launch printing manually each time Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected 1 Click the Print records button g Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected 1 Tick the box next to Display the print dialog box between each record 2 Click the Print records button Update variable with database Merge Database attached to document Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected 1 Tick the box next to Update variable with database 2 Click the Print records button Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected 1 Tick the box next to Merge Database attached to document 2 Click the Print records button Chapter 5 34 Allow the database to be edited Stop printing Database Manager User manual Database Manager must be open in
5. in the Database Query window 1 Click on the Query drop down list 2 Click on the data required Query test The query selected can be modified later CHAPTER 5 Printing The Print window gt Database Manager 18 x File View Tools z Print of z Database Table o z Duen Database IDENTITY J2 IDENTITY z 00 identity 1 z Z nom A x Database Fie Identity lab C Field FIRSTNAME x s l Ml Pesme 4 E f Seting the Standard oi Edit Database 2l Name Doris Samuelson ze 4 G Printer iR5000 6000 1P_172 21 160 32 ae Address Bull Run Ranch am C Fed PRSTANE 2 E eens Print Quantities Zip Column Quantity SERIALOTY 7 zs SERIALOTY ooo LABELCPY O O al edass Quantity FIRSTNAME NAME ADDRESS ety STATE ZIP 0 Doris Samuelson BullRunRan Aurora co 89022 0 Craig McDougal 1 Airport Driv Chicago IL 60542 0 Roxie Aberdeen 15 State Ste Dallas TX 75043 0 John Mason 2421 Prospec Berkeley CA 94704 0 Warren Cole 3434 Washin Indianapolis IN 46241 0 Ned O Hare 4950 Pullman Seattle WA 98105 0 Emerson Yee 2938 42nd St New York NY 10032 a Jack Anderson 8947 SanAn Klamath Falls OR 97603 0 Mary Alland 17 Norfolk W Birmingham MI 48011 Rec af 1 gt PI Number of records 9 The Print window is used to select files for printing to assign printers and to define various parameters before printing is launched Chapter 5 28 Database Manag
6. s type of content 0 0 00 eee 2 10 Define a field s maximum size 0 0 0000 ee 2 11 Allow an empty field a 3 40 6a ens sede 4 Xe esnte ewe eee 2 11 Chapter 3 Database contents 000 eee ee eee eee 3 13 Edit Database window 2 s0e Wie few ee add Wilan o Ee ed Saeed lode Saces 3 13 Select records according to their content 3 14 Use the content of a field to find a record 3 14 Select all identical records 0 cece ee 3 14 Select an identical record 0 0c ee nnnee 3 15 Find a record according to its row inthe table 3 15 Create a neW recOrd eideann dane win Geter ise when anode hah ow aw aa ae sale 3 16 Duplicate a record feo Swede othe ae edhe We Re RS Stee eee Ae a 3 16 Modia TECO a erada A otis cee ee in ee note eh Feed Seed 3 17 Sort a series of records by alphanumerical order 0 3 17 Delle a TECOR oto bf deve eb body ht ees ene Red ye Sd ne Su hee ee ha 3 18 ii Database Manager User manual Chapter 4 Database queries 0 0 cece ees 4 19 Database Query window 0 cee eee 4 19 Add TUEN esis ie Pet ae Sa a ae ei PP a ema ae DERE 4 19 Select deselect one or more fieldS 0 0 ccc eee 4 20 Modify the order of fields selected 0 0 00 eee 4 20 Create a filter using predefined data 4 21 Apply a logical operator to several filter
7. the Print window A label template and printer must be selected The records to be printed must also be selected 1 Tick the box next to Allow the database to be edited 2 Click the Print records button Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected Printing must have already been launched 1 Click the Stop printing button Refresh database view Database Manager must be open in the Print window A label template and printer must be selected At least one record must also be selected 1 Click the Refresh database button Z Close a document Database Manager must be open in the Print window A label template must be selected 1 Click on the Documents drop down list 2 Click on the data required 3 Click the Close current document button index Add a query Chap 4 19 Add a table 8 automatically Chap 5 31 Choose a database 8 Connect Chap 1 1 Create Chap 3 16 database Chap 2 8 Database Connections 1 Database Query Chap 4 19 Database Structure 7 Delete Chap 3 18 Deselect Chap 4 20 document to be printed Chap 5 28 Duplicate with 9 Edit Database Chap 3 13 empty field Chap 2 11 existing query Chap 4 26 field s maximum size Chap 2 11 filter Chap 4 21 Chapter 6 36 Find Chap 3 15 Find a record Chap 3 14 hide Chap 2 10 Hide table Chap 2 10 iden
8. Database Manager User manual DMAN US 19 02 08 The information in this manual is not binding and may be modified without prior notice Supply of the software described in this manual is subject to a user license The software may not be used copied or reproduced on any medium whatsoever except in accordance with this license No portion of this manual may be copied reproduced or transmitted by any means whatsoever for purposes other than the personal use of the buyer unless written permission is obtained from Braton Groupe sarl 2008 Braton Groupe sarl All rights reserved Table of Contents Chapter 1 Connecting to database files 1 1 Database Connections window 0 000 cee eee eee eee 1 1 Connect the Database Manager module to the database 1 1 Modify the database connection parameters 1 5 Remove a connection auauua aa ee ees 1 5 Chapter 2 Database file structure 000 eee ees 2 7 Database Structure WwWiNdOW nananana aaea eae 2 7 Choose a database from the list of connections 2 8 Choose a table in a database nunnana nana ee eee 2 8 Add a table to the active database 0 0 0 0 cc 2 8 Delete a table in the active database 0 0 cee 2 9 View hide active table s data 0 0 0 0c ce ee 2 10 Demme akey Neld s 2 2 40 an anders hia getieded Pacts ele dat 2 10 Define a field
9. allas x John Mason 2421 Prospec Berkeley CA 94704 EditDatabase Waren Cole 3434 Washin Indianapolis IN 46241 Ned O Hare 4950 Pullman Seattle WA 98105 lal Emerson Yee 2938 42nd Str NewYork NY 10032 Jack Anderson 8947 San n Klamath Falls OR 97603 m7 mM Mary lland 17 Norfolk W Birmingham MI 48011 5 Database Query Rec I 3 gt i Number of records 9 Select all identical Database Manager must be open in the Edit Database records window and at least one record must have been found 1 Click the drop down list button 2 Click on the data required 3 Click the data input field 4 Enter the data required in the data input field Database contents Select an identical record Chapter 3 15 5 Click on the Select all button gt Database Manager ee pix File view Tools i Saj Database Connections Edit Database Table ag Database l IDENTITY J2 IDENTITY fee Tale E FIRSTNAME NAME ADDRESS CITY STATE ZIP Lene Doris Samuelson BullRunRan Aurora CO 89022 Craiq McDougal 1 Airport Driv Chicago IL 60542 I i 1OXIE Aberdeen 15 State Ste Dallas TX 75043 John Mason 2421 Prospec Berkeley CA 94704 Waren Cole 3434 Washin Indianapolis IN 46241 O Hare 4950 Pullman Seattle WA 98105 Yee 2938 42nd Str New York NY 10032 Anderson 8947 SanAn Klamath Falls OF 97603 Alland Norfolk W Birmingham Ml 48011 Edit Database Database Query Rec 14 P 3 gt i Number o
10. ata required Logical 4 Click Query to apply and view the changes Sort the list of filters Database Manager must be open at the Filter tab in the Database Query window Several filters must exist 1 Click on the database cursor for the required field 2 Click on the Up or Down arrow to reach the data required Fields Filter SQL Query Conditions table Logical I Operator Value Trailor Or 15000 Lustury Database queries Chapter 4 25 Remove a filter Database Manager must be open at the Filter tab in the Database Query window At least one filter must exist 1 Click on the database cursor for the required field 2 Click on the Remove row button Fields Filter SQL Query Select filte Conditions table Logical i Operator NAME Trailor LOTNUM 15000 Modify a filter in SQL Database Manager must be open at the SQL Query tab in the Database Query window At least one filter must exist 1 Tick the box next to Modify the query in SQL language to activate the SQL Query and make manual changes Fields Fiter SQL Query Select SQL que odify the query in SUL language SELECT PARTNUM NAME LOTNUM LOGONAME SCALE UNITSPERE FROM TOYS Chapter 4 26 Database Manager User manual 2 Click Query Note The filter can be created directly in SQL without having to use the Filter tab first Choose an existing query in a database Database Manager must be open
11. atabase Database Manager must be open in the Database Structure window 1 Click on the Table drop down list 2 Click on the data required Chapter 2 10 Database Manager User manual T able identity Identity at Toys 3 Click Delete table View hide active table s data Database Manager must be open in the Database Structure window 1 Click View data Define a key field Database Manager must be open in the Database Structure window 1 Tick the box next to the required field E a d l NA 2 Click Apply Define a field s type of content Database Manager must be open in the Database Structure window 1 Click on the required field in the Type column 2 Click the drop down list button 3 Click on the data required Database file structure Chapter 2 11 Varchar Decimal Mema 4 Click Apply Define a field s maximum size Database Manager must be open in the Database Structure window 1 Click on the required field in the Length column 2 Enter the value required 3 Click Apply Allow an empty field Database Manager must be open in the Database Structure window 1 Tick the Allow Null box for the required field Chapter 2 12 Database Manager User manual 2 Click Apply CHAPTER 3 Database contents Edit Database window i Database Manager File View Tools Edit Database a ag Database Table Database IDENTITY JE IDENTITY _ Connecti
12. ate Varchar 2 _ ZIP Varchar 5 Database Structure er IDENTITY J2 IDENTITY Allow null 10 x og Add table 3 Delete table ea View data Apply Cancel ORTON The Database Structure window is used to manage the structure of the database file to add modify or delete tables fields etc Chapter 2 8 Database Manager User manual Choose a database from the list of connections Database Manager must be open in the Database Structure window 1 Click on the Database drop down list 2 Click on the data required atab ase Batcher Choose a table in a database Database Manager must be open in the Database Structure window 1 Click on the Table drop down list 2 Click on the data required Table Identity Identity gis ET Add a table to the active database Database Manager must be open in the Database Structure window 1 Click Add table 2 Enter the name of the new table Database file structure Chapter 2 9 3 Click OK Add table O x Table Hame Toys l Duplicate with identity FE You can also copy the structure of the table from a table that already exists in the selected database To do so 1 Tick the box next to Duplicate with 2 Click on the drop down list 3 Click on the data required 4 Click OK Add table o Table Name Tos Duplicate with Toys z Tops Delete a table in the active d
13. each time 0 000 cee ee eee 5 33 Update variable with database 0 0 0 0c eee 5 33 Merge Database attached to document 5 33 Allow the database to be edited 0 000 cee 5 34 SLOD PINUNO sa eee ee eens Ea NES ae ee ce ee ae Some eee cee meee 5 34 Refresh database view nannaa aaa ee ees 5 34 Close SCdOCUIMEND 32305264 uu sowen gt ed cS tee eed her eden os 5 34 Chapter 6 INd xX 466 cui ed E Ue Vallee atthe 6 35 CHAPTER 1 Connecting to database files Database Connections window Database Connections Connection Name Database Structure Figure 1 The Database Connections window is used to connect the software to the various database files that are to be used Connect the Database Manager module to the database Database Manager must be open in the Database Connections window Chapter 1 2 Database Manager User manual 1 Go to File gt Open A File selection dialog box will open allowing you to browse for and select the database of your choice This dialog box is limited to the following database types Access mdb Excel xls Dbase dbf A wizard is available to help you connect the software to the most frequently used databases Choose the format option that matches your database format If the format required is not available do the following 1 Click Add 2 Select a database type from the list or 3 Select Others
14. elds Ordered fields Delete quey Jf Quy Database _ Connections Edit Database om Database Query FIRSTNAME NAME ADDRESS CITY STATE ZIP Samuelson BullRunRan Aurora co 89022 McDougal 1 Airport Driv Chicago IL 60542 Aberdeen 15 State Ste Dallas TX 75043 Print Mason 2421 Prospec Berkeley CA 94704 Cole 3434 Washin Indianapolis IN 46241 Ned O Hare 4950 Pullman Seattle WA 98105 Emerson Yee 2938 42nd Str New York NY 10032 Jack Anderson 8947 SanAn Klamath Falls OR 97603 su inma Rec 4 af 1 gt bi Number of records 9 The Database Query window is used to create and apply various filters Add a query Database Manager must be open at the Fields tab in the Database Query window Chapter 4 20 Database Manager User manual 1 Click Add query 2 Enter a name for the query 3 Click OK Select deselect one or more fields Database Manager must be open at the Fields tab in the Database Query window To select or deselect one or more fields click on the button next to 1 2 3 or 4 in the navigation tool l AWN 1 Click Query Modify the order of fields selected Database Manager must be open at the Fields tab in the Database Query window 1 Click on the required field in the Ordered fields window 2 Click on the Up or Down arrow to reach the data required Database queries Chapter 4 21 AAD Ordered fields PAR TMU MAME LO TNO bA
15. er User manual Display options Database Manager must be open in the Print window 1 Click Options ir Settings Preview the document Database Manager must be open in the Print window 1 Click Preview Preview Display the label design software Database Manager must be open in the Print window 1 Click Designer INI Designer Select a document to be printed Create a new Database Manager must be open in the Print window label template for printing 1 Click on the Create labels wizard button 2 Follow the wizard s instructions Printing Select an existing label template Chapter 5 29 Note Creating a label in relation to the database allows you to define exactly which elements are required to position each database field Database Manager must be open in the Print window 1 Click on the Open an existing document button Olle xa 2 Select a lab file 3 Click OK Note The Field radio buttons in the Label name and Printer name groups of options allow you to choose the label or printer required when the latter are defined in one of the fields of the active database Select a printer Database Manager must be open in the Print window A label template must be selected 1 Click on the Add or remove a printer button dj 2 Select the printer required 3 Click Validate The last printer used is selected by default Configure the selected printer Database Manager mu
16. f records 9 You can also specify the filter by clicking on the Check case button Database Manager must be open in the Edit Database window and at least one record must have been found There must be several identical contents in the search field To select a record use the search tool click on 1 First 2 Previous 3 Next or 4 Following Rec Hi E P H Chapter 3 16 Database Manager User manual Find a record according to its row in the table Database Manager must be open in the Edit Database window 1 Click the search tool s data input field 2 Enter the data required Rec HM 4 mm h Create a new record Database Manager must be open in the Edit Database window 1 Click on a field in the row marked with an asterisk 2 Enter the values required in the corresponding fields 3 Click Apply Hinuli null null null null null Duplicate a record Database Manager must be open in the Edit Database window 1 Click or double click a row or a series of rows to highlight the selected records 2 Right Click to view the context menu 3 Select Duplicate selected record s Database contents Chapter 3 17 ST AIRS THA MAME ADDRESS CIT STATE ZIP Daris Samuelson Bul Bun FE Aurora Co as022 Craig hicDougeal 1 AnportOr Chicago IL 50642 _ Rose Aberdeen 15 Stete Sir Dallas Tx 75043 _ John Mason 2421 Frosp Berkeley CA 99704 Maren Cole 3434 ashi Incdianapoli 4950 Fullm
17. nk Properties Provider Connection Advanced All Specify the following to connect to Access data 1 Select or enter a database name C Program Files Codesoft SYS amples Labels Fruits me 2 Enter information to log on to the database User name Admin Passion FO J Blank password D Allow saving password Test Connection 11 Click OK 12 Click Next 13 Enter a name for the connection Add database connection Finish Connection name fruity Connection string T Provider MSDASOL 1 Persist Security Info False Data Source Fruits Advanced Back Next Finish Cancel 14 Click Finish Connecting to database files Chapter 1 5 Note You can repeat this procedure as often as necessary to obtain the required number of connections Modify the database connection parameters Database Manager must be open in the Database Connections window The required connection must be selected 1 Click Edit 2 Make the required changes Remove a connection Database Manager must be open in the Database Connections window The required connection must be selected Scan i 1 Click Remove Chapter 1 6 Database Manager User manual CHAPTER 2 Database file structure Database Structure window gt Database Manager File View Tools er ml Database Table I Connections Varchar Varchar 25 Varchar 25 Varchar 15 MO st
18. ons gii j m B FIRSTNAME NAME ADDRESS CITY STATE ZIP eee i Samuelson BullRun Ran Aurora 89022 McDougal 1 Aiport Driv Chicago 60542 j Aberdeen 15 State Ste Dallas 75043 ea Mason 2421 Prospec Berkeley 94704 Cole 3434 Washin Indianapolis 46241 O Hare 4950 Pullman Seattle 98105 Yee 2938 42nd Str New York 10032 Anderson 8947 San n Klamath Falls 97603 1 Alland 17 Norfolk W Birmingham 48011 Edit Database Database Query Rec I P 1 gt bl Number of records 9 The Edit Database window is used to manage the contents of the database file to add modify or delete data These actions depend on the type of database Thus Excel file records cannot be modified Chapter 3 14 Database Manager User manual Select records according to their content Use the content of a field to find a record Database Manager must be open in the Edit Database window 1 Click the drop down list button 2 Click on the data required 3 Click the data input field 4 Enter the value required in the data input field gt Database Manager 5 x File View Tools Edit Database E a Database l Table Database IDENTITY J23 IDENTITY Connections lt A of im gZ NAME Apply D FIRSTNAME NAME ADDRESS CITY STATE ZIP Cancel A Doris Samuelson Bull RunRan Aurora CO 89022 McDougal 1 Airport Driv Chicago 60542 15 State Stre D
19. s 4 23 SOME NSEOMING Sn t owe as Ged Peuee et Goo ethene Pact Web ia bak 4 24 Remove a TINGS 2s ce adel ee tena ed eh SOSA Reeds OOo eee oe ee es 4 24 Modifiye Tiler IN SOs aie An de rae wale nd Pate de a a a ede oe sr aed 4 25 Choose an existing query ina database 4 26 Chapter 5 Printing 34 22 09 2es viewer ye eee Oe Soe 5 27 TEAS PTINLMNGOW s 50535 ot tas Cle as ol el me a al en ne AD ee Midian Se oe 5 27 DISolay ODUONS eaa a aE Aca oe ED san ee arte ee 5 28 Preview the document 000 cece ee eee teens 5 28 Display the label design software 0 0 0 ccc ee eee 5 28 Select a document to be printed ce ee 5 28 Create a new label template for printing 5 28 Select an existing label template 0 0 0 0 2 2 0 5 29 Select a DIINIEl a vous eves cote eee Anka ehe eh ease eee 5 29 Configure the selected printer 0 0 0 00 ccc eee 5 29 Select records to be printed 1 2 0 aaa 5 30 Selecting records manually 00 0 cee eee ees 5 30 Selecting records automatically 0 0 00 cee ees 5 31 Configure the print media 0 0 ce eee 5 31 Display the selected printer s properties 5 32 Define the number of printed pages accordingtoafield 5 32 15 Va 8 ale ag ers 2 ed oak is ae at ape See eae ek Ae ae eee 5 33 Launch printing manually
20. st be open in the Print window A label template and printer must be selected Chapter 5 30 Database Manager User manual 1 Click on the Printer settings button alal 2 Adjust the required settings 3 Click OK Select records to be printed Selecting Database Manager must be open in the Print window records manually 1 Tick the boxes next to the records required Hi BODOM lye Quantity PARTNUM NAME LOTNUM LOGONAME SCALE UNITSPE 0 24560 Jeep ded 1011 jeep bmp 1475 100 0 10570 Autobus 1001 autobus bmp 1 100 FQ Lit 10080 Trailor 0999 trailor brip 1 100 50 IP 10580 Decker 1003 decker bmp 1 100 50 EH on 10750 Fiat Blue 1007 fiat bp 1775 100 Di 24200 Golf 1005 golt bmp 1 75 100 Bi 24766 Mercedes 1004 mercedes br 1 75 100 IA 24256 Lusury 1023 luxury ornp 1475 100 il gt 23112 Old 1024 old bmp 1 75 100 25108 Porsche 1002 porsche bmp 1 75 100 I 24327 CarRed 1002 red bmp 1 75 100 Bi 24425 Truck Red 1025 tuckRedbm 1 75 ou 0 24476 Truck rel 1026 tuckyelobmp 1 75 ag Bi 24596 Van 1030 van bmp 1 75 100 COS The height of the data display grid can be modified by dragging the top of the window Printing Selecting records automatically Chapter 5 31 Database Manager must be open in the Print window 1 Click the drop down list button 2 Click on the data required 3 Click on the data input field 4 Enter the data required 5 Click on the Select all button 6 Click on the Verify b
21. tical records Chap 3 14 key field Chap 2 10 label design software Chap 5 28 label template Chap 5 28 manually Chap 5 30 Merge Database Chap 5 33 Database Manager User manual Modify Chap 3 17 Modify a connection 5 Modify filter Chap 4 25 new record Chap 3 16 null field Chap 2 11 options Chap 5 28 Ordered fields Chap 4 20 Page setup Chap 5 31 Preview Chap 5 28 preview Chap 5 28 Print Chap 5 27 print media Chap 5 31 printer Chap 5 29 printer properties Chap 5 32 Index Chapter 6 37 Printer settings Chap 5 30 Printing Chap 5 27 printing Chap 5 33 table Chap 2 8 Type Chap 2 10 type of content Chap 2 10 Remove Chap 1 5 Remove a connection 5 Remove filters Chap 4 24 View table Chap 2 10 search tool Chap 3 15 Select Chap 3 14 Chap 4 19 Select records Chap 3 14 Chap 5 30 Select deselect Chap 4 20 selecting a provider 3 software Chap 5 28 Sort Chap 3 17 Sort filters Chap 4 24 SQL Chap 4 25 Chapter 6 38 Database Manager User manual
22. utton LOTNUM fice lE OCOS Quantity PARTNUM NAME LOTNUM LOGONAME SCALE UNITSFEI 0 24560 Jeep 44 1011 jeep bmp 1775 100 0 10570 Autobus 1001 autobus bmp 1 100 Al 10080 Trailor 0999 trailor Emp 17100 All 10580 Decker 1009 decker bmp 1 100 All 0 10750 Fiat Blue 1007 hat bmp 1775 100 0 4200 Golf 1005 golf bp 1775 100 i Mercedes 1004 mercedes bm 1 75 100 Porsche 1002 porsche brp 1 75 100 Car Red 1002 red bmp 1775 100 tuckA ed bm a5 BO 026 truckyel bmp a5 BO 1775 yan Drip 100 Configure the print media Database Manager must be open in the Print window A document must be selected 1 Click on the Page setup button o sjale Chapter 5 32 Database Manager User manual Display the selected printer s properties Database Manager must be open in the Print window 1 Click on the Page setup button D ll Settings Define the number of printed pages according to a field 2 Click Settings Database Manager must be open in the Print window and a printer must be selected Records to be printed must also be selected 1 Click on the Quantity column drop down list 2 Select the data required 3 Click the selected data s drop down list button 4 Select the required value or enter a whole numeric value Note This option allows a selection of labels to be printed according to numeric values defined in specific fields Different criteria can
Download Pdf Manuals
Related Search