Microsoft Word Training: Advanced
Mar
29
8:00 am08:00

Microsoft Word Training: Advanced

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here. 

 

Microsoft Word: Advanced (Level 3 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create and distribute a form.
  • automate tasks by writing and revising macros.
  • create references to information in a document.
  • prepare a document for publication.
  • revise documents based on feedback provided by other users.

Course Content

Lesson 1: Creating and Distributing Forms

Topic 1A: Create a Form Template

Topic 1B: Insert Fields in a Form Template

Topic 1C: Protect the Form

Topic 1D: Test a Form

Lesson 2: Automating Tasks

Topic 2A: Run Macros

Topic 2B: Record a Macro

Topic 2C: Edit a Macro

Topic 2D: Create Toolbar Buttons

Topic 2E: Create Custom Menus

Lesson 3: Referencing Document Information

Topic 3A: Insert Bookmarks

Topic 3B: Insert Footnotes and Endnotes

Topic 3C: Add Captions

Topic 3D: Create Cross-References

Lesson 4: Preparing a Document for Publication

Topic 4A: Set Book Margins

Topic 4B: Create Custom Headers and Footers

Topic 4C: Compile a Table of Contents

Topic 4D: Index the Document

Topic 4E: Create a Master Document

Lesson 5: Revising Documents

Topic 5A: Create Document Versions

Topic 5B: Distribute a Document

Topic 5C: Track Changes to a Document

Topic 5D: Review Document Changes

Lesson 6: Modifying an HTML Page

Topic 6A: Save Word Documents as Web Pages

Topic 6B: Edit Web Pages in Word

Topic 6C: Insert Scrolling Text

Topic 6D: Place a Movie Clip in a Web Page

Topic 6E: Insert a Background Sound

Microsoft Access: Introduction
Apr
5
8:00 am08:00

Microsoft Access: Introduction

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103.

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email).

For a printable flyer, click here.

Access Level 1: Introduction

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • define the purpose of and terminology associated with a relational database and Access objects.
  • follow the steps required to properly design a database.
  • create tables to hold data and then establish table relationships.
  • modify the design of and work with data in tables.
  • create, modify the design of, and work with select queries.
  • create and modify forms to work with your data.
  • create and modify reports to select, organize, and print data.

Course Content

Lesson 1: Working with a Relational Database

Topic 1A: Identify Uses of a Relational Database

Topic 1B: Define Database Terminology

Topic 1C: Create a New Database Based on a Template

Topic 1D: Examine the New Database

Lesson 2: Planning a Database

Topic 2A: Identify Database Purpose

Topic 2B: Review Existing Data

Topic 2C: Determine Fields

Topic 2D: Group Fields into Tables

Topic 2E: Normalize the Data

Topic 2F: Designate Primary and Foreign Keys

Topic 2G: Identify Table Relationships

Lesson 3: Building the Basic Structure

Topic 3A: Create a Blank Database

Topic 3B: Create a Table using a Wizard

Topic 3C: Compare Datasheet and Design Views

Topic 3D: Create Tables in Design View

Topic 3E: Create Relationships between Tables

Lesson 4: Working with Tables

Topic 4A: Modify a Table Design

Topic 4B: Work in Datasheet View

Topic 4C: Work with Subdatasheets

Lesson 5: Creating and Working with Select Queries

Topic 5A: Examine a Query

Topic 5B: Create a Query Using a Wizard

Topic 5C: Work in Query Design View

Topic 5D: Select Records

Topic 5E: Edit Values in a Query Datasheet

Topic 5F: Add a Calculated Field to a Query

Topic 5G: Perform a Calculation for a Group of Records

Lesson 6: Creating and Using Forms

Topic 6A: Create AutoForms

Topic 6B: Create a Form Using a Wizard

Topic 6C: Modify the Design of the Form

Topic 6D: Use Forms to Work with Data

Lesson 7: Creating and Using Reports

Topic 7A: Create an AutoReport

Topic 7B: Create a Report Using a Wizard

Topic 7C: Examine a Report in Design View

Topic 7D: Create a Calculated Field

Topic 7E: Change the Format of a Control

Topic 7F: Change the Style of a Report

Topic 7G: Adjust Report Width

Microsoft Access: Intermediate
Apr
12
8:00 am08:00

Microsoft Access: Intermediate

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email).

For a printable flyer, please click here.

Access: Intermediate (Level 2 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • share data with other applications and enforce referential integrity.
  • modify the design of a table to streamline data entry and maintain data integrity.
  • use a filter to show you records in a datasheet or a form that match whatever conditions you specify, and you will generate different query results by creating different types of joins between tables.
  • create select queries that display special records and you will design other types of queries, including parameter and action queries.
  • create forms and change their designs to enhance the appearance and usability of a form and to make your form more professional.
  • create reports and change their designs to better organize and summarize information and to improve the appearance by enhancing data layout and working with report pagination.
  • create and work with data access pages.

Course Content

Lesson 1: Managing a Database and Data

Topic 1A: Import Data

Topic 1B: Maintain Record Integrity

Topic 1C: Exporting Data

Topic 1D: Documenting Table Relationships

Lesson 2: Controlling Data Entry

Topic 2A: Make Data Entry More Accurate

Topic 2B: Make Data Entry More Efficient

Topic 2C: Facilitate Data Entry

Lesson 3: Finding and Joining Data

Topic 3A: Find Data with Filters

Topic 3B: Get the Correct Data with Query Joins

Topic 3C: Building Bridges Between the Data

Topic 3D: Relating Data within a Table

Lesson 4: Creating Flexible Queries

Topic 4A: Summarizing Data with Queries

Topic 4B: Enter Criteria on the Fly

Topic 4C: Maintain Data with Queries

Lesson 5: Improving Your Forms

Topic 5A: Enhance the Appearance of a Form

Topic 5B: Enhance the Usability of a Form

Topic 5C: Make Your Forms More Professional

Topic 5D: Display Form Data from Multiple Tables

Lesson 6: Customizing Your Reports

Topic 6A: Organize Report Information

Topic 6B: Enhancing Data Layout

Topic 6C: Working with Report Pagination

Topic 6D: Summarizing Information

Topic 6E: Add a Subreport to an Existing Report

Topic 6F: Creating Mailing Labels

Microsoft Access: Advanced
Apr
19
8:00 am08:00

Microsoft Access: Advanced

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email).

