Approach Millennium

Approach Millennium

In this tutorial, you’ll learn about the Approach work area and to use the SmartMaster to create a sample application. You’ll create a blank database, enter records, and move a field. You’ll join two databases, then create a repeating panel. You’ll also create a Form view, then add a bitmap to a form. You’ll create a Report view, and explain Printer Setup, then create a Mailing Label view. Finally, you’ll create a Form Letter view.

Lotus Approach Millennium Edition is a relational database forming part of the SmartSuite office applications suite. This course is designed to allow readers to get to grips with the basic features of Approach. Readers will be able to create databases; view data, design data queries and produce reports. The course also provides an introduction to database theory and practice, plus hints and tips on good database design techniques.

Module 0: Defining Database Concepts
| Working with Databases and File Types
Defining Records and Fields
Using Relational Databases


| Module 1: Starting Approach
| Starting Approach
Opening and Closing a File
Using the Approach Interface
Defining the Action Bar and the Status Bar


| Module 2: Creating a Database
| Creating a Database
Saving An Approach File
Entering Data in a Form and Worksheet View
Adding and Viewing Records in a Form and Worksheet View
Switching Views


| Module 3: Creating a Custom Database
| Customizing a Smartmaster Template
Naming, Deleting, and Inserting Fields
Changing Field Definitions and Field Order
Creating An Approach File


| Module 4: Using a Worksheet View
| Using and Splitting a Worksheet View
Changing Column Width, Column Headers, and the Row Height
Moving, Adding, and Deleting Columns in a Worksheet


| Module 5: Editing Data
| Using the Go To Record Feature
Editing Data in a Field
Finding and Replacing Text
Duplicating and Deleting a Record


| Module 6: Sorting Data
| Defining Sort Order
Sorting Records
Clearing and Saving a Sort
Using the Sort Dialog Box
Sorting By Multiple Fields
Applying a Named Sort


| Module 7: Printing Records
| Printing a Record, a Range of Records, and a Worksheet


| Module 8: Creating a Custom Worksheet
| Using the Worksheet Assistant
Adding Worksheet Fields


| Module 9: Finding Records
| Using the Find Environment
Finding a Unique Record and Multiple Records
Showing All Records
Sorting a Found Set
Saving a Find
Applying a Named Find
Using Wildcards and Comparison and Logical Operators


| Module 10: Using the Find Assistant
| Using the Find Assistant
Performing a Basic Find
Editing a Named Find
Finding Duplicates, Distinct Records, and Top Or Lowest Values


| Module 11: Working in the Design Environment
| Using the Design Environment
Displaying the Rulers
Moving and Resizing Objects
Changing the Tab Order
Saving the Approach File


| Module 12: Formatting Objects
| Using the Infobox
Formatting Data Text, Label Text, and Numeric Data
Applying Borders
Using Fast Format
Editing Text in a Text Box


| Module 13: Manipulating Views
| Duplicating and Formatting a View
Editing View Tabs
Deleting and Rearranging Views


| Module 14: Working with Files
| Opening a Database File
Using Save As
Mapping Fields
Editing File Properties
Deleting Files
Assigning a Password


| Module 15: Using Smartmaster Applications
| Working with Smartmasters
Opening and Using a Smartmaster

Students will learn how to manipulate multiple databases, create crosstabs and charts to summarize data, create macros, and customize the Approach environment.
LESSON 1: Copying, Importing, and Exporting Data
Using an Existing Approach File to Create a Database
Importing and Exporting Files

LESSON 2: Managing Multiple Databases
Exploring Approach Preferences
Data Normalization
Analyzing Relationships and Joining Databases

LESSON 3: Advanced Form Design
Repeating Panel Forms
Form Enhancements

LESSON 4: Advanced Report Design
Repeating Panel Reports
PowerClick Reporting

LESSON 5: Analyzing Data
Creating Worksheets and Crosstabs
Charting Data

LESSON 6: Form Letters and Mailing Labels
Creating Form Letters and Mailing Labels

Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>