Braton Group Database Manager Скачать руководство пользователя страница 29 | Manualshive

Страница: 29 / 42

background image

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

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.

«
...
27
28
29
30
31
...
»

Содержание Database Manager

Страница 1: ...Database Manager User manual DMAN US 01 12 06...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 8: ...Chapter 1 4 Database Manager User manual 11 Click OK 12 Click Next 13 Enter a name for the connection 14 Click Finish...

Страница 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...

Страница 10: ...Chapter 1 6 Database Manager User manual...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 16: ...Chapter 2 12 Database Manager User manual 2 Click Apply...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 42: ...Chapter 6 38 Database Manager User manual...

Отзывы:

Нет отзывов

Похожие инструкции для Database Manager

Бренд: Xerox Страницы: 204

DRAGON NATURALLYSPEAKING 7

Бренд: ScanSoft Страницы: 222

ANTI-EXECUTABLE ENTERPRISE

Бренд: FARONICS Страницы: 68

COLDFUSION 5-ADVANCED ADMINISTRATION

Бренд: MACROMEDIA Страницы: 372

MOBILE SECURITY 80 Series

Бренд: F-SECURE Страницы: 39

PERFORMANCE MANAGEMENT FOR POWER SYSTEMS

Бренд: IBM Страницы: 12

Бренд: Valgrind Страницы: 319

Бренд: Sling Media Страницы: 112

PTF100NTU - LCD PROJECTOR

Бренд: Panasonic Страницы: 2

Бренд: Panasonic Страницы: 4

Бренд: Panasonic Страницы: 10

Media Manager V2.1

Бренд: Panasonic Страницы: 28

Lumix VQT0U14 ( )

Бренд: Panasonic Страницы: 36

Бренд: Panasonic Страницы: 70

PANATERM Ver. 3.7

Бренд: Panasonic Страницы: 78

Voice Editing Ver.2.0

Бренд: Panasonic Страницы: 132

Бренд: Panasonic Страницы: 156

LINUX ENTERPRISE DESKTOP 10 SP1 -

Бренд: Linux Страницы: 76

Бренды по названию

0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Популярные бренды

Загрузить еще бренды