Fort Myers - 4315 Metro Pkwy Public Course Schedule

You will create and modify new databases and their various objects.

You will improve and customize tables, queries, forms and reports, and share Access data with other applications.

Crystal Reports XI: Level 1 is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. It is also the first course in the Crystal Reports XI series. In this course, you will build basic list and group reports that work with almost any database.

You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

You will use Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks, and create notes.

 You will customize the Outlook environment, calendar, and mail messages, and will also track, share, assign, and quickly locate various Outlook items.

You will explore the PowerPoint environment and create a presentation. You will format text on slides to enhance clarity. To enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it.

You will create, edit, and enhance standard business documents using Microsoft® Office Word 2010.

You will create complex documents and build personalized efficiency tools using Microsoft Office Word 2010.

This course is intended for designers, publishers, pre-press professionals, marketing communications professionals, or people switching to a design job or taking on design responsibilities and who need to use Illustrator to create illustrations, logos, advertisements, or other graphic documents.

You will create complex illustrations, manage color across a range of devices, work with graphs and variables, control how illustrations appear on print and the web, and preview them on mobile devices.

You will utilize Adobe® InDesign® CS5 to create and deliver eye-catching printed documents.

You will use the advanced features of Adobe® InDesign® CS5 to create and design content for the web and print

You will understand and use the various elements in the Photoshop CS5 interface so as to efficiently work with the software. You will use the different tools in Photoshop for selecting parts of images and identify the need for having layers in a Photoshop document. You will also organize the different components of the design as layers. With the layered Photoshop document thus created, you will apply layer effects and other special effects in order to enhance the appearance of the design. Once the design is finalized, you will save images in both print and web formats.

You will enhance your ability to create accurate masks and image effects, retouch images, work with video files, automate repetitive tasks, and integrate with other Adobe applications.

Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you're ready to move ahead to create complex reports and data sources using Crystal Reports' tools. In this course, you'll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you'll also learn how to increase the speed and efficiency of your reports by using SQL queries.

You will use, create, and edit content in a team website. You will also create and perform basic management of a team site using SharePoint Foundation 2010.