Microsoft Dynamics NAV 2009 C/SIDE Introduction (80042A) Exam MB7 - 840

Module 1: Client/Server Integrated Development Environment (C/SIDE)
This module explains basic objects in Microsoft Dynamics NAV and the Client/Server Integrated Development Environment (C/SIDE). It also describes physical and logical databases and several integration tools available in Microsoft Dynamics NAV 2009.
Lessons
Basic Objects in Microsoft Dynamics NAV
C/SIDE Fundamentals
The Physical and the Logical Database
Integration Tools
After completing this module, students will be able to:
Discuss objects in Microsoft Dynamics NAV 2009.
Describe fundamental aspects of C/SIDE development, including UI, application objects, C/SIDE concepts and types of databases.
Discuss database structure.
Describe integration tools available in Microsoft Dynamics NAV 2009.
Module 2: Tables
This module explains the fundamental concepts of table objects, describes the concepts of table relationships, special table fields and how to use them, and describes how to use the Table Designer to create and modify tables. It also describes table types and their characteristics.
Lessons
Table Fundamentals
Primary and Secondary Keys
Demonstration: Create a Simple Table
Special Table Fields
Demonstration: Special Table Fields
Table Types and Characteristics
Lab : Create a Table
After completing this module, students will be able to:
Describe table concepts, the structure and elements of tables.
Demonstrate how to use the Table Designer to create simple tables and set field and table properties.
Explain concepts behind primary and secondary keys for tables.
Describe table relationships and how to set them.
Explain the concepts of SumIndexFields, FlowFields, and FlowFilter fields, and how to use them.
Review table types.
Module 3: Forms
This module explains the fundamental concepts of form objects and describes how to use the Form Designer to create and modify forms. It also describes form types and their characteristics and standard navigation in forms.
Lessons
Form Fundamentals
Demonstration: Create a Simple Form
Form Types and Characteristics
Demonstration: Create a Card Form
Demonstration: Create a List Form
Demonstration: Link the Card Form and the List Form
Demonstration: Form and Subform
Standard Navigation
Lab : Create a Card Form and a List Form
After completing this module, students will be able to:
Describe form concepts and elements of forms, including controls.
Describe binding forms and controls to source tables.
Create a blank form and attach a source table.
Add simple controls to a form, such as a text box, a label, and a check box.
Use tools from the Toolbox, including the Add Label tool and the Lock tool.
Add a tab, frame, and TableBox controls to a form.
Add option buttons, an indicator control, and a BLOB field, or picture, to a form.
Use the Form Wizard to create a card form and a tabular form.
Add fields and buttons to forms.
Create a subform and add it to the main form.
Discuss form types and the standard navigation in forms.
Module 4: Pages
This module explains the fundamental concepts of page objects and describes how to use the Page Designer to create and modify pages. It also describes page types and their characteristics and discuss the best practices in creating pages.
Lessons
Page Fundamentals
Page Designer
Demonstration: Create a Simple Page
Page Types and Characteristics
Design Pages: Best Practices
Demonstration: Create a Card Page
Demonstration: Create a List Page
Demonstration: Part and Part Page
Lab : Create a Card, a List and a ListPart Page
After completing this module, students will be able to:
Describe page concepts and elements of page, including actions.
Use the Page Designer to create and modify pages and the Action Designer to add actions and position them.
Add simple controls to a page, such as a field and a FastTab.
Use the Field Menu to add multiple fields.
Create a part page and add it to the main page.
Discuss the best practices in creating pages.
Discuss page types and their characteristics.
Module 5: Introduction to C/AL Programming
This module introduces C/AL, the programming language in C/SIDE and its elements. It also describes data types available in C/AL, concepts of identifier, variable, syntax, variable scope and variable initialization.
Lessons
C/AL Programming
Intrinsic Data Types
Identifiers, Variables and Syntax
The Syntax of Identifiers
Variable Scope
Variable Initialization
Demonstration: Data Types and Variable Initialization
Lab : Investigate Data Types
After completing this module, students will be able to:
Understand the concepts and basic use of C/AL code elements.
Describe data types in C/AL.
Describe the concepts of identifier, variable, syntax, variable scope and initialization.
Module 6: Assignment Statements and Expressions
This module explains assignment statements, expressions, terms and operators. It describes automatic type conversion between data types and different kinds of operators and operator precedence. It also describes numeric, relational and logical expressions.
Lessons
Assignment Statements
The Syntax of Statements
Automatic Type Conversions
Demonstration: Use Assignment Statements and the Symbol Menu
Expressions, Terms, and Operators
The Syntax of an Expression
The String Operator
Demonstration: Use the String Operator
Function Calls in Expressions
Demonstration: Use the MAXSTRLEN and the COPYSTR Function
Numeric Expressions
Arithmetic Operators
Demonstration: Use the Arithmetic Operators
Relational and Logical Expressions
Relational Expressions for Comparisons
Relational Expressions for Set Inclusion
Logical Expressions
Demonstration: Use Logical and Relational Expressions in a Page
After completing this module, students will be able to:
Describe the concepts of assignment statement, the syntax of statements and statement separator.
Describe automatic type conversions for string, numeric and other data types.
Use the C/AL Symbol Menu.
Describe the concepts of expressions, terms and operators.
Describe the string operator, the arithmetic operators and operator precedence.
Describe relational and logical operators, and how to use them.
Module 7: C/AL Statements
This module explains conditional statements, compound statements, comments and repetitive statements. It also describes the concepts of Arrays and how to use them.
Lessons
Conditional Statements and Boolean Expressions
The IF Statement
The EXIT Statement
The CASE Statement
Compound Statements and Comments
The Syntax of Compound Statements
Compound Statement by Using Nested IF Statements
The Syntax of Comments
Demonstration: Use the IF, EXIT, CASE and Compound Statements in a Page
Arrays
The Syntax of Arrays
The Power of Arrays
Strings as Arrays of Characters
Repetitive Statements
Demonstration: Use Arrays and Repetitive Statements
The WITH Statement
Lab : Use Conditional and Compound Statements
After completing this module, students will be able to:
Describe the concepts of conditional statements and Boolean expressions.
Use the IF, CASE and EXIT statements.
Describe the concepts of compound statements and comments.
Describe the concepts of Arrays and how to use them.
Describe the concepts of repetitive statements and understand when to use different types of repetitive statements.
Module 8: C/AL Functions
This module explains the concepts of functions and describes several built-in functions and how they are used. It also describes the concepts of parameters and how to create custom functions.
Lessons
Functions and Parameters
Review Built-in Functions
Demonstration: Use the DATE2DMY Function
Essential C/AL Functions
User Communication Functions
String Functions
System Functions
Date Functions
Number Functions
Array Functions
Other Functions
Create Custom Functions
Formal and Actual Parameters
Local Functions, Variables and the EXIT Statement
Demonstration: Create Custom Functions
After completing this module, students will be able to:
Describe the concepts of functions and parameters.
Describe several built-in functions and how they are used.
Create custom functions.
Module 9: Reports
This module explains the fundamental concepts of report objects and describes the different stages in creating and designing reports. It also describes several types of printing reports and how to create grouping, totaling and add advanced features to a report, for the Classic and the RoleTailored Client.
Lessons
Report Fundamentals
Types of Printing Reports
Report Design Process
Design the Data Model
Demonstration: Create a Data Model
Design the Visual Element
Demonstration: Design the Report Section
Demonstration: Modify Report Properties
Demonstration: Design the Report Layout
The Request Options Designer
Demonstration: Design the Request Options Form
Demonstration: Design the Request Options Page
Grouping Within a Classic Report
Demonstration: Create Grouping For the Classic Report
Totaling in a Report
Demonstration: Create Totals for the Classic Report
Demonstration: Create Grouping and Totals for the RoleTailored Report
Demonstration: Add Some Advanced Features
Lab : Create a Basic Report
After completing this module, students will be able to:
Describe report concepts and the components of reports.
Describe different types of printing reports and their characteristics.
Describe the logical and visual design of reports.
Create a data model in the Report Designer.
Design report sections by using the Section Designer.
Design report layout by using Microsoft Visual Studio Report Designer.
Design Request Options Form and Request Options Page by using the Request Options Designer.
Set several useful report properties.
Create grouping and totaling in reports for the Classic and the RoleTailored Client.
Add some advanced features to a report.
Module 10: Dataports and XMLports
This module explains the fundamental concepts of dataport and XMLport objects and describes how to use the Dataport Designer and XMLport Designer to create dataports and XMLports for export and import external file. It also describes how XMLports replace Dataports in the RoleTailored Client.
Lessons
Dataport Fundamentals
Design Dataports
Demonstration: Create Dataports for Export
Demonstration: Create Dataports for Import
XMLport Fundamentals
Design XMLports
Demonstration: Create XMLports for Use in the Classic Client
Demonstration: Create XMLports for Use in the RoleTailored Client
Lab : Create XMLports
After completing this module, students will be able to:
Describe Dataport concepts and the components of Dataports.
Create and design Dataports for export and import with fixed and variable format of the external file.
Describe XMLport concepts and the components of XMLports.
Create and design XMLports to be run in the Classic and the RoleTailored Client.
Module 11: Codeunits
This module explains the fundamental concepts of codeunit objects and describes how to use the C/AL Editor to create codeunits. It also describes how to use the SMTP Mail Codeunit.
Lessons
Codeunit Fundamentals
Design Codeunits
Use Codeunits
Demonstration: Define Variables, Text Constants and Functions in a Codeunit
SMTP
After completing this module, students will be able to:
Describe codeunit concepts.
Create and use codeunits.
Define Variables, Text Constants and Functions in a codeunit.
Use the SMTP Mail Codeunit.
Module 12: MenuSuites
This module explains the fundamental concepts of MenuSuite objects and describes how to use the Navigation Pane Designer to create and design MenuSuites. It also describes how to create MenuSuite for the Classic and the RoleTailored Client.
Lessons
MenuSuite Fundamentals
Create and Design MenuSuites
Upgrade MenuSuite
Demonstration: Create a MenuSuite for the Classic Client
Demonstration: Create a MenuSuite for the RoleTailored Client
Lab : Create MenuSuites
After completing this module, students will be able to:
Describe MenuSuite concepts and MenuSuite levels.
Create and Design MenuSuites.
Understand the concepts of upgrading MenuSuites.
Create MenuSuites for the Classic and the RoleTailored Client.
<B>Module 13: Integration Options
This module explains several integration tools available in Microsoft Dynamics NAV. It also describes how to use them and their limitations.
Lessons
Web Services
Demonstration: Create, Expose and Consume Web Services
ODBC
Demonstration: Use Microsoft Dynamics NAV ODBC
C/FRONT
OCX
Demonstration: Use OCX Controls
Automation Server
Demonstration: Create a Report with Automation
After completing this module, students will be able to:
Describe the concepts of Microsoft Dynamics NAV Web Services.
Create a codeunit Web service, expose a page and a codeunit Web service and consume them from an external application.
Describe the concepts of Microsoft Dynamics NAV ODBC, its requirements, installation and limitations.
Describe the concepts of C/FRONT, its requirements, installation and limitations.
Describe the concepts of OCX, its installation, registration and limitations.
Use OCX controls.
Describe the concepts of Automation, its requirements, installation and limitations.
Create a report with Automation.