Build Finance and Operations Apps(MB500LP02)

Build Finance and Operations Apps
1 Topic
Learning Path Agenda
Module 1: Set Up a VHD
7 Topics
Introduction
Set Up a VHD for First-time Use
Set Up and Manage a Downloadable VHD for Development
Upgrade the VHD
Exercise – Install a Virtual Machine
Knowledge Check
Summary
Module 2: Start Developing
12 Topics
Introduction
Create and Build Projects
Demo – Create and Build Projects
Create and use labels
Manage Metadata by Using the Application Explorer
Build Deployment Packages
Demo – Build Deployment Packages
Synchronize Data Changes with the Database
Use the Element Designer to Create Elements
Exercise – Create a Project and Add an Element
Knowledge Check
Summary
Module 3: Get Started with Development Using X++
13 Topics
Introduction
Implement Base Types and Operators
Demo – How to Declare a Variable
Common Structured Programming Constructs of X++
Use X++ to Write SQL Statements
Use Conditional and Iterative Statements
Demo – Conditional Statements
Exception Handling
Use Const Values
Use X++ Runtime Functions for Common Tasks
Call .NET Libraries by Using X++ Code
Knowledge Check
Summary
Module 4: Develop Object-oriented Code
9 Topics
Introduction
Explore Inheritance and Abstract Classes
Use Attributes
Implement Chain of Command
Implement X++ Scoping and Access Identifiers
Interfaces
Exercise – Create an Extension by Using Chain of Command
Knowledge Check
Summary
Module 5: Implement Application Lifecycle Management
7 Topics
Introduction
ALM Methodologies
Design and Create Models
Plan the Build, Test, and Quality Control Processes
Plan the Release, Change, and Risk Management Processes
Knowledge Check
Summary
Module 6: Build Extended Data Types and Enumerations
6 Topics
Introduction
Extended Data Types and Element Properties
Base Enums and Element Properties
Exercise – Create a Base Enumeration, Add Elements, and Update Properties
Knowledge Check
Summary
Module 7: Build the ​ Data Model
11 Topics
Introduction
Create Tables and Table Fields
Populate Table and Field Properties
Add Fields, Field Groups, Indexes, and Relations
Table Methods
Create, manage, and extend views
Create, manage, and extend queries
Create, manage, and extend maps
Exercise – Create a Table, Add Fields, and Create Field Groups
Knowledge Check
Summary
Module 8: Build Forms and Optimize Form Performance
15 Topics
Objectives
Introduction
Add a New Form to a Project and Apply a Pattern
Demonstration: How to Add a Form to a Project and Apply a Pattern to the Form
Add a Data Source to a Form
Add Grids, Fields, and Groups to a Form
Form Methods
Create and Populate Menu Items
Create menus
Test Form Functionality and Data Connections
Diagnose and Optimize Client Performance
Optimize Form Loading and Performance
Exercise – Create a Form
Knowledge Check
Summary
Module 9: Create Classes
8 Topics
Objectives
Introduction
Add a Class to a Project
Add Code and Methods to Meet Business Requirements
Data Manipulation
Exercise – Insert Records by Using a Runnable Class
Knowledge Check
Summary
Module 10: Build Reports
13 Topics
Objectives
Implement Business Document Management
Create and Modify Reports that Use SSRS
Implement Query Objects and Query Builder: QBDS
Implement Query Objects and Query Builder: QBR
Implement Query Objects and Query Builder – Syntax
Implement Query Objects and Query Builder – Joins
Create and Modify Reports by Using Power BI
Demo – Connect to your Data by Using Power BI
Create and Modify Reports by Using Excel
Exercise – Create and Deploy a Report
Knowledge Check
Summary
Module 11: Build Workspaces
9 Topics
Objectives
Design KPIs – About
Design KPIs – Steps
Create Drill-through Workspace Elements
Create Custom Reusable Report Functions by Using RDL
Implement Built-in KPIs, Charts, and Other Reporting Components
Exercise – Create a Workspace and Add a Tile, List, Link, and Power BI Element
Knowledge Check
Summary
Module 12: Implement ​ Role-based Security
10 Topics
Objectives
Introduction
Create and Modify Duties, Privileges, and Permissions
Enforce Permissions Policy
Extensible Data Security Framework
Apply Security Permissions
Exercise – Create a New Security Role and Add Duties
Implement authorization to support integration
Knowledge Check
Summary
Module 13: Apply Basic Performance Optimization
16 Topics
Objectives
Introduction
Identify and Apply Caching Mechanisms
Create cached display methods
Optimize Temporary Table Usage
When to Use Set-based Statements and Row-based Operations
Query Optimization Principles
Optimize data migration
Modify the Scope of a Variable
Analyze and Optimize Concurrency
Apply Parallel Processing Algorithms
Implement the Async Framework
Develop Windows PowerShell scripts
Exercise – Create Runnable Classes in Visual Studio to ​ Test Code
Knowledge Check
Summary
Activity 1
1 Topic
Video: Extended data security
Activity 2
1 Topic
Lab 2: Create a new EDT table and form
End Section
1 Topic
Learning Path Recap
Previous Topic

Add a Data Source to a Form

To display content on a page in the user interface, a data source must be added to a form in the form designer window of Visual Studio. You can select and drag a table or query from your project in the Solution Explorer window or drag a system table from the Application Explorer window. You can choose to use one table or many tables, depending on the number of fields that you will use for your form.​

Alternatively, you can add a data source to your form by using the Data Sources node in the form designer.​

Follow these steps to add a data source from your project:​

  1. Ensure that your form is open in the form designer window in Visual Studio.​
  2. In the left pane of the designer, right-click the Data Sources node and select New Data Source.
  3. Select DataSource1 under the Data Sources node and go to the Properties window.​
  4. Select your table in the Table property drop-down menu. You can also select any table from the AOT node in this menu.​