nullModule 4 创建数据网格、数据
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
单
和工作区 |
Module 4 创建数据网格、数据表单
和工作区Creating Data Grid \Data Entry Forms\ Workspaces Creating Data Grid \Data Entry Forms\ Workspaces
You can create workspaces and data entry forms for frequently
performed tasks. Workspaces enable users to access tasks without
navigating the product. Data entry form provide predefined rows and
columns for data entry.
Lessons in this unit include:
Creating Data Grid
Creating Data Entry Forms
Creating Workspaces |
Accessing Data GridsAccessing Data Grids |
Changing the Grid LayoutChanging the Grid Layout |
Selecting Members for DimensionsSelecting Members for Dimensions |
Selecting MembersSelecting Members |
Member ListsMember Lists |
Saving Data Grid SettingsSaving Data Grid Settings |
Entering DataEntering Data |
Cell Color
• Green: Green cells contain calculated data. Calculated cells are read-only and do not accept user input.
• Off-white: Off-white cells are input cells that accept data entry.
• Red: Red cells are at an invalid intersection of dimension members. You cannot enter data in invalid cells.
• Yellow: Yellow cells contain data that was modified but not saved.Filling Multiple CellsFilling Multiple Cells |
Spreading DataSpreading DataYou can spread data from summary time periods to base time periods. |
Calculating DataCalculating Data |
Adding Cell TextAdding Cell Text |
Creating Data Entry Forms Creating Data Entry FormsBy the end of this lesson, you should be able to:
Describe data entry forms
Define the point of view
Define rows and columns
Set row and column options
Set row and column defaults
|
About Data Entry FormsAbout Data Entry Forms |
Data entry forms are templates with predefined row and columns that users can use to input and view specified data elements. Users cannot add or remove rows or columns on a data entry form.
Users can change point of view selection on a data entry form only for the dimensions that you specify when you set up the form. For example, you can set up the point of view for a form so that users can select the period but not the scenario and entity for which they want to enter data.null |
Form BuilderTo define a data entry form, you use the options on the Form Builder tabs.null |
Defining the Point of Viewnull |
Defining Columns and Rowsnull |
Setting Row and Column Optionsnull |
Setting Row and Column DefaultsUse the Details tab to set default display options for all rows and columns
on the form.null |
Setting Headers Defaults Creating Workspaces Creating Workspaces |
By the end of this lesson, you should be able to:
Describe workspaces
Create workspaces
Add items to workspaces
Organize work spacesnull |
About WorkspacesYou can set up a workspace on the Web that contains items and tasks that you use frequently, including data entry forms, data grids, and reports. Setting up a workspace enables you to complete your workflow without navigating among forms, grids, and report modules.null |
Creating Workspaces Adding Items to WorkspacesAdding Items to Workspaces |
Organizing WorkspacesOrganizing Workspaces |
null |
End