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.
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 - 2Database Manager - User manual
1 Go to File > 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)
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 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
4 Click Connection Setup
5 Click the Provider tab of the dialog box
Connecting to database filesChapter 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 Click Open
Chapter 1 - 4Database Manager - User manual
11 Click OK
12 Click Next
13 Enter a name for the connection
14 Click Finish
Connecting to database filesChapter 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.
selected.
1 Click Edit
2 Make the required changes
The required connection must be
Remove a connection
Database Manager must be open in the Database
Connections window.
selected.
The required connection must be
1 Click Remove
Chapter 1 - 6Database Manager - User manual
CHAPTER 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.
Chapter 2 - 8Database 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
.
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
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 structureChapter 2 - 9
3 Click OK
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
Delete a table in the active 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
.
Loading...
+ 29 hidden pages
You need points to download manuals.
1 point = 1 manual.
You can buy points or you can get point for every manual you upload.