SYWARE Training Class

System Design Considerations

Data

• Databases vs. Spreadsheets vs. Text Files
• Spreadsheets
• Databases
  • Server
  • Workstation
• Database Structures
  • Basic Database Design
  • Naming Conventions
  • Data Reduction
  • Database Application
• Text Files

Devices

• PC vs. PPC vs. HPC vs. Smart Phones
• Form Factor
  • Classic
  • Durable
  • Tablet
  • Pistol Grip
  • Phone
  • Other

Device Elements

• Basic Device Organization
• Data Storage
  • Tables
    • Fields
    • Indexes
  • Forms
    • Forms as Reports
• Programs and Other Storage
• Basic Communication
  • XP and Prior
  • VISTA
  • Windows 7
  • Mini and Mainframe
• Built-in capabilities
• Add on capabilities
• Special Circumstances - vehicle and fixed mounting and the like

Basic Software Development

Visual CE Overview/Getting Started

• Setup
  • Screen Size
  • Form Size
  • Menus
• File
  • New Forms
  • Open Forms
  • Save Forms
  • Save As
  • Download Forms
• Tables
  • Create
  • Modify
  • Clone
  • Delete
  • Download
  • Synchronize
  • Create Distribution
• Forms
  • No Underlying Database
  • Device Download/Store
  • PC Download/Store
  • Title/Menu
  • Sort On
  • Unique
  • Form Size - Regions
  • Lock
  • Colors
  • About
  • Table
  • Allow: Inserts, Deletes, Recalc

Controls

• Types
  Label, Edit, Note, Checkbox, Drop Down, Radio, Autonumber, Timestamp, Scribble, Image, Lookup, Calculated, Commands, Grid, Jump, mEnable
• Employing
  Custom Colors, Cut, Copy, Paste, Delete, Align, Property

Command Buttons/Commands

• Record Menu
• Communication
• mEnable
• Report CE
• Run
• Macro
• Additional:
  Assign, Message Box, Move, Play Sound, Send SMS, Set Alarm, Set Focus, Show/Hide, Skip, Sleep, Sort By, Stop, Filter

Data Movement/Synchronization

• ActiveSync
• mEnable
• Textual data
• Pictures
• Signatures

Advanced Software Development

Forms

• Password
• Lock
• Unique
• Sort

Advanced Command Controls

• Assign
• Skip

Variables

• Persistent
• Calculated
• Expressions

Dropdowns

• Loading from a table
• Navigational
• Multi-select

Images

• Static
• Dynamic
• Camera

Lookups

Macros