Course OutlineModule 1: introductionLessons - Introduction to Microsoft Dynamics NAV Development I – C/SIDE
Module 2: Introduction to Microsoft Dynamics NAV Development I – C/SIDELessons - 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 TablesLessons - 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 TablesAfter 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 FormsLessons - 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 controlsAfter 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 ProgrammingLessons - Lab 4.1 — View C/AL in a Table Object
Module 6: Intrinsic Data TypesModule 7: Identifiers and VariablesLessons - Lab 6.1 — Create a New Codeunit
Module 8: Assignment StatementLessons - Lab 7.1 — Use Assignment Statements and the Symbol Menu
Module 9: Simple Expressions, Terms, and OperatorsLessons - Lab 8.1 — Use the String Operator
- Lab 8.2 — Use the MAXSTRLEN Function in an Expression
Module 10: Numeric ExpressionsLessons - Lab 9.1 — Arithmetic Operator Exercise
- Lab 9.2 — Examine Operator Precedence
Module 11: Logical and Relational ExpressionsLessons - Lab 10.1 — Add Logical and Relational Expressions to a Form
Module 12: The IF and EXIT StatementsLessons - Lab 11.1 — Perform Calculations with IF and EXIT Statements
Module 13: Compound Statements and CommentsLessons - Lab 12.1 — Code with Compound Statements and Comments
Module 14: ArraysLessons Module 15: Repetitive StatementsLessons - Lab 14.1 — Code with Repetitive Statements
Module 16: WITH and CASE StatementsLessons - Lab 15.1 — Simple Use of the CASE Statement
- Lab 15.2 — Complex Use of CASE Statements
Module 17: FunctionsLessons - Lab 16.1 — Review Built-in Functions
- Lab 16.2 — Using the DATE2DMY Function
Module 18: Using Intrinsic C/AL FunctionsModule 19: Creating Your Own FunctionsLessons - Lab 18.1 — Create Functions
Module 20: ReportsLessons - 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: DataportsLessons - 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 PaneLessons - XMLport Fundamentals
- Designing XMLports
Lab : Lab 21.1 — Create Simple XMLportsAfter 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: CodeunitsLessons - 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: MenuSuitesLessons - Creating and Designing MenuSuite Objects
- Customizing MenuSuite Objects
- Exporting a MenuSuite Object
- Upgrading MenuSuite Content
Module 25: Automation ServerLessons - 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.
|
| |
