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

Database View, Open/New Database, Field Name, Data Type, Field Size, Indexed, Save Table

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

Page 85 highlights

Chapter 5 | Getting down to business | 79 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. • To enter smaller numbers, select the Small Integer data type. 7. To set the size limit of a field, enter an amount in the Field Size box. You cannot change field sizes after the table is saved. 8. To index the field, select Yes from the Indexed list. Indexing a field allows Pocket Access to find and sort information faster for that field. 9. Repeat these steps until you have created all the fields you want for your table. 10. On the File menu, tap Save Table. If you have tables that you do not want to keep updated on the device (such as product catalogs), mark them as read-only when transferring them from the desktop to the device to save time during future synchronization sessions. Windows CE Services will not check for updates the next time you synchronize.

  • 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
Chapter 5
|
Getting down to business
|
79
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.
±
To enter smaller numbers, select the Small
Integer data type.
7.
To set the size limit of a field, enter an amount in the
Field Size
box. You cannot change field sizes after
the table is saved.
8.
To index the field, select
Yes
from the
Indexed
list.
Indexing a field allows Pocket Access to find and sort
information faster for that field.
9.
Repeat these steps until you have created all the
fields you want for your table.
10.
On the
File
menu, tap
Save Table
.
If you have tables that you do not want to keep updated on the device (such as product
catalogs), mark them as read-only when transferring them from the desktop to the device
to save time during future synchronization sessions. Windows CE Services will not check for
updates the next time you synchronize.