What We DoThe core of OTS's business consists of custom application development and consulting services, including training in Geographic Information Systems and Microsoft® Office products. Training in other feasible software applications, such as applications developed by OTS, is also available.
Rental space and the rental of computers for technical computer training are also an integral part of the business.
OPTIMUM Technical Solutions, Inc. offers Authorized and On-Site training. Authorized training courses are courses with 10 students from different companies. On-Site training courses are conducted at your site or some other location with students from your company. Your company is to provide all equipment for the class; however, you have the option of utilizing OTS's facility or computer equipment. OTS will provide the software and course workbooks if applicable. Advantages to purchasing on-site courses are they can be schedule at your convenience, the more students you sign up the lower the training cost and they can be customized using your data.
We provide introductory, intermediate, and advanced training in the following applications:
Desktop Mapping Courses:
Introduction to MapInfo Professional® (2 days)Intermediate MapInfo Professional® (1 day)Advanced MapInfo Professional® (1 day)Geocoding with MapMarker® (1/2 day)Introduction to MapBasic® (2days)Vertical Mapper® (1 day)CallingAreaInfo® (1 day)TargePro® Demographics (1 day)TargePro® PYSTE Segmentation (1 day)Designing Web Pages with FrontPage 98Request Detailed Training Information or a Class ScheduleReturn to Home PageGo to Products PageIntroduction to MapInfo Professional
Two Day Course
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Microsoft® Windows 95, 3.1x, NT or XP) is a pre-requisite.
--------------------------------------------------------------------------------------------------------------
Unleash the power of MapInfo®. This course has been designed to include more hands on, problem solving exercises. You'll use MapInfo to create maps and visualize data on them. This course is instructed using the Windows operating system.
After completion of this course you'll be able to:
Utilize MapInfo's different views of data and its user interface
Understand and use MapInfo's map layering system
Use MapInfo's labeling features to annotate your map
Perform querying and geographic searching of maps and data
Open data files from Excel, Dbase, Access and delimited ASCII into MapInfo
Create thematic maps using various tables
Use the layout window and MapInfo®'s OLE capability to create output
Geocode database information
Use the tool manager to add and use MapBasic® utilities in MapInfo.
Course Outline:
Lesson 1. Displaying Your Data in MapInfo® Professional
Open MapInfo tables, view data in a Map and Browse data. Create 3D and other types of Charts and Graphs. Create and save a workspace.
Lesson 2. Developing Map Window Skills
Change a Map window's Zoom level using the Grabber, Zoom In, and Zoom Out buttons and menu commands. Set Map window options. View a single table in multiple Map windows.
Lesson 3. Mapping in Layers
Use Map > Layer Control. Add and remove layers from a Map window, reorder layers, set display options, use the Info button, and clone a Map window. HotLink objects with the HotLinking tool and launch URLs and files.
Lesson 4. Labeling
Interactive labeling, label settings, edit and save labels, add your own annotation. Save the Cosmetic Layer.
Lesson 5. Selecting I
Use the Select, Marquee Select, Radius Select, and Boundary Select buttons. Use Query > Select. Save selections and queries. Unselect map objects.
Lesson 6. Opening Data Files
Understanding MapInfo files. Open a Dbase file, spreadsheet, delimited ASCII file, and an MS Access table. Create a read/write version of a read-only table.
Lesson 7. Create Points
Assign point locations using Create Points using Longitude and Latitude coordinates. Make a table unmappable. Create custom symbols.
Lesson 8. Find
Use the Find command, respecify a search, find an intersection, and find a customer. Index a column.
Lesson 9. Geocoding
Assigning point locations using the Geocode command. Geocode to street address and 5-digit ZIP Codes interactively and automatically. Select records that fail to geocode. Discuss the use of result codes, increasing your hit rate, insets and outsets.
Lesson 10. Thematic Mapping I
Shade points and boundaries. Shade a table data from a separate table, edit a legend, and understand thematic layers. Embed thematic legend into the map.
Lesson 11. Using the Layout Window
Use the Layout window to create output. Work with frames. Create a cartographic legend. Specify output and printer settings.
Lesson 12. OLE
Create a clip region. Use the Clipboard to paste a map into other applications. Create graphic images from maps. Drop as a linked object into other OLE compliant software.
Intermediate to MapInfo ProfessionalÒOne Day Course
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Windows 95, Windows 3.1x, Windows NT or PowerMac) is a pre-requisite.
-----------------------------------------------------------------------------
Dig deeper into the functionality of MapInfo Professional! This course is designed to enable you to utilize more of the complex features available to you in MapInfo Professional. New courseware has been created to include additional modules to take back to your workplace. If you've already taken our Introduction to MapInfo Professional course or feel comfortable with the topics it covers, take the Intermediate class and get more from your MapInfo Professional software NOW!
Intermediate MapInfo Professional Course Covers:
Creating thematic maps using expressions, shading techniques, joins, pie charts and graduated symbols
An introduction to SQL Select
Using Update Column
Performing buffering operations
Map and map object creating
Registering raster images
Realigning territories through the Redistricter command
Wondering if the Intermediate level MapInfo Professional training is for you? Take our training quiz! This may help determine which level of MapInfo Professional is right for you!
Course Outline:
Lesson 1. Thematic Mapping II
Create Pie Chart Maps, proper use of Dot Density maps, shading on an expression. Shading one table with values from another table (joining). Effective color choice; dealing with zero values and other advice on creating cartographically sound thematic maps.
Lesson 2. Selecting II
Explanation of SQL. How to filter data, derive and format information. Aggregate, summarize, and sort information. Joining tables including performing a geographic join. Saving queries.
Lesson 3. The Update Column Command
Methods for "cleaning" a database. String parsing and functions, extracting characters from a column, updating a portion of a table (search and replace). Updating one table with information from another (performing a one column outer join).
Lesson 4. Buffering
Buffer around point and line objects. Searching for objects within the buffer using the Boundary Select button and save the results. Create a Convex Hull around a group of points.
Lesson 5. Creating Map Objects
Create a new map from scratch along with new associated tabular data; draw new objects, snap to nodes and autotrace. The Drawing Button Pad.
Lesson 6. Registering Raster Images
Register a raster image in MapInfo. Set control points, adjust display settings, the limitations of raster images, and display an unregistered image (i.e. company logo).
Lesson 7. Redistricting
Understand Redistricting and the Districts Browser. Assign map objects to a district. Modify a table's structure.
Advanced MapInfo Professional
One Day Course
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Windows 95, Windows 3.1x, Windows NT or PowerMac) is a pre-requisite.
-----------------------------------------------------------------------------
Dig deeper into the functionality of MapInfo Professional! This course is designed to enable you to utilize more of the complex features available to you in MapInfo Professional. New courseware has been created to include additional modules to take back to your workplace. If you've already taken our Introduction to MapInfo Professional course or feel comfortable with the topics it covers, take the Advanced class and get more from your MapInfo Professional software NOW!
Advanced MapInfo Professional Course Covers:
Advanced thematic mapping techniques, creating grid thematics and 3D maps
Advanced SQL select querying
Editing workspaces, using the MapBasic window and editing the MapInfo .MNU file
Editing map objects and finding spatial data problems
Connecting and using a map in a remote database through ODBC
Using seamless map sheets.
Importing and exporting map files using the Universal Translator and Table> Import/Export.
Course Outline:
Lesson 1. Thematic Mapping III
Create bivariate thematic maps (for example a map where the color of the symbol represents one variable and the shape of the symbol another variable). Create inflection point maps (using two sets of colors in a map at once to represent a dividing point in your data). Shade regions twice using "see through" patterns. Create grid thematics. Use thematic templates. Create 3D Maps and change 3D options and viewpoint control.
Lesson 2. Selecting III
Geographic querying, (using geographic operators and functions). Calculate the length of streets, calculate distances, and determine which object a point is closest to, create circles and use other MapBasic functions in SQL. Use Sub-selects.
Lesson 3. MapBasic Tricks for MapInfo
Use the MapBasic window to record and execute MapBasic commands. Alter MapInfo's standard interface (menu items, Button Pads) using the MapInfow.mnu file. Edit workspaces.
Lesson 4. Editing Map Objects
Use the Snap feature, reshaping map objects. Combine objects together, erase portion of an object, and split an object into two or more pieces. Pack a table. Finding Spatial Data Problems. Correct problems using Check Regions, Objects>Enclose and Objects > Convert to Polyline. Pushpin records on to a map (manual geocoding).
Lesson 5. Seamless Table Manager
Create and use a seamless map sheet. How to combine several tables into a single virtual table, seamless map sheets explained. Benefits of using seamless map sheets.
Lesson 6. ODBC Basics with MapInfo Professional
Install ODBC support and drivers. Download an ODBC table; create a MapInfo Map Catalog. Make an ODBC table mappable. Save changes to a remote table.
Lesson 7. Importing Map Files
Use the MapInfo Universal Translator to import and export the various different types of map files in the industry: AutoCAD, ESRI Shape, and Intergraph/Microstation Design files. Create a MapInfo Interchange file. Use MapInfo's Table > Import command to import a Drawing Export Format (.DXF) file from a CAD package.
Geocoding with MapMarker/Developing with MapMarkerEach course will take one-half day
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Windows 95, Windows 3.1x, Windows NT or PowerMac) is a pre-requisite.
-----------------------------------------------------------------------------
The Geocoding with MapMarker class will enable you to make the most of MapMarker, including understanding geocoding options and balancing between high hit rates and geocoding accuracy. Concepts about geocoding are also covered.
Developing with MapMarker focuses on embedding MapMarker into a Visual Basic application through the use of the OCX.
Geocoding with MapMarker
Course Outline
What is MapMarker
An introduction to MapMarker (hands-off). Defining the geocode, three questions to ask before geocode, MapMarker and its components and installation issues.
Using MapMarker
Preparing your data file before geocoding, geocoding automatically, automatically with options, interactive geocoding, displaying geocoded information in MapInfo, comparing input and output addresses, geocoding strategies, interpret and use Result Codes.
MapMarker Utilities
Create a customized user dictionary, make address, system preferences, using MapBasic applications, FindAddress and EasyMarker .
Developing MapMarker
This class focuses on embedding MapMarker into Visual Basic application through the use of an OCX, and using the MapMarker API.
TargetPro Demographic Analyzer or TargetPro Cluster Analyzer
Each course will take one day
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Windows 95, Windows 3.1x, Windows NT or PowerMac) is a pre-requisite, also a working knowledge of MapInfo Professional.
--------------------------------------------------------------------------------
Using TargetPro Demographic Analyzer, you can identify key market areas and analyze demographic variables for trends and outliers, both necessities in today's corporate world. In this training, you will learn to "slide-and-dice" your data, gather demographic statistics, create reports, display your data within MapInfo and create index bases for database comparisons.
In the TargetPro Cluster Analyzer class, you will learn how to make selections, target clusters, output your data, view and compare profile sets. The TargetPro retrieval methodology will also be covered.
This class is taught using MapInfo's TargetPro engine. If your business applications require the use of demographic mapping, reporting and database building, this class is for you. In addition to learning about TargetPro's amazing power as a standalone reporting and demographic retrieval engine, you will gain a complete understanding of how TargetPro seamlessly works with MapInfo Professional, MapMarker and other Microsoft Windows applications. More importantly, you will gain insight into applying TargetPro data toward solving simple to complex business problems.
Course Outlines:
TargetPro Demographic Analyzer
Lesson 1: Introduction to TargetPro
What is TargetPro? Who can benefit from TargetPro?
Lesson 2: Using the TargetPro Demographic Analyzer
Opening TargetPro workspaces and using the Demographic Analyzer interface. Picking geographies, standard geographies and other geographies. Legend interpretation. How to create output such as reports.
Lesson 3: Modifying Report Variables
Practice creating a Summary Report and a Rank Report. How to choose simple variables and create custom variables. Calculating percentages, population density, averages and summarizing variables. Saving a workspace for future reference.
Lesson 4: Integrating TargetPro with MapInfo
Create a table of simple and custom demographic variables. Output to a MapInfo .tab file. Open output into MapInfo Professional. Thematically shade geographies to display variables created in TargetPro. Perform geographic or database functions, create a layout and printing data and maps in MapInfo Professional. Learn how to use TargetPro from within MapInfo Professional.
Lesson 5: Building Customized Data
Create a Virtual Geography File (VGF). Registering VGFs. Combine geographies in MapInfo Professional to create a custom geography. Adding custom geographies to TargetPro.
Lesson 6: Working with an Index Base
Create an Index Base from data. Compare Index Base to a potential market area for analysis.
TargetPro Cluster Analyzer
Lesson 1: Introduction to TargetPro
What is TargetPro? How can you benefit from TargetPro Cluster Analyzer?
Lesson 2: Using the TargetPro Cluster Analyzer
Planning your analysis. Maneuvering within the Cluster Analyzer interface. Workspace and selection tabs. Selecting profiles and analyzing output and charts.
Lesson 3: Creating New Profiles
Creating a new geographic profile. Creating a profile from a database. Cluster coding a database. Adding a profile with filtering. Analysis using profiles. Saving workspaces in cluster analyzer.
Lesson 4: Comparing Cluster Profiles
Analyze, Using, Target Clusters, and Output tabs. Comparing geographic data with survey data. Determining potential customers and market potential. Using output options.
Lesson 5: Integrating TargetPro with MapInfo
Analyzing geographic areas to determine market potential. Creating a MapInfo .tab file as output. Displaying output in MapInfo Professional. Creating a thematic map and customizing maps in MapInfo Professional.
Lesson 6: Building Output
Build rank profiles based on their correlation to one or more other profiles. Ranking a report by correlation. Specifying target clusters. Customizing a report.
Introduction to Vertical MapperTwo Day Course
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Windows 95, Windows 3.1x, Windows NT or PowerMac) is a pre-requisite.
-----------------------------------------------------------------------------
This course is taught using Vertical Mapper. The introductory course is designed to demonstrate and explore the core features of Vertical Mapper. End users will benefit from this dynamic hands-on course by gaining an understanding of grid technology and "smart raster" analysis.
Also available is Train-the-Trainer class for Vertical Mapper. For more information or to enroll, call 613.224.2020 or 888.886.0381.
The Introduction to Vertical Mapper Course Covers:
Grid Creation
Triangular Irregular Network
Inverse Distance Weighting
Rectangular Interpolator
Colorizing a Grid
GridView
Contouring a Grid
Data Aggregation
Grid Math
Natural Neighborhood Analysis
Viewpoint Analysis
Location Profiler Model
Trade Area Analysis (Huff Model)
Using and Applying CallingAreaInfo
One Day Course
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Windows 95, Windows 3.1x, Windows NT or PowerMac) is a pre-requisite, along with a working knowledge of MapInfo Professional. Class sizes are limited to 10.
-----------------------------------------------------------------------------
Introduces telecommunications professionals to defining and visualizing local calling plans and areas. Lessons include software installation; main dialog; interactive mode (using the Tariff Plan Viewer, Quick Select, and output options); batch mode (creating a batch file, using the Batch Wizard, and output options); outputs (relational database, export formats, maps); and application exercises (interactive, batch and output).
This hands-on class is taught using MapInfoDATA's CallingAreaInfo v5.0 engine to define and visualize local calling plans (residential or business) available when calling out from or into a location. If you're a telecom marketing or engineering professional involved in network planning, competitive analysis, strategic evaluation, market expansion, billing system administration, operations management, or enhancing client services, this course is for you. You will gain a complete understanding of how CallingAreaInfo works seamlessly with MapInfo Professional and ExchangeInfo PLUS (MapInfo's comprehensive telecom infrastructure database), and how it can read/write to numerous file formats - including Microsoft Access relational database. More importantly, you will gain insight into applying CallingAreaInfo towards addressing business challenging and capturing marketing opportunities in the highly volatile telecom landscape.
Course Outline
Installing the software and updates
Using the CallingAreaInfo main dialog
Running a Call Out or Call In Analysis to generate a list of NPA/NXX combinations and mapping the corresponding wire center geographic boundaries
Distinguishing rates based on cost
Generating a calling area analysis on one particular NPA/NXX combination, selecting which calling plans and rate steps to include
Running multiple NPA/NXX combinations automatically, using a simple step-by-step process to select analysis parameters
Generating Call In, Call Out reports
Outputting Tables (map, detail, rate and wirecenter) related by common ID field
Exporting databases in multiple file formats -- including Access (native format) and HTML
Producing maps -- create MapInfo workspace, separate business and residential calling plan analyses, thematically shade by rate step, determine wire center inclusion, option to combine wire center boundaries, display Central Office (CO) location of target NPA/NXX.
Using context-sensitive help and glossary
Applying CallingAreaInfo to sample telecom industry scenario's
Introduction to MapBasic Development Environment v6.0
Two Day Course
Contact us for information on holding a training class on-site at your location.
Important: A thorough knowledge of graphical interfaces (Windows 95, Windows 3.1x, Windows NT or PowerMac) is a pre-requisite.
-----------------------------------------------------------------------------
In this course, you'll learn to utilize our programming language to customize MapInfo Professional.
This comprehensive introductory course will cover the syntax of MapBasic, as well as examining and coding programs that will automate repetitive tasks, extend MapInfo Professional's capabilities and more. This course has been enhanced to include all new programs/projects designed for MapInfo Professional. A thorough knowledge of MapInfo Professional is required. Previous programming experience is helpful, especially with some form of a BASIC language. This course is instructed using MapInfo Professional and MapBasic.
Please bring your MapBasic Reference Manual to the class.
Course Outline:
Lesson 1. Introduction to MapBasic
What is MapBasic? Three ways to utilize MapBasic. Examining workspaces to take note of MapBasic Statements. Typing in MapBasic commands into the MapBasic window in MapInfo Professional
Lesson 2. The MapBasic Development Environment
The MapBasic program structure. Global-level statements, sub-procedures and the Main sub-procedure. Writing your own simple MapBasic program.
Lesson 3. Understanding Variables and Functions
Declaring and assigning values to variables. Defining arrays, user-defined data types and constants. Using comparison, logical and geographic operators and functions in MapBasic programs.
Lesson 4. Creating the User Interface with MapBasic
Creating and manipulating dialog boxes and their controls. Syntax and specifications needed to build a custom dialog. Types of dialogs, sizes and positions. Writing a custom dialog in MapBasic.
Lesson 5. Debugging a MapBasic Program
Handling compiler errors. The Note, Print and Stop statements. Run-time error trapping. Studying an example of Error Trapping.
Lesson 6. Working with Menus
Menu and event-driven programming. Menu fundamentals. Adding custom menu items to existing menus. Removing menus from the menu bar. Creating entirely new menus. Creating a custom menu in MapBasic.
Lesson 7. Customizing ButtonPads
Adding custom buttons to existing ButtonPads. Creating new Buttonpads. Using MapBasic to customize your own buttons.
Lesson 8. Manipulating Tables and Objects
MapBasic statements used to create maps, browsers, layouts, graphs and redistricting sessions. An example on how to use MapInfo's animation layer for quickly updating point location display. Editing tables and creating graphical objects.
Lesson 9. Thematic Mapping Using MapBasic
Creating thematic maps with MapBasic, the shade statement, using arrays to store range values and style values.
Lesson 10. Program Control and System Events
Flow control, branching and loops. Definition of a system event and an event handler. Event handler procedures, using the CommandInfo( ) function.
Lesson 11. Obtaining System Information
Using functions to find out information about the MapInfo system environment.
Lesson 12. Using SQL Select
Use the SQL Select statement in programs. Covers its clauses and operators.
The approach to this course is project oriented. As different topics are covered, small pieces of code will be written which contribute to a MapBasic program. The result at the end of the class is a working program.
Microsoft Word 2000 Level 1 Course Overview: Students will learn the introductory features of Word 2000. Topics covered in this course include working with text, formatting, working with files and folders and printing documents.
Course Length: 1 Day
Prerequisites: Windows 95 or 98 Introduction or equivalent experience.
COURSE OUTLINE
Looking At Word Working with Files and Folders
Understanding Word Using Folders
Examining The Project Working with Folders
Using Word Finding Files
Examining The Working Screen Using Multiple Views
Navigating Documents Exploring views
Entering Text
Saving Files
Using Wizards and Templates
Understanding Wizards and Templates
Using Editing Functions Using a Wizard
Selecting And Replacing Text Replacing Fields in Templates
Understanding Toolbars And Menus Creating a Document from a Template
Working With Text
Using The Clipboard
Using Drag-and-drop Printing Documents
Finding And Replacing Text Understanding Non-printing Characters
Checking Spelling And Grammar Previewing Documents
Using Other Grammar Rules Working with Margins and Alignment
Adjusting Print Settings
Printing Documents
Formatting Text Exiting Word
Working With Fonts
Adjusting Point Size
Changing Font Attributes
Applying Character Effects
Aligning Text
Using Formatting Techniques
Applying Borders And Shading
Applying Bullets And Numbering
Indenting Paragraphs
Using Format Painter
Working With Graphics
Modifying Graphics
Microsoft Word 2000 Level 2Course Overview: This course will teach students the Intermediate features of Microsoft Word 2000. Topics covered include preparing documents, using word elements such as header and footers, tabs and styles, using, modifying and inserting graphs and creating tables.
Course Length: 1 Day
Prerequisites: Windows Introduction and Word 2000 Level 1 or equivalent experience.
COURSE OUTLINE
Preparing Documents Creating Tables
Looking at this Course Understanding Tables
Examining the Project Inserting Tables
Formatting Page Setup Working in Cells
Applying Borders and Shading Formatting Tables
Working with AutoText Applying Formatting Techniques
Using AutoCorrect Working with Borders and Shading
Working with Symbols
Working with Word Features
Using Word Elements Looking at WordArt
Understanding Headers and Footers Using WordArt
Using Tabs Editing WordArt
Inserting Automatic Page Numbers Previewing Documents
Understanding Styles
Applying Styles
Exploring Output Options
Preparing and Printing Envelopes
Laying Out A Document Working with Labels
Inserting Text from Another File Preparing a Document for the Web
Working with Indents Working with Hyperlinks
Using Breaks and Spacing Sending a Document Via E-mail
Inserting Columns
Understanding Sections
Using Outline Numbered Lists
Working with Graphics
Using Graphics
Modifying Graphics
Inserting a Graphic and Setting Options
Using the Drawing Toolbar
Working with Text Boxes
Microsoft Excel 2000 Level 1Course Overview: Students will learn the introductory features of Microsoft Excel 2000. Topics covered include entering text and formulas, moving and copying data, formatting worksheet appearance and working with charts.
Course Length: 6 Hours
Prerequisites: Windows 95, or Windows 98 Introduction or equivalent experience.
COURSE OUTLINE
Getting Started Formatting Worksheet Appearance
Understanding Excel Adjusting Rows and Columns
Examining the Projects Formatting Numbers
Examining the Excel Window Aligning Text
Opening a Workbook Formatting Text
Applying Borders and Shading
Entering Text and Formulas
Entering and Editing Data
Working with Columns and Rows Working with Charts
Understanding Formulas Understanding Charts
Understanding Functions Creating Charts
Using Paste Function Modifying Charts
Entering More Formulas Finishing the Chart
Moving and Copying Data
Looking at the Office Clipboard Printing Worksheets
Cutting, Copying and Pasting Understanding Printing
Moving Cells Adjusting Page Setup
Using Fills Setting up Headers and Footers
Setting Print Titles and Options
Setting Print Areas
Exploring Formula Construction
Understanding Cell References
Using Relative References
Using Absolute References
Using More Functions
Microsoft PowerPoint 2000 Level 1Course Overview: Students will learn the introductory features of PowerPoint 2000. Topics covered include creating presentations, working with slide masters, and working with visual elements, such as how to add clip art and how to draw shapes.
Course Length: 6 Hours
Prerequisites: Windows 95 or 98 Introduction or equivalent experience.
COURSE OUTLINE
Looking At PowerPoint 2000 Adding Tables to Slides
Understanding PowerPoint Understanding Tables
Examining the Project Making Tables
Exploring the PowerPoint Window Adding Information to Tables
Navigating Presentations Formatting Text in Tables
Creating Presentations
Using the AutoContent Wizard
Finalizing a Presentation
Deleting Slides
Working in Normal View Rearranging in Slide Sorter View
Using the Slide Pane Understanding Transitions
Working in the Outline Pane Creating Transitions
Using The Notes Pane Previewing Transitions
Working With Slide Masters Viewing the Presentation
Understanding Slide Masters Previewing a Presentation
Opening Masters Using Slide Show View
Trying Out Different Design Templates Applying Options in Slide Show View
Adjusting Headers and Footers Checking and Replacing Text
Changing Placeholders Printing Handouts
Setting Font Formatting For All Slides
Using AutoNumbering
Incorporating Visual Elements
Adding Clip Art
Drawing Shapes
Changing Colors of Shapes
Assembling Shapes
Microsoft Access 2000 Level 1Course Overview: This course teaches students the introductory features of Microsoft Access 2000. Topics covered include working with tables, working with and filtering data, exploring queries and creating reports.
Course Length: 1 Day
Prerequisites: Windows introduction or equivalent experience.
COURSE OUTLINE
Introducing Access Using Forms
Looking At Access Understanding Forms
Examining The Projects Using the form Wizard
Understanding Database Design Entering Data in a Form
Using Database Wizards Working in Design View
Exploring A Database Formatting Form Controls
Using the Office Assistant
Closing Access
Filtering Data
Finding Records
Working With Tables Filtering by Selection
Understanding Tables Filtering by Form
Using Design View Sorting Filtered Records
Saving And Closing Tables
Opening A Table
Modifying Columns And Rows Exploring Queries
Using The Table Wizard Understanding Queries
Working With Field Properties Creating Single-table Queries
Using the Query Wizard
Working With Data Creating Multi-table Queries
Entering Data
Importing Data
Importing Data To A New Table Creating Reports
Sorting Data Understanding Reports
Deleting Data Creating AutoReports
Using the Report Wizard Previewing Multiple Pages
Creating Relationships Printing Reports
Establishing Relationships
Enforcing Referential Integrity
Printing And Saving Relationships
Using Subdatasheets
Microsoft Access 2000 Level 2Course Overview: Students will learn the intermediate features of Access 2000. Topics covered include working with tables and data, working with HTML and Hyperlinks, using the query Wizard, and customizing reports. Students will also learn how to maintain databases by back-up, as well as compacting and repairing them.
Course Length: 6 Hours
Prerequisites: Windows Introduction and Access 2000 Level 1 or equivalent experience.
COURSE OUTLINE
Expanding Tables Customizing Reports
Looking at this Course Using Report Sections
Examining the Projects Modifying Report Controls
Examining Tables in Design View Changing Format Properties
Modifying Tables in Design View Adding Controls
Adjusting Data Types Using Calculated Controls
Changing Field Properties
Using Default Values
Exploring Indexes Working with HTML and Hyperlinks
Understanding Access on the Web
Creating Web Documents
Working with Data Understanding Hyperlinks
Looking at the Office Clipboard
Copying and Pasting Data
Understanding the Lookup Wizard Looking at Database Maintenance
Using the Input Mask Wizard Backing Up Databases
Compacting and Repairing Databases Using Name AutoCorrect
Modifying Forms Printing Database Objects
Exploring Form Sections
Using Form Sections
Binding Controls and Data
Using Calculated Controls
Adding Other Controls
Creating Queries
Using the Query Wizard
Adding Tables and Fields
Specifying Criteria
Working with Query Fields
Creating Action Queries
Creating Calculated Fields
CHECK BACK FOR: Designing Web Pages with FrontPage 98