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.