30 Using Microsoft CE Applications
Pocket Access: Viewing and Creating Data 3
Use Pocket Access to view and update data derived from Microsoft Access, Microsoft
SQL Server, and other ODBC databases you have created on the desktop computer.
Simply create the database on your desktop computer and then transfer the data to
your PenCentra 200. For example, a sales organization might use Access on the
desktop computer to create a master database of products and order forms (see
Figure 3-3). The sales force can synchronize their PenCentra 200s with the master
database to get up-to-date product information and to upload completed client order
information. For more information on synchronizing, see the section of this chapter
entitled “Microsoft Windows CE Services.”
You can also use Pocket Access to create new databases, tables, and SQL procedures
directly on your PenCentra 200.
Figure 3-3 Pocket Access Database