For a printable flyer, please click here.

Microsoft Access: Advanced (Level 3 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • put existing data into correctly designed tables and compact your database.
  • use a variety of techniques to summarize data.
  • create and revise basic Access macros.
  • create macros that require data entry in certain fields and automatic data entry in others.
  • use advanced features to enhance forms.
  • use advanced features to enhance reports and distribute a report to non-Access users.
  • use Office Links to use Access data in other Office programs.

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Use the Table Analyzer Wizard for Help

Topic 1B: Decide on Your Own Design

Topic 1C: Create a Junction Table

Topic 1D: Modify the Original Tables and Complete the Design

Topic 1E: Compact and Repair a Database

Lesson 2: Summarizing Data

Topic 2A: Group and Summarize Records in Different Ways

Topic 2B: Summarize with a Crosstab Query

Topic 2C: Pivot Query Results

Topic 2D: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro

Topic 3B: Attach a Macro to a Command Button

Topic 3C: Restrict Records

Lesson 4: Adding Interaction and Automation with Macros

Topic 4A: Require Data Entry with a Macro

Topic 4B: Display a Message Box with a Macro

Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Usable

Topic 5A: Change the Display of Data Under Certain Conditions

Topic 5B: Display a Calendar on a Form

Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful

Topic 6A: Cancel Printing of a Blank Report

Topic 6B: Include a Chart

Topic 6C: Arrange Data in Columns

Topic 6D: Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data

Topic 7A: Merge Access Data with a Word Document

Topic 7B: Publish Access Data as a Word Document

Topic 7C: Analyze Access Data in Excel

Microsoft Project: 2 day course
Apr
26
Apr 27

Microsoft Project: 2 day course

Microsoft Project
Offered by PRCC Workforce Development
April 26 - 27, 2017
8:00 am—5:00 pm
Building 1103, Room 1005

Course fee is $40. Seating is limited. For all registration and payment questions, contact:

Troy Teadt
tteadt@prcc.edu
228-688-3113 (o)
985-788-3257 (c)

Prerequisite
Windows 8, Windows 7, Windows XP Basic
or equivalent experience

Course Outline

Day One

Unit 1: Getting started
Topic A: Project management concepts
Topic B: Exploring the Project window
Topic C: Working with project files

Unit 2: Working with tasks
Topic A: Creating a task list
Topic B: Modifying a task list
Topic C: Creating a Work Breakdown Structure

Unit 3: Scheduling tasks
Topic A: Setting up task links
Topic B: Working in Network Diagram view
Topic C: Working with advanced task options

Unit 4: Managing resources
Topic A: Creating base calendars
Topic B: Working with resources and calendars
Topic C: Working with resource costs

Unit 5: Working with views and tables
Topic A: Working with views
Topic B: Working with tables

Unit 6: Filtering, grouping, and sorting
Topic A: Working with filters
Topic B: Working with groups
Topic C: Sorting tasks and resources

Unit 7: Finalizing the task plan
Topic A: Finalizing schedules
Topic B: Resolving resource conflicts

 

Day Two

Unit 8: Tracking project work
Topic A: Managing a project
Topic B: Updating the progress of tasks
Topic C: Observing project progress

Unit 9: Analyzing and adjusting the plan
Topic A:
Analyzing the plan
Topic B: Rescheduling tasks

Unit 10: Formatting and reporting
Topic A: Formatting a project file
Topic B: Using drawing tools
Topic C: Printing views and reports
Topic D: Customizing reports
Topic E: Visual reports

Unit 11: Customizing the project environment
Topic A: Creating custom views
Topic B: Creating a custom table

Unit 12: Managing multiple projects
Topic A: Consolidating and sharing projects
Topic B: Sharing resources across projects

Unit 13: Project communications
Topic A: Communicating among a project team
Topic B: Working with hyperlinks

Unit 14: Exchanging project data
Topic A: Importing data
Topic B: Exporting data
Topic C: Copying data

For a printable flyer for this course, please click here.

MSU Lunch & Learn
Apr
27
12:00 pm12:00

MSU Lunch & Learn

Please join the

Mississippi State University
Bagley College of Engineering

for a Lunch and Learn Session
on Graduate Distance Learning Opportunities

Thursday, April 27, 2017
12:00 p.m.

Gainesville Room
Bldg. 1100, Room 134, John C. Stennis Space Center

Lunch Provided

RSVP by April 18, 2017

Contact The Center of Higher Learning
kim.miller@usm.edu or 228.688.3170

May
15
May 19

CompTIA Security+ Certification

CompTIA Security + Certification

May 15 - 19, 2017
8:00 a.m. - 4:00 p.m. daily
CHL Computer Lab No. 2, Bldg. 1103, Room 1004

DoD 8570 Credential Requirements: This course is approved as a baseline certification for the IAT Level II and the IAM Level 1 per DoD 8570 requirements.

Overview: This course is targeted toward the information technology (IT) professional who has networking and administrative skills in Windows®-based Transmission Control Protocol/Internet Protocol (TCP/IP) networks; familiarity with other operating systems, such as Mac OS X®, Unix, or Linux; and who wants to further a career in IT by acquiring foundational knowledge of security topics; prepare for the CompTIA Security+ certification examination; or use Security+ as the foundation for advanced security certifications or career roles. Instruction is via New Horizons On Line Live (Instructor Led Training Online).

Costs:
Course Fee: $1732.50 per person (reflects a 30% discount for Stennis personnel)
Exam Voucher: Free with registration (special offer for this class)
Registration Deadline: May 5, 2017
For registration and payment, contact Kim Miller at kim.miller@usm.edu or 228.688.3170. CHL accepts checks, credit cards, training forms and purchase orders.

COURSE OBJECTIVES

Upon successful completion of this course, students will be able to:

  • Identify the fundamental concepts of computer security.

  • Identify security threats and vulnerabilities.

  • Manage data, application, and host security.

  • Implement network security.

  • Identify and implement access control and account management security measures.

  • Manage certificates.

  • Identify and implement compliance and operational security measures.

  • Manage risk.

  • Troubleshoot and manage security incidents.

  • Plan for business continuity and disaster recovery.

Prerequisite: CompTIA A+ or CompTIA Network+

For a printable flyer, please click here.

 

 

 


Microsoft Word Training: Intermediate
Mar
22
8:00 am08:00

Microsoft Word Training: Intermediate

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here. 

 

Word: Intermediate (Level 2 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create and modify custom templates, apply existing styles, and create a custom style.
  • enhance a table by merging table cells, sorting and calculating table data, and creating charts based on various table data.
  • learn how to insert, manipulate, and format graphic images, including clip art, AutoShapes, WordArt, and organization charts.
  • create a newsletter using columns, sections, and graphics.
  • use the Mail Merge Wizard to mail merge form letters, complete with mailing labels.
  • include comments in a document and compare and merge documents.

Course Content

Lesson 1: Creating and Modifying Templates

Topic 1A: Apply Styles

Topic 1B: Modify Styles

Topic 1C: Create User-Defined Styles

Topic 1D: Create a Template from an Existing Document

Lesson 2: Managing Tables and Table Data in Documents

Topic 2A: Convert Tabbed Text into a Table

Topic 2B: Merge Cells in a Table

Topic 2C: Open an Excel Table in Word

Topic 2D: Sort Table Data

Topic 2E: Perform Calculations in Tables

Topic 2F: Create and Modify a Chart Based on Word Table Data

Topic 2G: Link Excel Data in a Word Table

Lesson 3: Adding Graphics

Topic 3A: Insert a Clip Art Image

Topic 3B: Add an AutoShape

Topic 3C: Insert WordArt

Topic 3D: Insert an Organizational Chart

Lesson 4: Creating a Newsletter

Topic 4A: Create a Document Section

Topic 4B: Format Text into Newsletter Columns

Topic 4C: Control Column Text Flow

Topic 4D: Wrap Text Around a Graphic

Topic 4E: Create Envelopes and Labels

Lesson 5: Sending Form Letters

Topic 5A: Select the Main Document Type

Topic 5B: Select the Data Source

Topic 5C: Insert Merge Fields

Topic 5D: Merge and Preview Form Letters

Topic 5E: Create Mailing Labels

Lesson 6: Creating a Web Page

Topic 6A: Create a Web Page Using a Template

Topic 6B: Preview a Web Page in a Browser

Topic 6C: Create a Hyperlink in a Web Page

Topic 6D: Edit a Hyperlink in a Web Page

Topic 6E: Apply a Theme to a Web Page

Lesson 7: Managing Document Changes

Topic 7A: Use Comments in Word Documents

Topic 7B: Compare and Merge Documents

Mar
15
Mar 17

CARIS Training

CARIS Bathy DataBASE Training:

BASE Manager/Editor Course

March 15 - 17, 2017
2.5 days of training, course begins at 1:00 p.m. on March 15

CHL Computer Lab, 1103 Balch Blvd., Stennis Space Center

This course explores the use of the CARIS BASE Manager in the processing and preparation of bathymetric datasets. The course uses presentations, discussions and demonstrations, and hands-on practical exercises.

Audience: Anyone wanting a more in-depth knowledge of CARIS BASE Manager and to learn more about importing, validating, compiling, analyzing and extracting bathymetric data.

Topics Include

· Survey Data Management Overview

· Concepts in bathymetry data storage and associated workflows

· Import of 3rd party data formats

· Gridded surface and 3D point cloud creation for the storage of large volume bathymetric datasets

· Data cleaning and validation using area-based cleaning tools and 3D fly-though techniques

· TIN model creation and manipulation with generation of gridded surfaces

· Surface analysis and computations (e.g. differences, extracts, vertical shift, slope and aspect mapping, etc.)

· 3D visualization for large data volumes with raster image and vector draping

· Creation of Product Surfaces (e.g. Combined surfaces)

· Creation of Bathymetry Products as properly attributed S-57 Depth Contours, Depth Areas and Sounding objects

· Prepare objects for use in chart production

· Export bathymetric data and bathymetry products to 3rd part formats

Prerequisites

· Familiarity with operating computers and software

· Familiarity with basic hydrographic concepts and terminology

· Experience with bathymetric data

 

Very limited seating. Register today!
Cost: $500

For registration and payment,
contact CHL at:
kim.miller@usm.edu
228-688-3170

CHL accepts checks, credit cards, training forms and
purchase orders.

 

 

 

 

 

Mar
13
Mar 17

CompTIA A+ Training

CompTIA A+ Certification Course

CHL Computer Lab, Bldg. 1103, Room 1005
March 13 - 17, 2017
8:00 a.m. to 4:00 p.m. daily (40 hours)

DoD 8570 BASELINE CERTIFICATION:
This course is DoD Approved Baseline Certification for IAT Level I

Overview: In this course, you will acquire the essential skills and information you will need to install, configure, optimize, troubleshoot, repair, upgrade, and perform preventive maintenance on PCs, digital devices, and operating systems. This course is designed for students who are seeking the CompTIA A+ certification and who want to prepare for the CompTIA A+ 220-901 Certification Exam and the CompTIA 220-902 Certification Exam. Instruction is via New Horizons On Line Live (Instructor Led Training Online).

COURSE OBJECTIVES

In this course, you will install, configure, optimize, troubleshoot, repair, upgrade, and perform preventive maintenance on personal computers, digital devices, and operating systems. You will:

  • Identify the hardware components of personal computers and mobile digital devices.
  • Identify the basic components and functions of operating systems.
  • Identify networking and security fundamentals.
  • Identify the operational procedures that should be followed by professional PC technicians.
  • Install, configure, and troubleshoot display devices.
  • Install and configure peripheral components.
  • Manage system components.
  • Manage data storage.
  • Install and configure Microsoft Windows.
  • Optimize and maintain Microsoft Windows.
  • Work with other operating systems.
  • Identify the hardware and software requirements for client environment configurations.
  • Identify network technologies.
  • Install and configure networking capabilities.
  • Support mobile digital devices.
  • Support printers and multifunction devices.
  • Identify security threats, vulnerabilities, and controls.
  • Implement security controls.
  • Troubleshoot system-wide issues.

Course Fee: $1732.50 (reflects 30% discount for Stennis personnel)
Exam Voucher $398

For registration and payment, contact CHL at:
kim.miller@usm.edu
228-688-3170

For a printable flyer, click here.

Microsoft Word Training: Introduction
Mar
8
8:00 am08:00

Microsoft Word Training: Introduction

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103.

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here.

Word: Introduction (Level 1 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create a simple document, save a document, use Microsoft Word's automatic text features for entering text, and access online help.
  • make changes to an existing document using a variety of editing techniques.
  • apply text formatting to a document.
  • change the appearance of a document by applying various paragraph formats and effects.
  • create a table, navigate and enter text in a table, and enhance its appearance through formatting.
  • use Word's Find and Replace, and proofing tools to efficiently do your work.
  • preview a document, apply and remove formatting that affects entire pages, and print a document.

Course Content

Lesson 1: Creating a Document

Topic 1A: Enter Text

Topic 1B: Save a Document

Topic 1C: Use Automatic Text Features

Lesson 2: Editing Text

Topic 2A: Open an Existing Document

Topic 2B: Delete Blocks of Text

Topic 2C: Move and Copy Text

Topic 2D: Copy Multiple Items

Lesson 3: Formatting Text

Topic 3A: Apply Character Formats

Topic 3B: Change the Font and Font Size

Topic 3C: Add Highlighting and Color to Text

Topic 3D: Copy Text Formatting

Topic 3E: Paste Options

Lesson 4: Formatting Paragraphs

Topic 4A: Change Paragraph Alignment

Topic 4B: Change Line Spacing Within a Paragraph

Topic 4C: Add a Border and Shading to a Paragraph

Topic 4D: Set a Custom Tab

Topic 4E: Add Indents

Topic 4F: Create Numbered and Bulleted Lists

Topic 4G: Create an Outline Numbered List

Lesson 5: Adding Tables

Topic 5A: Create a Table

Topic 5B: Change Table Structure

Topic 5C: Add Table Borders and Shading

Topic 5D: AutoFormat a Table

Lesson 6: Using Word Timesavers

Topic 6A: Create a New Document Using a Template

Topic 6B: Create a New Document Using a Wizard

Topic 6C: Insert a Symbol

Topic 6D: Insert the Date or Time

Topic 6E: Find and Replace Text

Topic 6F: Check Spelling and Grammar

Topic 6G: Replace a Word Using the Thesaurus

Lesson 7: Setting Page Display and Printing Options

Topic 7A: Preview a Document

Topic 7B: Set the Page Orientation

Topic 7C: Create Headers and Footers

Topic 7D: Change Margins

Topic 7E: Insert a Page Break

Topic 7F: Align Text on a Page

Topic 7G: Print a Document

Advanced QGIS
Dec
5
Dec 6

Advanced QGIS

Advanced QGIS

December 5 - 6, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

Intro to GIS using ArcGIS for Desktop
Nov
16
Nov 17

Intro to GIS using ArcGIS for Desktop

Intro to GIS using ArcGIS for Desktop

November 16 - 17, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

Course Length: 2 days (16 hours)

Overview
This course is intended for individuals who have no experience with Geographic Information Systems (GIS), and offers a basic introduction to GIS using ESRI’s ArcGIS for Desktop software.  

Who Should Attend
Individuals who are interested in learning about Geographic Information Systems (GIS) and ESRI’s ArcGIS for Desktop software.

Goals
Course participants will learn and explore the following:

  • What GIS is and how is it used.
  • Exploring GIS data in ArcGIS for Desktop (ArcMap/ArcCatalog)
  • GIS data formats
  • Map projections and coordinate systems.
  • Symbolizing and Labeling Features in a map.
  • Working with attribute tables
  • Editing and creating data
  • Using geoprocessing tools to process data
  • Analyzing GIS data
  • Designing a map layout.

Prerequisites: Basic computer skills

Excel 2013 Programming with VBA: 3 day course
Nov
1
Nov 3

Excel 2013 Programming with VBA: 3 day course

Excel 2013 Programming with VBA
Offered by PRCC Workforce Development
November 1 - 3, 2016
8:00 am—5:00 pm
Building 1103, Room 1005

Course fee is $100, includes textbook. Seating is limited. For all registration and payment questions, contact:

Troy Teadt
tteadt@prcc.edu
228-688-3113 (o)
985-788-3257 (c)

Prerequisite
Proficient knowledge of Microsoft Excel

Course Outline

Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables

Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Working with the PivotTable Object
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar

Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

 

Intermediate QGIS
Oct
17
Oct 18

Intermediate QGIS

Intermediate QGIS

October 17 - 18, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

Intermediate QGIS

Course Length: 2 days (16 hours)

Overview
Intermediate QGIS presents advanced concepts and techniques not covered in the Introduction to QGIS course.

Who Should Attend
Individuals interested in additional capabilities of QGIS

Goals
Participants completing this course will be able to:

  • Customize the QGIS interface

  • Utilize advanced table management procedures

  • Implement topology concepts in the editing environment

  • Convert vector and raster data formats

  • Process raster data

  • Georeference vector and raster data

  • Create geospatial PDF files

  • Develop a mobile GIS

  • Extend QGIS beyond the desktop

  • Utilize advanced geoprocessing techniques

Prerequisites
Introduction to QGIS

 

 

Introduction to ArcGIS Online
Sep
28
Sep 29

Introduction to ArcGIS Online

Introduction to ArcGIS Online

September 28 - 29, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

 

 

Introduction to QGIS
Sep
26
Sep 27

Introduction to QGIS

Introduction to QGIS

September 26 - 27, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt, PRCC Workforce Liaison, tteadt@prcc.edu
228-688-3113 (O), 985-788-3257 (C), 228-688-7454 (Fax)

Course Description:

QGIS is an “open source” geographic information systems (GIS) software package and available to users at no-cost.  No prior experience with GIS is required to attend.  Topics covered in this course include:

·         What is GIS and how is it used

·         Map projections and coordinate systems

·         An overview of GIS data types and how to create GIS   datasets

·         Using GIS data to manage map symbology and labels

·         Attribute and spatial data analysis techniques

·         Geoprocessing of spatial data

·         Designing maps for presentations

The course combines instructor-led presentations and hands-on, practical exercises for participants.  Each attendee will receive a course workbook, data used in the exercises and a copy of the latest version of QGIS.

Microsoft PowerPoint: Intermediate (Level 2)
Sep
14
8:00 am08:00

Microsoft PowerPoint: Intermediate (Level 2)

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

Microsoft Office PowerPoint: Level 2

Cost: $25.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create a design template.
  • create organization charts and diagrams.
  • add special effects to a Microsoft® Office PowerPoint®  slide.
  • use advanced animation techniques
  • create a Microsoft® Office PowerPoint®  presentation containing hyperlinks and action controls..

Course Content

Lesson 1: Creating a Custom Design Template

Topic 1A: Define Design Template Characteristics

Topic 1B: Create a Custom Color Scheme

Topic 1C: Set Up a Slide Master

Topic 1D: Format Custom Bullets

Topic 1E: Add a Footer

Topic 1F: Modify the Notes Master

Topic 1G: Save a Custom Design Template

Lesson 2: Adding Organization Charts and Diagrams

Topic 2A: Working with Organization Charts

Topic 2B: Update an Organization Chart

Topic 2C: Applying a Chart Layout

Topic 2D: Create a Diagram

Topic 2E: Draw a Flowchart

Lesson 3: Adding Special Effects

Topic 3A: Add Sound and Movies

Topic 3B: Add Animation and Work with Advanced Timeline

Topic 3C: Emphasize Objects

Topic 3D: Set a Motion Path

Topic 3E: Set the Order of Effects

Lesson 4: Creating Presentations Containing Hyperlinks

Topic 4A: Create a Group Home Page with the AutoContent Wizard

Topic 4B: Hyperlink to a Web Page

Topic 4C: Hyperlink to another slide

Topic 4DHyperlink to another MS file

Lesson 5: Collaborating in PowerPoint

Topic 5A: Set Password Protection

Topic 5B: Work with Comments

Topic 5C: Send a Presentation for Review

Topic 5D: Merge Revision Copies

Topic 5E: Apply Reviewer Changes

Lesson 6: Delivering a Presentation

Topic 6A: Hyperlink Within PowerPoint

Topic 6B: Add an Action Button

Topic 6C: Set Up a Custom Show

Topic 6D: Annotate a Presentation

Topic 6E: Working with Narrations and Slide Timings

Topic 6F: Set Up a Slide Show to Repeat Automatically

Microsoft PowerPoint: Introduction (Level 1)
Sep
7
8:00 am08:00

Microsoft PowerPoint: Introduction (Level 1)

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

Microsoft® Office PowerPoint: Level 1

Cost: $25.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • manipulate an existing PowerPoint presentation.
  • begin creating a presentation.
  • format text slides.
  • add tables to a presentation.
  • chart data in a presentation.
  • modify objects on slides.
  • add images to a presentation.
  • prepare to deliver a presentation.

Course Content

Lesson 1: An Orientation to PowerPoint

Topic 1A: The PowerPoint Environment

Topic 1B: Orientation to Views

Topic 1C: Navigate Through a Presentation

Topic 1D: Edit Slide Text

Topic 1E: Save the Presentation

Topic 1F: Run a Slide Show

Lesson 2: Beginning a Presentation

Topic 2A: Create a New Presentation

Topic 2B: Change Background Color

Topic 2C: Add Slides to a Presentation

Topic 2D: Enter Text

Topic 2E: Create a Presentation from a Microsoft Word Outline

Lesson 3: Formatting Text Slides

Topic 3A: Apply Character Formats

Topic 3B: Align Text

Topic 3C: Change Line Spacing

Topic 3D: Change Indents

Lesson 4: Adding Tables to a Presentation

Topic 4A: Create a Table

Topic 4B: Format Tables

Topic 4C: Insert a Table from Microsoft Word

Lesson 5: Charting Data

Topic 5A: Create a Column Chart

Topic 5B: Edit Chart Data

Topic 5C: Change Chart Type

Topic 5D: Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects

Topic 6A: Resize Objects

Topic 6B: Copy and Duplicate Objects

Topic 6C: Move Objects

Topic 6D: Changing Object Orientation

Topic 6E: Format Objects

Topic 6F: Group and Ungroup Objects

Topic 6G: Change the Order of Objects

 

Lesson 7: Adding Images to a Presentation

Topic 7A: Add Clip Art

Topic 7B: Add a Picture from a File

Topic 7C: Draw Lines and Shapes

Topic 7D: Insert WordArt

Lesson 8: Preparing to Deliver a Presentation

Topic 8A: Spell Check

Topic 8B: Arrange Slides

Topic 8C: Add Transitions

Topic 8D: Create Speaker Notes

Topic 8E: Send a Presentation to Microsoft Word

Topic 8F: Print the Presentation

Topic 8G: Package a Presentation for CD

For a printable flyer, click here.

Intro to GIS using ArcGIS Desktop
Aug
24
Aug 25

Intro to GIS using ArcGIS Desktop

Introduction to GIS using ArcGIS Desktop

August 24 - 25, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

 

Advanced QGIS
Aug
22
Aug 23

Advanced QGIS

Advanced QGIS

August 22 - 23, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

 

Introduction to MATLAB
Aug
15
Aug 18

Introduction to MATLAB

 Introduction to MATLAB®

offered by

The University of Southern Mississippi

School of Ocean Science and Technology Division of Marine Science

August 15—18, 2016     8:00 am—4:30 pm

Building 1022, Room 101

 

Participation Requirements:

$500 registration fee

Text (to be purchased by student in advance of class): A Guide to MATLAB® for Beginners and Experienced Users, (2nd or 3rd) Ed, by Brian R. Hunt, Ronald L. Lipsman, and Jonathan M. Rosenberg, and published by Cambridge University Press in 2007. (Available from Amazon.com.)\

Pre-requisite course training (no cost): https://matlabacademy.mathworks.com

Computers and software will be provided at no cost

For course requirements and questions, contact Max van Norden at maxim.vannorden@usm.edu or 228-688-7123.

To register, contact Kim Miller at kim.miller@usm.edu or 228-688-3170.

For course details and schedule, click here.


Contact Hours

Class Hours:  Monday to Thursday, August 15-18, 2016        0800-1630

Location:        Building 1022 classroom (Room 101)

This class will be taught in 4 full day sessions from 0800 until 1200, with the afternoons devoted to completion of the MATLAB® programming exercises. Problems and issues encountered by students attempting the problem sets will be discussed as they occur.  The results for each day will be summarized during an interactive discussion at 1600 each day.  There will be a 1-hour break for lunch from 1200 until 1300 and 10-minute breaks will be taken every hour.

Course Description

This 4 day long introduction to MATLAB® course is intended specifically to prepare students in the marine sciences for the programming and computational challenges they will encounter. No previous programming experience is necessary or expected.

Texts    

A Guide to MATLAB® for Beginners and Experienced Users, (2nd or 3rd) Ed, by Brian R. Hunt, Ronald L. Lipsman, and Jonathan M. Rosenberg, and published by Cambridge University Press in 2007. (Available from Amazon.com)

Computer  

Students will be provided with a laptop computer with MATLAB® installed.

Instructional Strategy

This course will be taught in a very “hands-on” manner. Sample problems will be worked out collaboratively on the whiteboard and in MATLAB®, and programming exercises will be assigned and discussed each day.

Student Learning Outcomes

At the end of this course you will be able to use MATLAB® to:

·         Input and manipulate data of various formats

·         Perform mathematical operations on scalar and vector data

·         Save data and computations in various formats

·         Write scripts and functions (programs) for repetitive and/or complex tasks

·         Create graphics, such as plots and histograms, for visually analyzing data and computational output

¨ Learn how to utilize MATLAB® in new ways

For more details and full schedule, click here.

 

 

UNO Lunch & Learn
Jul
26
11:30 am11:30

UNO Lunch & Learn

 

Please join Dr. Juliette Ioup from

The University of New Orleans

for an information session on

UNO Graduate Programs at Stennis:

 

Master of Science in Applied Physics

Ph.D. in Engineering and Applied Science

 

Tuesday, July 26   11:30

Gainesville Room, Roy C. Estess Building

 

Brown Bag Lunch

Soft drinks and cookies provided by CHL

Click here for more details!

 

Microsoft Word Training: Advanced
Jun
22
8:00 am08:00

Microsoft Word Training: Advanced

  • CHL

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here. 

 

Microsoft Word: Advanced (Level 3 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create and distribute a form.
  • automate tasks by writing and revising macros.
  • create references to information in a document.
  • prepare a document for publication.
  • revise documents based on feedback provided by other users.

Course Content

Lesson 1: Creating and Distributing Forms

Topic 1A: Create a Form Template

Topic 1B: Insert Fields in a Form Template

Topic 1C: Protect the Form

Topic 1D: Test a Form

Lesson 2: Automating Tasks

Topic 2A: Run Macros

Topic 2B: Record a Macro

Topic 2C: Edit a Macro

Topic 2D: Create Toolbar Buttons

Topic 2E: Create Custom Menus

Lesson 3: Referencing Document Information

Topic 3A: Insert Bookmarks

Topic 3B: Insert Footnotes and Endnotes

Topic 3C: Add Captions

Topic 3D: Create Cross-References

Lesson 4: Preparing a Document for Publication

Topic 4A: Set Book Margins

Topic 4B: Create Custom Headers and Footers

Topic 4C: Compile a Table of Contents

Topic 4D: Index the Document

Topic 4E: Create a Master Document

Lesson 5: Revising Documents

Topic 5A: Create Document Versions

Topic 5B: Distribute a Document

Topic 5C: Track Changes to a Document

Topic 5D: Review Document Changes

Lesson 6: Modifying an HTML Page

Topic 6A: Save Word Documents as Web Pages

Topic 6B: Edit Web Pages in Word

Topic 6C: Insert Scrolling Text

Topic 6D: Place a Movie Clip in a Web Page

Topic 6E: Insert a Background Sound

 

Microsoft Word Training: Intermediate
Jun
15
8:00 am08:00

Microsoft Word Training: Intermediate

  • CHL

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here. 

Word: Intermediate (Level 2 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create and modify custom templates, apply existing styles, and create a custom style.
  • enhance a table by merging table cells, sorting and calculating table data, and creating charts based on various table data.
  • learn how to insert, manipulate, and format graphic images, including clip art, AutoShapes, WordArt, and organization charts.
  • create a newsletter using columns, sections, and graphics.
  • use the Mail Merge Wizard to mail merge form letters, complete with mailing labels.
  • include comments in a document and compare and merge documents.

Course Content

Lesson 1: Creating and Modifying Templates

Topic 1A: Apply Styles

Topic 1B: Modify Styles

Topic 1C: Create User-Defined Styles

Topic 1D: Create a Template from an Existing Document

Lesson 2: Managing Tables and Table Data in Documents

Topic 2A: Convert Tabbed Text into a Table

Topic 2B: Merge Cells in a Table

Topic 2C: Open an Excel Table in Word

Topic 2D: Sort Table Data

Topic 2E: Perform Calculations in Tables

Topic 2F: Create and Modify a Chart Based on Word Table Data

Topic 2G: Link Excel Data in a Word Table

Lesson 3: Adding Graphics

Topic 3A: Insert a Clip Art Image

Topic 3B: Add an AutoShape

Topic 3C: Insert WordArt

Topic 3D: Insert an Organizational Chart

Lesson 4: Creating a Newsletter

Topic 4A: Create a Document Section

Topic 4B: Format Text into Newsletter Columns

Topic 4C: Control Column Text Flow

Topic 4D: Wrap Text Around a Graphic

Topic 4E: Create Envelopes and Labels

Lesson 5: Sending Form Letters

Topic 5A: Select the Main Document Type

Topic 5B: Select the Data Source

Topic 5C: Insert Merge Fields

Topic 5D: Merge and Preview Form Letters

Topic 5E: Create Mailing Labels

Lesson 6: Creating a Web Page

Topic 6A: Create a Web Page Using a Template

Topic 6B: Preview a Web Page in a Browser

Topic 6C: Create a Hyperlink in a Web Page

Topic 6D: Edit a Hyperlink in a Web Page

Topic 6E: Apply a Theme to a Web Page

Lesson 7: Managing Document Changes

Topic 7A: Use Comments in Word Documents

Topic 7B: Compare and Merge Documents

Microsoft Word Training: Introduction
Jun
8
8:00 am08:00

Microsoft Word Training: Introduction

  • CHL

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here.

Word: Introduction (Level 1 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create a simple document, save a document, use Microsoft Word's automatic text features for entering text, and access online help.
  • make changes to an existing document using a variety of editing techniques.
  • apply text formatting to a document.
  • change the appearance of a document by applying various paragraph formats and effects.
  • create a table, navigate and enter text in a table, and enhance its appearance through formatting.
  • use Word's Find and Replace, and proofing tools to efficiently do your work.
  • preview a document, apply and remove formatting that affects entire pages, and print a document.

Course Content

Lesson 1: Creating a Document

Topic 1A: Enter Text

Topic 1B: Save a Document

Topic 1C: Use Automatic Text Features

Lesson 2: Editing Text

Topic 2A: Open an Existing Document

Topic 2B: Delete Blocks of Text

Topic 2C: Move and Copy Text

Topic 2D: Copy Multiple Items

Lesson 3: Formatting Text

Topic 3A: Apply Character Formats

Topic 3B: Change the Font and Font Size

Topic 3C: Add Highlighting and Color to Text

Topic 3D: Copy Text Formatting

Topic 3E: Paste Options

Lesson 4: Formatting Paragraphs

Topic 4A: Change Paragraph Alignment

Topic 4B: Change Line Spacing Within a Paragraph

Topic 4C: Add a Border and Shading to a Paragraph

Topic 4D: Set a Custom Tab

Topic 4E: Add Indents

Topic 4F: Create Numbered and Bulleted Lists

Topic 4G: Create an Outline Numbered List

Lesson 5: Adding Tables

Topic 5A: Create a Table

Topic 5B: Change Table Structure

Topic 5C: Add Table Borders and Shading

Topic 5D: AutoFormat a Table

Lesson 6: Using Word Timesavers

Topic 6A: Create a New Document Using a Template

Topic 6B: Create a New Document Using a Wizard

Topic 6C: Insert a Symbol

Topic 6D: Insert the Date or Time

Topic 6E: Find and Replace Text

Topic 6F: Check Spelling and Grammar

Topic 6G: Replace a Word Using the Thesaurus

Lesson 7: Setting Page Display and Printing Options

Topic 7A: Preview a Document

Topic 7B: Set the Page Orientation

Topic 7C: Create Headers and Footers

Topic 7D: Change Margins

Topic 7E: Insert a Page Break

Topic 7F: Align Text on a Page

Topic 7G: Print a Document

MSU Lunch & Learn
Jun
6
11:30 am11:30

MSU Lunch & Learn

Mississippi State University

Lunch & Learn

Monday, June 6 11:30 – 12:30

SSC Conference Center Room C103

Meal Provided!

RSVP by May 27 to The Center of Higher Learning

kim.miller@usm.edu * 228-688-3170

Join the Bagley College of Engineering from Mississippi State University for a lunch and learn session on Graduate Distance Learning Opportunities on June 6.  Lunch will be provided. Please RSVP no later than May 27 to ensure lunch availability. MSU offers distance learning opportunities for Master’s and PhD programs in Aerospace Engineering, Civil Engineering, Electrical and Computer Engineering, Industrial and Systems Engineering, and Mechanical Engineering.  Additionally, we have a multidisciplinary Master of Engineering program.  These flexible, accredited programs have been ranked 7th in the nation by U.S. News & World Report. For more information on these programs visit www.bcoeonline.msstate.edu. Faculty and staff will be available to discuss admission, registration, and program information.

Click here for a more detailed flyer!

Microsoft Access Training: Intermediate (Level 2 of 3)
May
25
8:00 am08:00

Microsoft Access Training: Intermediate (Level 2 of 3)

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Access series, click here.

Access: Intermediate (Level 2 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • share data with other applications and enforce referential integrity.
  • modify the design of a table to streamline data entry and maintain data integrity.
  • use a filter to show you records in a datasheet or a form that match whatever conditions you specify, and you will generate different query results by creating different types of joins between tables.
  • create select queries that display special records and you will design other types of queries, including parameter and action queries.
  • create forms and change their designs to enhance the appearance and usability of a form and to make your form more professional.
  • create reports and change their designs to better organize and summarize information and to improve the appearance by enhancing data layout and working with report pagination.
  • create and work with data access pages.

Course Content

Lesson 1: Managing a Database and Data

Topic 1A: Import Data

Topic 1B: Maintain Record Integrity

Topic 1C: Exporting Data

Topic 1D: Documenting Table Relationships

Lesson 2: Controlling Data Entry

Topic 2A: Make Data Entry More Accurate

Topic 2B: Make Data Entry More Efficient

Topic 2C: Facilitate Data Entry

Lesson 3: Finding and Joining Data

Topic 3A: Find Data with Filters

Topic 3B: Get the Correct Data with Query Joins

Topic 3C: Building Bridges Between the Data

Topic 3D: Relating Data within a Table

Lesson 4: Creating Flexible Queries

Topic 4A: Summarizing Data with Queries

Topic 4B: Enter Criteria on the Fly

Topic 4C: Maintain Data with Queries

Lesson 5: Improving Your Forms

Topic 5A: Enhance the Appearance of a Form

Topic 5B: Enhance the Usability of a Form

Topic 5C: Make Your Forms More Professional

Topic 5D: Display Form Data from Multiple Tables

Lesson 6: Customizing Your Reports

Topic 6A: Organize Report Information

Topic 6B: Enhancing Data Layout

Topic 6C: Working with Report Pagination

Topic 6D: Summarizing Information

Topic 6E: Add a Subreport to an Existing Report

Topic 6F: Creating Mailing Labels

USM Gulf Park Visit
May
18
10:30 am10:30

USM Gulf Park Visit

The University of Southern Mississippi - Gulf Park will have recruiters on site to answer your questions about academic opportunities. Stop by their table in the Estes Building cafeteria lobby! 

Microsoft Access Training: Introduction (Level 1 of 3)
May
18
8:00 am08:00

Microsoft Access Training: Introduction (Level 1 of 3)

Access Level 1: Introduction

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • define the purpose of and terminology associated with a relational database and Access objects.
  • follow the steps required to properly design a database.
  • create tables to hold data and then establish table relationships.
  • modify the design of and work with data in tables.
  • create, modify the design of, and work with select queries.
  • create and modify forms to work with your data.
  • create and modify reports to select, organize, and print data.

Course Content

Lesson 1: Working with a Relational Database

Topic 1A: Identify Uses of a Relational Database

Topic 1B: Define Database Terminology

Topic 1C: Create a New Database Based on a Template

Topic 1D: Examine the New Database

Lesson 2: Planning a Database

Topic 2A: Identify Database Purpose

Topic 2B: Review Existing Data

Topic 2C: Determine Fields

Topic 2D: Group Fields into Tables

Topic 2E: Normalize the Data

Topic 2F: Designate Primary and Foreign Keys

Topic 2G: Identify Table Relationships

Lesson 3: Building the Basic Structure

Topic 3A: Create a Blank Database

Topic 3B: Create a Table using a Wizard

Topic 3C: Compare Datasheet and Design Views

Topic 3D: Create Tables in Design View

Topic 3E: Create Relationships between Tables

Lesson 4: Working with Tables

Topic 4A: Modify a Table Design

Topic 4B: Work in Datasheet View

Topic 4C: Work with Subdatasheets

Lesson 5: Creating and Working with Select Queries

Topic 5A: Examine a Query

Topic 5B: Create a Query Using a Wizard

Topic 5C: Work in Query Design View

Topic 5D: Select Records

Topic 5E: Edit Values in a Query Datasheet

Topic 5F: Add a Calculated Field to a Query

Topic 5G: Perform a Calculation for a Group of Records

Lesson 6: Creating and Using Forms

Topic 6A: Create AutoForms

Topic 6B: Create a Form Using a Wizard

Topic 6C: Modify the Design of the Form

Topic 6D: Use Forms to Work with Data

Lesson 7: Creating and Using Reports

Topic 7A: Create an AutoReport

Topic 7B: Create a Report Using a Wizard

Topic 7C: Examine a Report in Design View

Topic 7D: Create a Calculated Field

Topic 7E: Change the Format of a Control

Topic 7F: Change the Style of a Report

Topic 7G: Adjust Report Width