HP 700 Series - Manual (Page 80)

76 HP Jornada 700 Series Handheld PC
workbooks cannot be synchronized.
Using Microsoft Pocket Access
You can use Pocket Access to view and update data derived from
Microsoft Access, Microsoft SQL Server, and other ODBC
databases on your HP Jornada. You can open the database and
update data in the corresponding tables or you can fill out
electronic forms. Eventually, you should synchronize the new
information with a larger database on your desktop PC or your
corporate network. You can also use Pocket Access to create new
databases, tables, and SQL procedures directly on your device.
Programmers can use Microsoft ActiveX™ Data Objects for MS
Windows for H/PC 2000 (ADOCE) and Microsoft Visual
Basic™ or Microsoft Visual C++™ to develop custom database
solutions. For more information on creating custom database
solutions, go to the Microsoft Web site at
www.microsoft.com/mobile.
To create a new database and table
1. On the Start menu, point to Programs, point to Office, and
then tap Microsoft Pocket Access.
–or–
Double-tap the Microsoft Pocket Access icon on the desktop.
2. On the View menu, tap Database View, and then tap
Open/New Database on the File menu.
3. Type a name for the database and tap OK.
4. Double-tap the Create a New Table icon.
5. In the Field Name box, type a name.
6. From the Data Type list, select a data type.
· The data type of a field cannot be changed after the table is
saved.
· Text boxes have a size limit of 255 characters. To enter
longer notes, select the Memo data type.
· To enter numbers with decimal points, select the Float data
type.
· To enter numbers between -32,768 and +32,767, select the
Integer data type.