HP Jornada 680 HP Jornada 680/680e Handheld PC User's Guide - Page 84

Using Microsoft Pocket Access

Page 84 highlights

78 | HP Jornada 680/680e User’s Guide To create a workbook using Pocket Excel 1. On the File menu, point to New, and then tap Workbook. 2. Create your worksheet. 3. On the File menu, tap Save. 4. Type a name for your file, and then tap OK. If your workbook contains sensitive information, you can protect it with a password. To do so, open the workbook and tap Password on the File menu. Password-protected 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 Windows CE (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/windowsce. 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.

  • 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

78
|
HP Jornada 680/680e User±s Guide
To create a workbook using Pocket Excel
1.
On the
File
menu, point to
New
, and then tap
Workbook
.
2.
Create your worksheet.
3.
On the
File
menu, tap
Save
.
4.
Type a name for your file, and then tap
OK
.
If your workbook contains sensitive information, you can protect it with a password. To do
so, open the workbook and tap
Password
on the
File
menu. Password-protected
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 synchro-
nize 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 Windows CE (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/windowsce.
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.