Skip to end of metadata
Go to start of metadata

This course enables system administrators and configurers to configure the database by creating and modifying tables in the system and creating windows for these tables.

 Creating Tables, Views, and Imports: Lesson 1 Overview

 Creating Tables, Views, and Imports: Lesson 1.1 Screens and General Functionality of Tables, Views, and Imports

Screens and General Functionality related to tables, views and imports

 Creating Tables, Views, and Imports: Lesson 2 Tables

 Creating Tables, Views, and Imports: Lesson 2.1 Table Tab of the Tables Screen

 Creating Tables, Views, and Imports: Lesson 2.2 Columns Tab of the Tables Screen

 Creating Tables, Views, and Imports: Lesson 2.3 Indexes Tab of the Tables Screen

 Creating Tables, Views, and Imports: Lesson 2.4 Java Triggers Tab of the Tables Screen

 Creating Tables, Views, and Imports: Lesson 3 Creating Tables

 Creating Tables, Views, and Imports: Lesson 3.1 Creating a List Table

 Creating Tables, Views, and Imports: Lesson 3.2 Creating a Location Table

 Creating Tables, Views, and Imports: Lesson 4 System-Wide Columns

 Creating Tables, Views, and Imports: Lesson 4.1 Columns Window


 Creating Tables, Views, and Imports: Lesson 4.2 Adding a New Column to a Table

 Creating Tables, Views, and Imports: Lesson 4.3 Adding an Existing Column to a Table

 Creating Tables, Views, and Imports: Lesson 4.4 Modifying Column Definitions

 Creating Tables, Views, and Imports: Lesson 4.5 Auditing a Column Using Record History

 Creating Tables, Views, and Imports: Lesson 4.6 Creating Calculated Columns

 Creating Tables, Views, and Imports: Lesson 4.7 Creating the Table

 Creating Tables, Views, and Imports: Lesson 5 Creating Screens

 Creating Tables, Views, and Imports: Lesson 5.1 Creating a Screen for Setup Data

 Creating Tables, Views, and Imports: Lesson 5.2 Creating a Main Menu Screen

Audience

  • System Administrators involved in an AgileAssets implementation
  • New System Administrators being brought on to assist with an existing AgileAssets implementation

Prerequisites

Required: Basic Navigation Video Lessons Recommended:  Basic Reporting Video Lessons

Content

After taking this course you should be able to:

  • Define columns/fields and their properties
  • Create or change tables in the database
  • Create and modify calculated columns
  • Create or change views in the database
  • Create new screens from tables and views
  • Register tables and views for use in reports
  • Create imports
  • No labels