HP Jornada 700 HP Jornada 700 Series Handheld PC - (English) User Guide - Page 80

Using Microsoft Pocket Access

Get HP Jornada 700 - Handheld PC PDF manuals and user guides View all HP Jornada 700 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 80 highlights

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.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
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.