PowerData.pdf

(398 KB) Pobierz
for the Nokia 9210/9290 Communicator
Power Data User Guide
Table of Contents
Table of Contents ......................................................................................................................................... 2
1. Introduction.............................................................................................................................................. 4
2. Key concepts. ............................................................................................................................................ 4
2.1. Database............................................................................................................................................ 4
2.2. Tables. ............................................................................................................................................... 4
2.3 Records and Fields. ........................................................................................................................... 5
3. Tutorial. .................................................................................................................................................... 5
3.1. Creating a database. ........................................................................................................................ 5
3.2. Adding tables to a database............................................................................................................. 7
3.2.1. Field types. .................................................................................................................................. 8
3.2.2. Field properties. .......................................................................................................................... 9
3.3. Adding records to a table. ............................................................................................................. 10
3.4. Views and view options.................................................................................................................. 11
3.4.1. Zoom. ........................................................................................................................................ 12
3.4.2. Title. .......................................................................................................................................... 12
3.4.3. Full screen. ................................................................................................................................ 12
3.4.4. Column width............................................................................................................................ 13
3.4.5. Browser fields in Cards view. ................................................................................................... 13
3.5. Editing records. .............................................................................................................................. 14
3.6. Sorting records. .............................................................................................................................. 14
3.6.1. Indexes. ..................................................................................................................................... 15
3.7. Finding. ........................................................................................................................................... 17
3.7.1. Fast find..................................................................................................................................... 17
3.7.2. Bookmarks. ............................................................................................................................... 18
3.8. Filtering records............................................................................................................................. 18
3.8.1. Find filter................................................................................................................................... 18
3.8.2. Advanced filter.......................................................................................................................... 19
3.8.3. Show/hide fields........................................................................................................................ 21
3.8.4. SQL filter. ................................................................................................................................. 21
3.8.5 Template filters. ......................................................................................................................... 22
3.8.6 Managing filters. ........................................................................................................................ 23
3.8.7 Color filters. ............................................................................................................................... 24
3.9. Reports. ........................................................................................................................................... 25
3.9.1. Group amount report................................................................................................................. 25
3.9.2. Total amount report................................................................................................................... 26
3.9.3. Managing reports. ..................................................................................................................... 27
3.10. Importing data.............................................................................................................................. 27
3.10.1. Merge in. ................................................................................................................................. 29
3.11. Exporting data.............................................................................................................................. 29
3.12. Compacting a database................................................................................................................ 30
3.13. Compressing a database. ............................................................................................................. 30
© Copyright 2002 Epocware, Paragon GmbH
2
Power Data User Guide
3.14. Preferences.................................................................................................................................... 30
3.14.1. View preferences..................................................................................................................... 31
© Copyright 2002 Epocware, Paragon GmbH
3
Power Data User Guide
1. Introduction.
Welcome to Power Data! Power Data is an easy-to-use and high performance database management
system (DBMS) for the Nokia 9210/9290 Communicator. Power Data allows you to capture, store and
retrieve information about similar items.
Power Data offers you a wide range of powerful tools for managing databases like finding, sorting, and
filtering records. It allows you to have multiple tables in a single database. Power Data supports import
from and export to CSV and dBase (DBF) files.
You can download the latest version of Power Data from
http://www.epocware.com.
2. Key concepts.
2.1. Database.
A
Database
is a file that contains structured information that's related to a particular subject or purpose,
such as tracking customer orders or maintaining a music collection. It may contain one or more
Tables.
2.2. Tables.
A
Table
is a collection of data about a specific topic, such as products or orders. Tables organize data into
columns (called
Fields)
and rows (called
Records).
© Copyright 2002 Epocware, Paragon GmbH
4
Power Data User Guide
2.3 Records and Fields.
A
Record
is a collection of data arranged in one or more
Fields.
Each record describes some unique “real
word” entity such as person, product or order.
Each
Field
represents some aspect or attribute of the entity such as name, address, or date of birth of a
person. The definition of a field includes the name of the field and the type of data to be recorded.
Power Data supports wide range of field types, including text strings, numbers (integers), yes/no
(Boolean), floating point (currency) and date fields.
3. Tutorial.
The best way to learn a program is to create something in it. This chapter will take you through the
process of making a database to store a mailing list data.
3.1. Creating a database.
To create a new database, select the
New database
command form the
File
menu. The
New database
dialog will appear, where you can choose the name and the folder for the database file.
© Copyright 2002 Epocware, Paragon GmbH
5

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin