Overview
| Course code | D8535 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 3.0 days | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $400.00 plus tax | ||
This course builds on the skills of Lotus Education's Fundamentals of IBM Lotus Domino 8 Application Development (D8510) course. Through instructor lecture and student-centered activities and exercises, learn to use IBM Lotus Domino Designer 8 to develop multi-database applications.
The course explores advanced formula techniques including looping, and user interaction with the application. The course also explains different methods for accessing data sources outside the current Domino database including other Domino databases and relational databases. Other topics include adding workflow functionality to route documents and notify users that a document requires their attention, and security issues such as encrypting data. This course also examines navigation elements such as links, outlines, and framesets that bind the components of the application together and allow users to locate information quickly and easily.
Audience
This is an intermediate course for application developers who have experience creating or modifying single database applications with Lotus Domino Designer 8.
Prerequisites
You should have:
- Completion of the Fundamentals of IBM Lotus Domino 8 Application Development course (D8510) or equivalent knowledge, skills, and experience.
- Three or more months experience developing Lotus Domino 8 applications.
Course outline
Lesson 1: Working with Strings, Lists, and Loops
Topic 1A: Writing Formulas to Manipulate Text Values
- Useful Functions for Inspecting and Searching Text
- Inspecting and Searching Strings
- Useful Functions for Parsing a String
- Examples of Parsing a String
Topic 1B: Working with Lists
- Creating Lists
- List Operations
- Using the List Subscript Operator
- Useful Functions for Inspecting Lists
- Useful Functions for Modifying Lists
- Useful Functions for Converting Lists
Topic 1C: Creating Iterative Formulas
- Iterative Statement Functions
- Using a For Loop
- Using a While Loop
- Using a DoWhile Loop
Lesson 2: Writing Formulas to Interact with the User
Topic 2A: Using the @Prompt Function
- Introducing The @Prompt Function
- Examples of User Prompts
- The @Prompt Function @Prompt Styles
Topic 2B: Working with the @DialogBox Function
- The @DialogBox Function
- Using the @DialogBox Function
- Creating a Form for @DialogBox
Topic 2C: Using Layout Regions
- Layout Regions
- Creating a Layout Region
- Adding Elements to a Layout Region
Lesson 3: Advanced View Design
Topic 3A: Using a Background Image in a View
- Background Images
- Background Image Formatting Options
- Adding a Background Image to a View
Topic 3B: Hiding a View Column
- Hiding Columns
- Using a Formula to Hide a Column
Topic 3C: Modifying View Elements
- Highlighting View Documents
- Programmatically Setting Colors in a View
- Creating a View Column to set the Colors of a Row
- Using Values to Specify the View Text Color
- Using Values to Specify the View Background Color and Text Color
- Hiding the Color Column
- Expanding a Column to Use the Available Width
Topic 3D: Working with Embedded Elements
- Adding an Embedded Editor to the Form
- Preventing a Document from Being Saved
- Combining Embedded Elements
- Embedded Schedulers
Lesson 4: Adding Navigational Elements Using Links and Imagemaps
Topic 4A: Linking to Other Documents and Pages
- Types of Links
- Creating a Link Hotspot on a Page or Form
- The Hotspot Resource Link Properties
- Named Element Links
- Creating a Named Element Link in the Properties Box
- URL Links
- Creating a URL Link
Topic 4B: Creating Imagemaps
- Imagemaps
- Describing Hotspots on an Image
- Creating a Hotspot on an Image
Lesson 5: Working with Outlines
Topic 5A: Creating an Outline
- The Outline Design Element
- Process of Creating an Outline
- Create an Outline
- Default Outlines
- Creating a Default Outline
Topic 5B: Adding Outline Entries
- Outline Entries
- Creating a Hierarchical Outline
- Creating an Outline Entry
Topic 5C: Modifying Outline Entries
- Setting Outline Entry Properties
- Indenting and Outdenting Outline Entries
Topic 5D: Embedding an Outline
- Embedding Outlines
- Embedded Outline Properties
- Formatting an Embedded Outline
Lesson 6: Creating a Frameset
Topic 6A: Adding a Frameset to an Application
- What are Frames?
- What are Framesets?
- Structuring a Frameset
- Guidelines for Designing Framesets
- Creating a Frameset
Topic 6B: Adding Content to a Frame
- Specifying Frame Information
- Specifying a Content Source
- Using a Target Frame
- Specifying the Default Target Frame
- Target Frame Precedence
- Placing a Page in a Frame
Topic 6C: Launching an Application Frameset
- Setting Database Properties to Launch a Frameset
Topic 6D: Adjusting Framesets
- Adding New Frames to a Frameset
- Launching Individual Elements in a Specific Frame
- Opening Documents in a Frame
- Setting a Target Frame
Lesson 7: Accessing Data in IBM Lotus Domino Databases
Topic 7A: Accessing Data from a View
- Common Arguments for @Db Functions
- Options for Caching the Results of a Lookup
- Guidelines for Caching the Results of a Lookup
- Specifying a Database for Lookups
- How Lotus Notes Searches for a Replica
- Using @DbColumn
- Using @DbLookup
- Optional Keywords for @DbLookup
- Optional Keywords for @DbLookup
Topic 7B: Using @PickList
- Advantages of @PickList
- Styles of PickLists
- Displaying a View with @PickList
- Displaying a Domino Directory View with @PickList
Topic 7C: Working with Profile Documents
- Introducing Profile Documents
- Characteristics of Profile Documents
- Guidelines for Using Profile Documents
- Designing a Form for Creating Profile Documents
- Creating a Profile Document with Formulas
- Reading Data in Profile Documents
- Updating Data in Profile Documents
Lesson 8: Accessing Non-Domino Data
Topic 8A: Introducing Microsoft Open Database Connectivity (ODBC)
- Using ODBC
- Working with ODBC Drivers
- ODBC Driver Configuration
- ODBC Driver Configuration
- Example dBase Table
Topic 8B: Using @Db Functions to Access an ODBC Data Source
- Accessing Relational Data from IBM Lotus Domino with ODBC
- Comparing the @Db Functions that use ODBC
- Using @DbColumn
- Using @DbLookup
- Using @DbCommand
Lesson 9: Mapping Data Between IBM Lotus Domino and Relational Databases
Topic 9A: Introducing IBM Lotus Domino Enterprise Connection Services (DECS)
- Data Mapping
- Data Mapping in Lotus Domino
- Using DECS
- How DECS Communicates with the External Data Source
- Capabilities of DECS
Topic 9B: Working with DECS
- The DECS Server Task
- Working with the DECS Administrator Database
Topic 9C: Using Data Connection Resources (DCRs)
- Working with DCRs
- The DECS Administrator Database and DCRs
- Using DCRs
- Creating a Data Source Resource for ODBC Access
- Creating a DCR
- Basic Properties of a DCR
- Optional Properties of a DCR
- Associate a Form with a DCR
- Mapping Fields to External Table Fields
- Importing External Data
- Enabling a Lotus Domino Database to Use DCRs
Lesson 10: Adding Workflow to IBM Lotus Domino Applications
Topic 10A: Defining Workflow
- Benefits of Automating the Process
- Elements of Workflow
- Using a Workflow Diagram
- Example of an Expense Reimbursement Workflow Diagram
- Workflow Elements of the Expense Reimbursement Process
Topic 10B: Routing Workflow Objects in IBM Lotus Domino
- The Routing Process
- Ways to Route Documents Making a Mail Database Known to the Router Making an Application Database Known to the Router
Topic 10C: Designing Workflow
- Triggering Workflow
- Identifying the Recipient
- Identifying the Data to Send
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
