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.