COMPUTERS AND INFORMATION TECHNOLOGY CAREER SPOTLIGHT DATABASE ANALYST
In today’s workplace, managers, programmers, and professionals need database skills. Without question, effective understanding, management, and analysis of data is a key to success for business professionals at all levels. To earn this certificate, students must successfully complete the following courses listed to the right within a two-year period.
Courses should be taken in the order listed below. REQUIREMENTS
Access, Introduction Access, Intermediate Database Design SQL, Introduction Access, Advanced
Crystal Reports, Introduction SQL Server Database Services Database Productivity Labs
HOURS 12
12 6
12 12 12 18 6
Total: 90 hrs
COST $299
$299 $199 $399 $299 $599 $699 $199
$2992
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 develop the skills to design simple forms and reports. $299
May 9-May 10 WTh May 21-May 29 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. $299
May 30-May 31 WTh Jun 4-Jun 12 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, compacting, repairing, splitting, security, and turning into ACCDE file will be addressed. $299
Jul 16-Jul 17 Jul 11-Jul 19
MT WTh
9 am-4 pm 6 pm-9 pm
HARBN CEDBS 624 34 NEAST CEDBS 624 62
9 am-4 pm 6 pm-9 pm
HARBN CEDBS 623 30 NEAST CEDBS 623 76
POWERPOINT, INTRODUCTION
Your presentations can be show-stopping. Create slide shows using PowerPoint's most commonly used features. $299 Aug 1-Aug 2
WTh 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. $299
Aug 29-Aug 30 WTh 9 am-4 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. $299
Jul 25-Jul 26 WTh Jul 23-Jul 24 MT Aug 6-Aug 15 MW
9 am-4 pm 9 am-4 pm 6 pm-9 pm
FF CESCH 708 01
HARBN CESCH 708 49 NEAST CESCH 708 61
NEAST CEPDP 650 17 NEAST CEPDP 629 38
NEAST CEDBS 620 30 NEAST CEDBS 620 81
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. $199
Aug 22 W 9 am-4 pm NEAST CEMSO 516 07
REGISTER @
MIDLANDSTECH.EDU/training | 803.732.0432 | see page 45
15
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
