manualshive.com logo in svg

Braton Group Database Manager, User Manual, Page: 25 / 42

Share
Download
Braton Group Database Manager User Manual Download Page 25

Database queries

Chapter 4 - 21

3  

Click 

Query

Note

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

2  

Click in the 

Field 

field

3  

Click the drop-down list button

4  

Click on the data required

Summary of Contents for Database Manager

Page 1: ...Database Manager User manual DMAN US 01 12 06...

Page 2: ...cordance 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...

Page 3: ...te a table in the active database 2 9 View hide active table s data 2 10 Define a key field 2 10 Define a field s type of content 2 10 Define a field s maximum size 2 11 Allow an empty field 2 11 Chap...

Page 4: ...abel design software 5 28 Select a document to be printed 5 28 Create a new label template for printing 5 28 Select an existing label template 5 29 Select a printer 5 29 Configure the selected printer...

Page 5: ...nnections window 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...

Page 6: ...wing database types Access mdb Excel xls Dbase dbf Note A wizard is available to help you connect the software to the most frequently used databases Choose the format option that matches your database...

Page 7: ...to database files Chapter 1 3 6 Select the required provider 7 Click Next Note The choice of provider changes according to the system s type of database 8 Click the search button 9 Select a file 10 C...

Page 8: ...Chapter 1 4 Database Manager User manual 11 Click OK 12 Click Next 13 Enter a name for the connection 14 Click Finish...

Page 9: ...ctions 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 Remo...

Page 10: ...Chapter 1 6 Database Manager User manual...

Page 11: ...C H A P T E R 2 Database file structure Database Structure window The Database Structure window is used to manage the structure of the database file to add modify or delete tables fields etc...

Page 12: ...he Database drop down list 2 Click on the data required 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 d...

Page 13: ...y 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 Delete a table in the active database Database Ma...

Page 14: ...ick 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 2 Click Apply Define a field s type of content Database Manage...

Page 15: ...abase 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 op...

Page 16: ...Chapter 2 12 Database Manager User manual 2 Click Apply...

Page 17: ...contents Edit Database window 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 re...

Page 18: ...p 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 Select all identical records Database Manager must be open in the Edit D...

Page 19: ...on the Check case button Select an identical record 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 t...

Page 20: ...w 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 Duplicate...

Page 21: ...tabase 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...

Page 22: ...ending 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 curso...

Page 23: ...T E R 4 Database queries Database Query window 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...

Page 24: ...n 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 1 Click Query Modify the order of fields selected Database Manager mu...

Page 25: ...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...

Page 26: ...Chapter 4 22 Database Manager User manual 5 Click in the Operator field 6 Click the drop down list button 7 Click on the value required...

Page 27: ...alue field 9 Enter the value required 10 Click Query Table 1 Description of operator functions Operator Lookup Equal to Different from Greater than Greater than or equal to Less than Less than or equa...

Page 28: ...exist 1 Click in the Logical field 2 Click the drop down list button 3 Click on the data required 4 Click Query to apply and view the changes Sort the list of filters Database Manager must be open at...

Page 29: ...er must exist 1 Click on the database cursor for the required field 2 Click on the Remove row button Modify a filter in SQL Database Manager must be open at the SQL Query tab in the Database Query win...

Page 30: ...e created directly in SQL without having to use the Filter tab first Choose an existing query in a database Database Manager must be open in the Database Query window 1 Click on the Query drop down li...

Page 31: ...C H A P T E R 5 Printing The Print window The Print window is used to select files for printing to assign printers and to define various parameters before printing is launched...

Page 32: ...nager must be open in the Print window 1 Click Preview Display the label design software Database Manager must be open in the Print window 1 Click Designer Select a document to be printed Create a new...

Page 33: ...ons 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 Data...

Page 34: ...Adjust the required settings 3 Click OK Select records to be printed Selecting records manually Database Manager must be open in the Print window 1 Tick the boxes next to the records required Note The...

Page 35: ...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 button Configure the print media...

Page 36: ...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 T...

Page 37: ...o Display the print dialog box between each record 2 Click the Print records button Update variable with database Database Manager must be open in the Print window A label template and printer must be...

Page 38: ...abel 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 Mana...

Page 39: ...te Chap 3 16 D 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 E Edit Datab...

Page 40: ...software Chap 5 28 label template Chap 5 28 M manually Chap 5 30 Merge Database Chap 5 33 Modify Chap 3 17 Modify a connection 5 Modify filter Chap 4 25 N new record Chap 3 16 null field Chap 2 11 O o...

Page 41: ...ion 5 Remove filters Chap 4 24 S 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...

Page 42: ...Chapter 6 38 Database Manager User manual...

Reviews:

No comments