Maricopa Community Colleges  CIS175LE   19994-20035 
Official Course Description: MCCCD Approval: 03/23/99
CIS175LE 19994-20035 L+L 2 Credit(s) 3 Period(s)
Lotus Notes Application Development III
Enhanced performance of Notes applications including application design and development. Topics include form and field events, data retrieval and synchronization. Prerequisites: CIS175LD or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS175LE   19994-20035 Lotus Notes Application Development III
1. Explain process of setting up a development environment. (I)
2. Use the Travel Planner application. (I)
3. Explain the purpose of form and field events. (II)
4. Use QuerySave to validate fields. (II)
5. Explain when to use the @Prompt and @DialogBox when creating multiple forms. (III)
6. Identify items contained in a view. (IV)
7. Differentiate between single and multiple lookups and how to replace a multiple lookup with a single lookup. (V)
8. Retrieve data with GetDocumentByKey and GetAllDocumentsByKey. (V)
9. Use @DbColumn and @DbLookup to retrieve data from an external database. (V)
10. Complete data synchronization in related documents across databases and in hierarchies. (VI)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS175LE   19994-20035 Lotus Notes Application Development III
    I. Development Environment
        A. Setting Up
        B. Travel Planner Application
        C. Application Improvements
        D. Development Methodology
      II. Form and Field Events
          A. Order
            1. Creating Document
            2. Saving Document
          B. Input Validation
          C. QuerySave
          D. PostOpen Tips
          E. Initialize and Terminate Tips
          F. LotusScript and Formulas
            1. Comparing
            2. Combining
          G. Variables
            1. Declaring
            2. Instantiating
          H. View and Database Events
          I. Performance Improvement
          J. Control User Interaction
        III. Multiple Forms
            A. Notes Hierarchy
            B. Progressive Disclosure
              1. @Prompt
              2. @DialogBox
            C. DialogBox Method
          IV. View Performance
              A. Structure of Views
              B. Column Formulas
              C. Frequency of View Updates
            V. Data Retrieval
                A. Lookups
                  1. Single
                  2. Multiple
                  3. Replacing Multiple with Single
                B. GetDocumentsByKey
                C. GetAllDocumentsByKey
                D. Profile Document with LotusScript
                  1. Creating
                  2. Retrieving Data
                E. Across Databases
                F. External Databases
                  1. Open Database Connectivity (ODBC) drivers
                  2. @DbColumn
                  3. Syntax
                  4. @DbLookup
                  5. @DbCommand
              VI. Synchronizing Documents
                  A. Across Databases
                    1. Notes Storage Facility (NSF)
                    2. Ways to Synchronize Documents
                  B. In a Hierarchy
                    1. Updating Data in Parent Document
                    2. Updating Data in Sibling Documents
                    3. Updating from a Response
                    4. Recursion
              Go to Description    Go to top of Competencies    Go to top of Outline