Pocket Database 4.1

Pocket Database 4.1 is the most powerful version of a critically acclaimed program that has received thousands of downloads and was recently selected as one of the finalists for the 2002 PocketPC Awards. The feature set in Pocket Database 4.1 is unmatched by any other database program on the market for the Pocket PC.

Features UNIQUE to Pocket Database!

* Fully supports related tables!
- We know that the true power of databases lies in the relational aspects, which is why we made Pocket Database the first and only fully relational database client Pocket PC. Now you can leave the office and still have the power of your databases at your fingertips. View all related records with a single click of a button!
- Advanced relational options are also available to maintain data integrity:
1. Relational Integrity
2. Cascading Updates
3. Cascading Deletes
* AutoNumber field types
- Use the new AutoNumber field to keep your tables in sync with your desktop databases.
* Calculation field types
- Calculated fields let you see and analyze the data you enter / retrieve in the field.
* Lookup Fields
- Enter data much faster with automatic lookup for field input. You can enter values manually or have them automatically entered each time you view that field! These values will be accessible from all different parts of the program.
* Required and Unique Fields
- Define fields to be required and / or unique to ensure that you always enter valid data.
* Integrated Index Manager
- Create and delete indexes on the fly to greatly increase the speed of searches and filters. Indexes also allow you to set and change the default sorting for your tables.
* Import Wizard
- The Import Wizard lets you import data from multiple types of delimited files. It lets you view a portion of the data before importing so you can ensure that it will be imported correctly. You can also change field names and types to get your data looking just how you want it.

Other Exciting Features!

* Inline Field Editing
- Edit your data right in the field itself. No more looking back and forth between fields to make sure that your data is entered correctly.
- Automatic field detection puts the right kind of input for each field, whether it be a lookup value, boolean or date.
* Drill down on your data
- One click sorting / filtering allows you find the data you need quickly and efficiently. The new advanced filter / sort feature makes it possible to search multiple fields.
* Find / Replace
- A fully functional Find / Replace menu lets you find and replace values in your database without having to filter for them and look for them manually.
* Column Calculations
- Perform useful calculations on your numerical columns for further data analysis.
1. Sum
2. Average
3. Minimum Value
4. Maximum Value
* Form Editing
We received many emails about the lack of the ability to change the available fields on a form after creation, so we made it possible to add / remove fields from forms at any time. You can also change the SQL source statement to narrow the focus of the form.
* Advanced Table Editing
- Specify field types and sizes. Also, non-destructive field type changes!
* Form Customization
- Customize your forms by changing the fonts, colors and backgrounds of labels, fields and the entire form itself.
* Query Editor
- The brand new query editor speeds up your SQL entry exponentially by having commonly used commands available at the press of a button.
* Fully comprehensive and indexed help file.The best help file available for a PPC database program is the first step for our dedicated customer service. You can get the answers you need quickly so you can get back to your data.
* Customer Support
- You have our promise to respond to each customer email within three days, so we can help you get up and running as soon as possible.
* Footprint
- Pocket Database has a footprint of 1.7 MB, about half the installation size of competing database programs.
* Upgrades
- With your purchase of Pocket Database, you receive free upgrades for life, keeping you up to date with the latest features and improvements.