Northwest Computer Learning Center's Course Schedule, Brochure, and Course Outlines are in PDF format.

Select the link below to download the free Adobe Reader software.

Adobe Reader Adobe Reader

Databases

Microsoft Access

Course Title: Access Level Itypical

2016/2013/2010 adobe2007 Outline adobe

Description: Learn database concepts and terminology and how to navigate an existing database and use tables, forms, queries, and reports. Learn to add and edit table data, apply filters & sorts, and include a Total Row. Learn to create tables and how to control the type of data that is added to them. Learn about Primary Keys and Table Relationships. Learn how to create and use queries, design forms, develop reports, database development principles, relational concepts, and data validation techniques.
Audience: Designed for experienced PC users with limited database management experience.
Prerequisite: Office applications

Course Title: Access Level II advanced

2016/2013/2010 adobe2007 Outline adobe

Description: Learn ways to streamline and customize Microsoft Access. Get started with a quick review of topics detailed in the Level I course such as creating tables, Primary Keys, table relationships, as well as query basics. Gain an understanding of join types and the affect they have on query answers. Learn to work with queries that update, delete, and add information to tables, as well as queries that create tables, and prompt the user for criteria. Learn to create reports based on tables and queries and format those reports. Learn to create data entry forms that include check boxes, drop-down lists, tab controls, and option buttons. In this class you will learn to create a user menu system and macros to control user navigation.
Audience: Designed for individuals familiar with Access fundamentals
Prerequisite: Microsoft Access Level I

Course Title: Access Queries typical Outline adobe
Description: This class is designed for individuals interested in unleashing the power of Access queries. Topics include using criteria, more advanced table links, queries on queries, action queries, calculations in queries, and an introduction to SQL.
Audience: Individuals using Access to perform advanced data manipulation.
Prerequisite: Microsoft Access Level I.

Course Title: Access Reports typical Outline adobe
Description: This class is designed for individuals interested in creating more powerful reports in Microsoft Access. Topics include report design, using queries with the report, performing calculations in reports, pictures and charts on reports, creating reports from multiple data sources, and creating sub-reports.
Audience: Individuals who want to expand their knowledge of creating reports in Microsoft Access.
Prerequisite: Microsoft Access Level I.

Course Title: Access Advanced Form Designtypical Outline adobe
Description: Students will learn advanced options for creating forms in a Microsoft Access database. Learn to design forms from scratch, add macros to forms, create a menu system so users can easily navigate the database, use forms as query criteria, learn to use various form controls, learn to use form properties, learn to add a Splash Screen to the database, and more.
Audience: Individuals who want to expand their knowledge of creating forms in Microsoft Access.
Prerequisite: Microsoft Access Level I

 

Crystal Reports

Course Title: Crystal Reports Level Iadvanced Outline adobe
Description: Designed for individuals new to Crystal Reports. In this 2-day course you will become familiar with the Crystal Reports interface. You will learn how to connect to the data the report will represent and then how to create reports using a wizard and from scratch. You will learn to format, sort, and filter those reports. You will learn to enhance the appearance of the report with graphics and drawn objects. You will learn how to sort and filter report data and how to organize report data into groups. You will also learn to create basic formulas and add them to the report. You will learn how to use conditional formatting, create reports based on Excel data, and how to export Crystal Reports to other file formats.
Audience: Designed for individuals with some knowledge of database management.
Prerequisite: Microsoft Access Introduction or similar database experience.

Course Title: Crystal Reports Level IIadvanced Outline adobe
Description: Learn more ways to streamline and customize your Crystal Reports. Use advanced formatting techniques, advanced formulas, and other tools to get the best results from your database.
Audience: Designed for users who want to explore more advanced features of Crystal Reports.
Prerequisite: Crystal Reports Introduction.

FileMaker

Course Title: FileMaker Introduction typical Outline adobe
Description: Topics include: database development basics, field definitions, record management, using relationships, managing files, understanding formulas, expressions and constants, understanding layouts, object types, working in Browse mode, previewing and printing, and importing and exporting data.
Audience: Designed for individuals interested in learning FileMaker Pro basics.
Prerequisite: Windows Introduction.

Course Title: FileMaker Level IItypical Outline adobe
Description: Learn how to streamline your databases and use more advanced tools.
Audience: Designed for students who need more advanced training in FileMaker Pro.
Prerequisite: FileMaker Pro Introduction.

Back to Course Categories