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/2010 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/2010 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/2010 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.
|
Crystal Reports Level 1
This course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret information.
As a business benefit, learners will find that this course is an in-depth approach to the entire report creation cycle from planning a report prototype to distributing a report.
|
Crystal Reports Level 2
This course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret information.
As a business benefit, learners will find that their increased understanding of formulas, variables, arrays, templates, parameters, summaries, and sections will help them make more effective report design decisions and create more efficient reports.
|
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.
|
MOS 2010 Excel Expert, Exam preparation
Prepares the student for the MOS Excel 2010 Expert exam 77-888
|
MOS Microsoft Office Excel Expert Training
|
Office 2007/2010 - New Features
This half day class can be customised to suit your needs.
|
Office 2013 New Features
An overview of the new features in Word, Excel and PowerPoint in Office 2013. This class can be customized to suite 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.
|
Photoshop CS6 level 1
You will understand and use the various elements in the Photoshop CS6 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 CS6 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.
|
Project 2010 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 2010 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.
|
Publisher 2010
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.
|
Quickbooks Pro 2013 level 1
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.
|
Quickbooks Pro 2013 level 2
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.
|
SharePoint 2007: Introduction
This 1- day SharePoint 2007 course gives students who have Contribute or Administrative permission for a site the ability to manage, administer, and modify a SharePoint site. Students will be shown how to create sub-sites, create libraries and lists, basic workflows, integrate Office 2007 with SharePoint and administer SharePoint sites.
|
SharePoint 2010 end user Level 1
This course explores all the basic end user features of SharePoint 2010 including all basic lists and sites.
|
SharePoint 2010 Foundation for end users
In this course for SharePoint 2010 power users and site administrators, you will gain an understanding of the major components of SharePoint 2010 and learn the new features and capabilities of SharePoint 2010. During the hands-on labs, you will walk through the site-creation process, covering basic features of the basic team site. You will be guided through understanding SharePoint Server site definitions (business intelligence, search center, etc.) and creating Workflows, and coverage of My Sites, permissions, site administration, site customization, and site collection administration.
|
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/2010 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/2010 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.
|