HP Jornada 820 HP Jornada 820/820e Handheld PC User's Guide - F1260-90001 - Page 114

Using Microsoft Pocket Access

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

Page 114 highlights

110 | HP Jornada H/PC User's Guide If your workbook contains sensitive information, you can protect it with a password. To do so, open the workbook, and on the File menu, click Password. 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 click Microsoft Pocket Access. 2. On the View menu, click Database View, and then on the File menu, click Open/New Database. 3. Type a name for the database and click OK. 4. Double-click the Create a New Table icon. 5. In the Field Name box, type a name. Chapter6.p65 0109 110 2/4/99, 4:17 PM

  • 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
110
|
HP Jornada H/PC User’s Guide
If your workbook contains sensitive information, you can protect it with a password. To do
so, open the workbook, and on the
File
menu, click
Password
. 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 click
Microsoft Pocket Access
.
2.
On the
View
menu, click
Database View
,
and then on the
File
menu, click
Open/New
Database
.
3.
Type a name for the database and click
OK
.
4.
Double-click the
Create a New Table
icon.
5.
In the
Field Name
box, type a name.
Chapter6.p65 0109
2/4/99, 4:17 PM
110