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
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
