Access 2003 Advanced
Students will learn to create sub-forms as well as customized forms, queries and reports. Focus will also be placed on building relational databases, integrating information from other source and using the MS Access web capabilities. Students will also learn to maintain data integrity, create relationships, and use macros to enhance the performance of various actions.
|
Access 2003 Proficient
Students will learn to create and modify tables, forms queries, and standard reports. They will create and modify fields, locate and sort information, and analyze data.
|
Access 2007 Level 1
Students will learn to how to define the appropriate tables, fields, and data types for a database. They will create and modify fields, understand normalization, define the (3) types of relationships, determine Primary and Foreign keys, and create relationships between tables. Students will participate in hands on labs, create notes from the instructor’s guidelines, and begin building an individual database.
|
Access 2007 Level 2
Students will learn about field properties. How to restrict data entry in fields, create input mask, lookup fields, simple queries, action queries, parameter queries and query joins. Focus will also be placed on the use of wild cards. Students will also learn how to maintain data security utilizing referential integrity.
|
Access 2007 Level 3
Students will learn how to create forms using the form wizard, create textbox controls, Combo boxes, sub forms, and command buttons. They will learn all the functionalities of a form in design view, and how to create reports from queries, import data from Excel file, and how to set form properties.
|
Adobe Acrobat X Pro Level 1
Course Objective:
In this course, students will use Adobe® X Pro to create, navigate and work with multiple PDF files.
|
Adobe Acrobat X Pro Level 2
In this course, you will use Adobe® Acrobat®
X Pro to convert documents to PDF files, enhance and customize PDF documents using interactive forms.
|
Excel 2003 Level 1
Students will learn to create, modify, format and print worksheets and workbooks. Formulas, functions, customising layouts and working with sheets will be covered.
|
Excel 2003 Level 2
Students will learn to create and modify charts and graphic objects, create and apply templates, to use calculations with intermediate formulas/functions including conditional, and to sort and filter data in worksheets
|
Excel 2003 Level 3
Students will learn how to work with advanced formatting, formula auditing, lookup functions, and macros. They will import, export and summarize data (PivotTable). The use of multiple workbooks, analysis tools and customized toolbars will also be covered.
Books provided not critical, not needed for all students (some will have from previous level)
Excel 2003 Training manual, Bermuda Bookstore
|
Excel 2007/2010 Level 1
Students will gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets. They will also learn how to perform calculations and manage large workbooks.
|
Excel 2007/2010 Level 2
Students will learn how to create templates, sort and filter data, import and export data, and analyze data. Students will also learn how to calculate with advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables and PivotCharts, insert graphic objects, and customize and enhance workbooks and the Microsoft® Office Excel® environment.
|
Excel 2007/2010 Level 3
Students will gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, work with multiple workbooks, import and export data, and use Excel with the web.
|
Excel Macros Advanced
This course follows the foundation established in the proficient Excel Macros class. The primary focus is on Forms, Looping, Logical Tests and Custom Functions. We also customise to meet your needs as required.
|
Excel Macros Proficient
We build the visual basic code from scratch, and encourage the attendees to keep their files from class for future reference. We start out with simple macros, editing, copying, moving, comments, and graduate to multi step macros that combine the most common tasks such as importing external data, prompting user input, appending a database, selecting specific ranges. We also assign macros to buttons, customising menus and toolbars. The class can be customised to meet your needs.
|
InfoPath 2007/2010
Microsoft® Office InfoPath® Forms is a product that gathers and shares information. In this course, you will use InfoPath to streamline the process of gathering and sharing information.
|
MOC 50468 SharePoint 2010 End User Level 1
This 3-day Instructor Led course Explores all the basic end user features of SharePoint 2010 including all basic lists and sites.
|
MOC 50469 SharePoint 2010 End User level 2
This 2-day Instructor led course explores several advanced topics of working with SharePoint 2010 sites. Topics include SharePoint Server site definitions (Business Intelligence, Search Center, etc.), in-depth coverage of Workflows, My Sites and Social Computing, Site Administration, Site Customization and Site Collection Administration.
|
MOS 2010 Excel Expert, Exam preparation
Prepares the student for the MOS Excel 2010 Expert exam 77-888
|
Office 2007/2010 - New Features
This half day class can be customised to suit your needs.
|
Outlook
This course focuses upon using Outlook for communications purposes. Students will create, format, and manage e-mail messages, store client information, schedule meetings and appointments, and organize tasks.
|
PhotoShop CS3 level 1
You will understand and use the various elements in the Photoshop CS3 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.
|
PhotoShop CS3 level 2
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.
|
Photoshop CS5 level 1
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.
|
Photoshop CS5 level 2
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.
|
PowerPoint 2007/2010 Advanced
As a Microsoft® Office PowerPoint® 2007 user, you are familiar with the basics of creating a presentation and you are able to convey information effectively in a simple way. Static content in presentation, however, will not keep your audience interested. In this course, you will enhance presentations with feature that will transform basic presentations into a powerful means of communication.
|
PowerPoint 2007/2010 Proficient
Students will use the features available to create, modify and customize presentations. They will learn to add text and visual elements, import data from other sources, and create outputs. Slide show features such as timings, transitions and animation will also be covered. Students will learn to prepare and deliver a professional and effective presentation.
|
Project 2003 Advanced
Customised courses are available to meet any need. High-end topics include creating and customizing views, calendars, and tables; working with resource pools; combining projects and managing multiple projects; and creating custom calculations. We can create a high-end working environment that incorporates Project into Outlook (via Exchange or internet based mail handling), centralized server shared Projects and resources, and Project Central / Server.
|
Project 2003 Proficient
Students will get an overview of creating and managing projects. They will add and assign resources, link tasks, observe the critical path, and work with constraints. Students will also look at outlining, generating project reports, resolving time restrictions and resource conflicts, as well as sorting and filtering data. Students will look at tracking project progress, as well as adjusting schedules and costs.
|
Project 2007 Advanced
Customised courses are available to meet any need. High-end topics include creating and customizing views, calendars, and tables; working with resource pools; combining projects and managing multiple projects; and creating custom calculations. We can create a high-end working environment that incorporates Project into Outlook (via Exchange or internet based mail handling), centralized server shared Projects and resources, and Project Central / Server.
|
Project 2007 Proficient
Students will get an overview of creating and managing projects. They will discuss resources, linking tasks, observe the critical path, and working with constraints. Students will get a general overview of outlining, generating project reports, resolving time restrictions and resource conflicts, as well as sorting and filtering data. Students will discuss tracking project progress, as well as adjusting schedules and costs.
|
Publisher 2003
Students will learn how to create flyers, brochures, business cards as well as multi-page documents using text, graphics, various formats and styles.
|
Publisher 2007
Students will learn how to create flyers, brochures, business cards as well as multi-page documents using text, graphics, various formats and styles.
|
QuickBooks 2007 Advanced
Upon successful completion of this course, students will be able to:
• customize forms.
• use the other QuickBooks accounts and track credit card transactions.
• create and modify various types of reports.
• create graphs.
• track and pay sales tax.
• track payroll information with QuickBooks.
• keep track of the job you are working on and generate reports for it.
• use QuickBooks to write various types of letters.
• synchronize QuickBooks with other contact management software.
|
QuickBooks 2007 Proficient
Students will learn how to manage the accounts of a small business. This will include creating invoices, writing cheques, paying bills, creating purchase orders, tracking inventory, creating various reports, and transferring information to Excel and Word.
|
Visio 2003 Level 1
Diagrams and charts play a pivotal role in knowledge dissemination, making complex data easy to understand. Microsoft® Office Visio® Professional 2007 has a host of features that are instrumental in creating pictorial representations of information. In this course, you will learn the essentials of Visio.
|
Visio 2003 Level 2
This course will build upon the knowledge gained, and enable you to work with many advanced features, including using the drawing tools, creating and working with custom stencils and templates, and sharing your Visio drawings with other applications.
|
Visio 2007 Level 1
Diagrams and charts play a pivotal role in knowledge dissemination, making complex data easy to understand. Microsoft® Office Visio® Professional 2007 has a host of features that are instrumental in creating pictorial representations of information. In this course, you will learn the essentials of Visio.
|
Visio 2007 Level 2
This course will build upon the knowledge gained, and enable you to work with many advanced features, including using the drawing tools, creating and working with custom stencils and templates, and sharing your Visio drawings with other applications.
|
Windows 7 level 1
You will log on to Windows 7, explore its interface, identify the different components in the interface, customize the Windows 7 desktop, manage files and folders, use the common tools and programs available in Windows 7, and browse the Internet.
This course can be customized to meet your needs.
|
Windows 7 level 2
This course is designed to provide you with skills that will help you manage some of the advanced tasks available in Windows® 7. In this course, you will familiarize yourself with the advanced customization techniques and work with applications and programs in Windows® 7. In addition to this, you will also work with Internet Explorer 8, manage network communications and data, and enhance system performance
|
Windows 7 Transition from Windows XP
This half day course is designed for persons who are familiar with and comfortable working in Windows XP and want to upgrade to the new and enhanced features of Windows 7. This course is not for students who are first-time Windows users.
This course can be customized to meet your needs.
|
Word 2003 Level 1
Students will learn how to create and edit documents, format text, paragraphs, and pages. The use of proofing tools, lists, and tables will also be covered.
|
Word 2003 Level 2
Students will learn how to manage lists (sorting); customise tables and charts: apply advanced formatting, text flow, styles; modify graphics and diagrams. The use of mail merge and templates will also be covered.
|
Word 2003 Level 3
Students will learn how to reference document content (table of contents, index, cross referencing, footnotes and endnotes). Embedding external content (eg Excel tables and charts), document versions, forms, tracking changes, securing the document, and long document considerations will be presented.
|
Word 2007/2010 Level 1
Students will explore the user interface and learn how to open and view a document, customize the word environment, obtain help, enter and format text, save a document, use tables, insert graphics, control page layout and use the spell check and thesaurus.
|
Word 2007/2010 Level 2
Students will learn how to manage lists, customize tables and charts, modify pictures, create customized graphic elements, use quick parts to insert content, control text flow, use templates to automatic document creation, automate mail merges and use macros.
|
Word 2007/2010 Level 3
Students will learn how to reference document content (table of contents, index, cross referencing, footnotes and endnotes). Embedding external content (eg Excel tables and charts), document versions, forms, tracking changes, securing the document, and long document considerations will be presented.
|