Paradox 10: Level 2
Price: $ 59.00 (USD)
Add to Cart
Have a question about this course? Contact a representative.
Course Description
Paradox 10: Level 2
Course Type: Self-paced Courses
Estimated Time of Completion: 3 hour(s) 24 minutes
CEU Credits:
Language: English
Description: In this course, you will work with keyed tables by structuring them properly and by creating secondary indexes; organize tables in a database by following data-normalization rules; classify tables by determining types of relationships they have and create relationships between tables by linking and establishing referential integrity; create lookup tables; manipulate data; create custom forms; and create custom reports.
Objectives:
Working with Keyed Tables
Working with Key Fields
Secondary Indexes
Principles of Table Design
Designing Tables to Normalize Data
Normalizing Data for Fourth and Fifth Normal Forms
Principles of Table Relationships
Analyzing Table Relationships
Using the Data Model Designer
Establishing Referential Integrity
Data Validation Techniques
Working with Validity Checks
Working with Lookup Tables
Advanced Query Techniques
Sorting and Selecting Records
Searching for Special Characters
Using CHANGETO, INSERT, and DELETE Queries
Creating Table Relationships in Queries
Customizing and Automating Forms
Working with Memo Fields
Using Forms Based on Related Tables and Creating Launcher Forms
Enhanced Tabular Report Design
Tabular Report Design Enhancements
Using Page Layout and Print Settings
Back to Top
Course Type: Self-paced Courses
Estimated Time of Completion: 3 hour(s) 24 minutes
CEU Credits:
Language: English
Description: In this course, you will work with keyed tables by structuring them properly and by creating secondary indexes; organize tables in a database by following data-normalization rules; classify tables by determining types of relationships they have and create relationships between tables by linking and establishing referential integrity; create lookup tables; manipulate data; create custom forms; and create custom reports.
Objectives:
· After completing this tutorial, you will be able to create a key field, add records to a table, add duplicate data, and work with composite keys.
· Browser Netscape Communicator 4.0
· Browser Other: AOL 4.0
· Operating System MacOS 8.5
· Browser Microsoft Internet Explorer 4.0
· Operating System MS-Windows 95
Working with Keyed Tables
Working with Key Fields
Secondary Indexes
Principles of Table Design
Designing Tables to Normalize Data
Normalizing Data for Fourth and Fifth Normal Forms
Principles of Table Relationships
Analyzing Table Relationships
Using the Data Model Designer
Establishing Referential Integrity
Data Validation Techniques
Working with Validity Checks
Working with Lookup Tables
Advanced Query Techniques
Sorting and Selecting Records
Searching for Special Characters
Using CHANGETO, INSERT, and DELETE Queries
Creating Table Relationships in Queries
Customizing and Automating Forms
Working with Memo Fields
Using Forms Based on Related Tables and Creating Launcher Forms
Enhanced Tabular Report Design
Tabular Report Design Enhancements
Using Page Layout and Print Settings
More Information
| Language | English |
| Course Length | 3.00 hours |
| Duration of Access | 12 weeks |
| Instructor | Self Study |
| Vendor | Element K |
Price: $ 59.00 (USD)
Add to Cart