C/SIDE Introduction in Microsoft Dynamics NAV 5.0

8874: C/SIDE Introduction in Microsoft Dynamics NAV 5.0 (5 Days)

About this Course

Elements of this syllabus are subject to change.This five-day instructor-led course provides students with the knowledge and skills to begin creating objects in Microsoft Dynamics NAV, including tables, forms, and reports, as well as codeunits, MenuSuites, and dataports. In addition, this course provides an intensive introduction to C/AL, the Microsoft Dynamics NAV coding language.

Audience Profile

This course is intended for Microsoft Dynamics NAV partner developers who are responsible for creating application objects in Microsoft Dynamics NAV installations.

At Course Completion

The goal for completing this course is to enable students to create application objects using Microsoft Dynamics NAV code and designers, including:

• Table Designer
• Form Designer
• C/AL Code
• Report Designer
• Dataport Designer
• XMLport Designer
• MenuSuite Designer
• Automation Server functionality

Course Outline

Module 1: Introduction

Lessons

• Introduction to Microsoft Dynamics NAV Development I – C/SIDE

Module 2: Introduction to Microsoft Dynamics NAV Development I – C/SIDE

Lessons

• Beyond Microsoft Dynamics NAV Development I
• The Physical and Logical Database
• General C/SIDE Concepts
• C/SIDE Fundamentals
• Basic Objects in Microsoft Dynamics NAV

Module 3: Basic Tables

Lessons

• Tables
• Demonstration – Table and Field Properties Creating Tables
• Choosing Data Types
• Primary Keys and Secondary Keys
• Qualities of Primary Keys Setting Relationships Between Tables
• Special Table Fields
• Types of Tables and Their Characteristics

Lab : Lab 2.1 –Investigate Existing Tables

After completing this chapter, students will be able to:

• Introduce table concepts, and the structure and elements of tables.
• Demonstrate how to use the Table Designer to create simple tables and set field and table properties.
• Explain the concepts behind primary and secondary keys for tables.
• Describe setting relationships between tables.
• Explain the concepts of SumIndexFields, FlowFields, and FlowFilter fields, and how to set them.
• Modify table properties.
• Review table types.

Module 4: Basic Forms

Lessons

• Form Controls
• Bound and Unbound Forms and Controls
• Form and Control Properties
• Triggers
• Creating Buttons
• Creating Subforms
• Form Types and Characteristics

Lab : Lab 3.1 – 3.19 Design new forms and their controls

After completing this chapter, students will be able to:

• Introduce 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, and then set them to autosize.
• 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 5: Introduction to C/AL Programming

Lessons

• Lab 4.1 — View C/AL in a Table Object

Module 6: Intrinsic Data Types

Module 7: Identifiers and Variables

Lessons

• Lab 6.1 — Create a New Codeunit

Module 8: Assignment Statement

Lessons

• Lab 7.1 — Use Assignment Statements and the Symbol Menu

Module 9: Simple Expressions, Terms, and Operators

Lessons

• Lab 8.1 — Use the String Operator
• Lab 8.2 — Use the MAXSTRLEN Function in an Expression

Module 10: Numeric Expressions

Lessons

• Lab 9.1 — Arithmetic Operator Exercise
• Lab 9.2 — Examine Operator Precedence

Module 11: Logical and Relational Expressions

Lessons

• Lab 10.1 — Add Logical and Relational Expressions to a Form

Module 12: The IF and EXIT Statements

Lessons

• Lab 11.1 — Perform Calculations with IF and EXIT Statements

Module 13: Compound Statements and Comments

Lessons

• Lab 12.1 — Code with Compound Statements and Comments

Module 14: Arrays

Lessons

• Lab 13.1 — Use Arrays

Module 15: Repetitive Statements

Lessons

• Lab 14.1 — Code with Repetitive Statements

Module 16: WITH and CASE Statements

Lessons

• Lab 15.1 — Simple Use of the CASE Statement
• Lab 15.2 — Complex Use of CASE Statements

Module 17: Functions

Lessons

• Lab 16.1 — Review Built-in Functions
• Lab 16.2 — Using the DATE2DMY Function

Module 18: Using Intrinsic C/AL Functions

Module 19: Creating Your Own Functions

Lessons

• Lab 18.1 — Create Functions

Module 20: Reports

Lessons

• Reports Overview
• Types of Printed Reports
• The Report Designers

After completing this chapter, students will be able to:

• Describe the purpose of reports and their components, such as data items, sections, controls, properties, and triggers.
• Describe the difference between the logical design of reports and the visual design of reports.
• Describe the different types of printed reports.
• Introduce the designers used to create reports.
• Create a data model for a new report.
• Design the page layout for a new report.
• Create new report sections.
• Add TransHeaders and TransFooters to a report.
• Employ properties that improve reports by enabling users to filter data and select what information will print.
• Group report information using table keys and indentation.
• Create subtotals and grand totals in a report.
• Work with advanced features of report creation, including using FlowFields, adding a check box to the Options tab of the report request form, and skipping sections in a report.
• Create a basic report.

Module 21: Dataports

Lessons

• Dataport Fundamentals
• Designing Dataports

After completing this chapter, students will be able to:

• Describe dataport fundamentals.
• Describe dataport components, and the basics of designing, compiling, and running dataports.
• Explain the difference between dataports for exporting and dataports for importing.
• Create a dataport that exports in fixed and variable formats.
• Create a dataport that imports in fixed and variable formats.

Module 22: Customize the Navigation Pane

Lessons

• XMLport Fundamentals
• Designing XMLports

Lab : Lab 21.1 — Create Simple XMLports

After completing this chapter, students will be able to:

• Describe XMLport fundamentals.
• Describe designing XMLports, including the properties that must be set.
• Create simple XMLports that export and import information and codeunits to run them.

Module 23: Codeunits

Lessons

• The C/SIDE Codeunit
• Demonstration — Create and Modify Codeunits
• Using the C/AL Editor
• Demonstration — Define Variables, Text Constants, and Functions in Codeunits
• Using the C/AL Symbol Menu
• Using Codeunits
• Temporary Tables on Forms
• Demonstration — Creating a Temporary Table on a Form
• SMTP

Module 24: MenuSuites

Lessons

• Creating and Designing MenuSuite Objects
• Customizing MenuSuite Objects
• Exporting a MenuSuite Object
• Upgrading MenuSuite Content

Module 25: Automation Server

Lessons

• Automation Overview
• Creating the Variables
• Demonstration — Automate a Customer List Using Excel
• Responding to Events
• Common Problems and Limitations

After completing this chapter, students will be able to:

• Provide an overview of automation concepts.
• Describe the steps to set up automation.
• Show how variables are created in automation.
• Demonstrate how to automate a customer list.
• Create a report with automation.
• Describe responding to events.
• Describe common problems and limitations.
• Create a codeunit with automation capabilities.

Prerequisites:

• Introduction to Microsoft Dynamics NAV 5.0 course
• Basic knowledge of ERP user roles

*E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.