COMPUTERS AND INFORMATION TECHNOLOGY
MICROSOFT OFFICE ACCESS, INTRODUCTION
Take away the mystery of database design in Access by creating, designing, and editing tables. Learn to create simple queries and filters, and to design simple forms and reports. $289
Sep 13-Sep 14 WTh Sep 18-Sep 26 MT
9 am-4 pm 6 pm-9 pm
ACCESS, INTERMEDIATE
Learn about database normalization, relationships, referential integrity, and how to analyze tables. Explore complex queries with joins, parameters, calculated fields, and summarizing and grouping values. Work with action queries and finding unmatched or duplicate records. Learn to create more advanced reports with calculated fields and enhanced control formatting and data bars. $289
Sep 25-Sep 26 MT Oct 2-Oct 10
MT ACCESS, ADVANCED
Learn more advanced form design with sub-forms, tab pages, and navigation forms. Students will import, export, and link external data and perform a Word mail merge with Access data. The database will be made more turn-key with macros, VBA programming, and switchboards. Database management topics like dependencies, documenting, and compacting, repairing, splitting, security, and turning into ACCDE file will be addressed. $289
Oct 30-Oct 31 MT Nov 6-Nov 16 MTh
9 am-4 pm 6 pm-9 pm
OFFICE PRODUCTIVITY LAB
At the end of the Office Administrative Specialist Certificate Program, students will demonstrate their knowledge of office applications by creating documents and spreadsheets using the skills acquired in the program. Grades will be assigned in this course. To receive an Office Administrative Specialist Certificate, you must successfully complete this course. $149
Dec 11 M 9 am-4 pm TRANSITIONING TO OFFICE 2016
Explore the new features in Microsoft’s newest release of Word, Excel, PowerPoint and Outlook. Students should have training or experience in a previous version of Microsoft Office. $169
Sep 25 M 9 am-4 pm POWERPOINT, INTRODUCTION
Your presentations can be show stopping! Create slide shows using PowerPoint’s most commonly used features. $289 Nov 28-Nov 29 TW
9 am-4 pm POWERPOINT, ADVANCED
Import from other applications, create photo albums, share presentations, and create templates. Use multimedia effects including sound and video to produce professional, effective presentations. $289
Dec 6-Dec 7 16 WTh 9 am-4 pm NEAST CEPDP 650 15 NEAST CEPDP 629 36 NEAST CEMSO 519 07 NEAST CEMSO 516 02
HARBN CEDBS 624 32 NEAST CEDBS 624 59
9 am-4 pm 6 pm-9 pm
HARBN CEDBS 623 28 NEAST CEDBS 623 74
NEAST CEDBS 620 28 NEAST CEDBS 620 79
OUTLOOK, ADVANCED
Take your Outlook skills to the next level. Learn how to customize Outlook, automate commonly used actions, work with folders, organize Outlook components, and use the Rules Wizard. $249
Nov 9-Nov 10 Th F
9 am-4 pm 9 am-12 pm
OUTLOOK, INTRODUCTION
Make the most of your email communications. Learn to work with contacts and distribution lists. Find out how Outlook tasks can help you get organized and use the Outlook calendar to keep up with your busy schedule. $289
Nov 1-Nov 2 Nov 8-Nov 9
WTh WTh
Oct 9-Oct 18 MW
9 am-4 pm 9 am-4 pm 6 pm-9 pm
HARBN CESCH 708 44 FF
CREATING A SIMPLE EXCEL SPREADSHEET
Learn to create a simple Excel spreadsheet complete with formats and easy formulas. $89 Dec 1
F 9 am-12 pm EXCEL FORMULAS AND FUNCTIONS
Work with basic math formulas and progress to conditional, lookups, date and time, financial, statistical, and conversion examples. Protect and hide your formulas and create user-defined functions. $169
Sep 28 Th EXCEL GRAPHS
Graphs are very powerful tools for visually representing your important numeric data. Learn how simple it is to create in Excel. $89
Dec 8 F EXCEL MACROS
Enjoy the efficiency of macros as you learn to record mouse clicks and keystrokes for playback later or to record a sequence of commands you use to perform repetitive tasks in Excel. Get the basics in this class. $89
Nov 30 Th EXCEL PIVOT TABLES
Learn to use Pivot Tables to summarize large amounts of data and analyze it in a variety of ways. $89 Nov 30
Th 9 am-12 pm EXCEL, INTRODUCTION
Excel is used in most offices. Learn how to create effective and efficient worksheets using formulas, common functions, formatting, and printing. $289
Sep 5-Sep 6 TW
Sep 13-Sep 14 WTh Oct 4-Oct 5
WTh
Oct 17-Oct 18 TW Sep 11-Sep 20 MW
9 am-4 pm 9 am-4 pm 9 am-4 pm 9 am-4 pm 6 pm-9 pm
HARBN CESDS 602 19 FF
CESDS 602 20
NEAST CESDS 602 21 HARBN CESDS 602 22 HARBN CESDS 602 56
NEAST CESDS 631 27 1 pm-4 pm NEAST CESDS 640 24 9 am-12 pm NEAST CESDS 629 22 9 am-4 pm NEAST CESDS 630 29 NEAST CESDS 628 33 CESCH 708 45 NEAST CESCH 708 60 HARBN CESCH 717 07
COURSE DESCRIPTIONS AND ADDITIONAL CLASS DATES @
MIDLANDSTECH.EDU/training
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42 |
Page 43 |
Page 44 |
Page 45 |
Page 46 |
Page 47 |
Page 48
