Iris Training Solutions

Office Productivity Courses

R1300 Per Delegate

Basic Computing

In today’s digital age, computer literacy is an essential skill for everyday life. We rely on computers for tasks such as checking emails, finding great deals, getting directions, and seeking answers from search engines like Google. Many people carry around powerful computers in their pockets, known as smartphones. If you haven’t yet ventured into the world of smartphones or have managed to avoid using desktops or laptops at home or in your workplace, don’t fret. It’s never too late to become computer literate.

This course has been meticulously crafted to provide you with a comprehensive introduction to the basics of using a personal computer. You will gain proficiency in keyboard and mouse operations and learn to navigate the Microsoft Windows 10 Operating System. Throughout the course, you’ll also receive a fundamental overview of working with various applications and managing windows effectively.

Our step-by-step guide to acquiring fundamental computer skills is tailored to empower you, whether you intend to use a computer at home or in a professional setting.

1. Computer Fundamentals
2. Keyboard Proficiency
3. Microsoft Word Basics
4. Introduction to Typing
5. Essential Windows Skills
6. Microsoft Excel Fundamentals
7. Mastering Mouse Usage
8. Internet and Email Essentials
9. Introduction to Microsoft PowerPoint
10. FREE Typing Tutor Included

Upon successful completion of this course, a certificate of achievement will be awarded to all learners, showcasing your newly acquired computer literacy skills.

While prior knowledge of keyboard and mouse operations is beneficial, it is not mandatory. Learners should be comfortable with reading and writing in English to fully engage with the course materials

MS Excel

In today’s data-driven world, organizations rely heavily on information to make informed decisions. However, the ever-expanding volume of data can be overwhelming. Fortunately, Microsoft® Office Excel® is a powerful tool that can help you efficiently organize, calculate, analyze, and present data. Excel simplifies complex tasks, enabling you to save time and reduce errors compared to traditional pen-and-paper methods or non-specialized software.
This course serves as a foundational guide to Excel, equipping you with essential knowledge and skills that can be developed into expertise in data manipulation. The Microsoft Excel course is structured into three levels: Essentials, Intermediate, and Advanced, designed to align with the Microsoft Office Specialist certification.

Microsoft Excel Level 1 (1 day)
Module 1: Introduction to Spreadsheets
In this module, you’ll grasp the fundamental concepts of spreadsheets, including their purpose and use. You’ll also learn about various spreadsheet programs, understand the benefits of using them, and identify spreadsheet properties.
Module 2: Getting Started with Excel
For beginners, Excel can seem overwhelming. This module will demystify Excel’s interface, covering the basics such as opening Excel, navigating the interface, creating worksheets, saving files, and using the help system.
Module 3: Performing Calculations
Excel’s real-time calculation capabilities are a powerful asset. You’ll learn how to create formulas, ensure data integrity, and calculate complex and simple equations efficiently.
Module 4: Modifying a Worksheet
This module explores basic data manipulation tasks, including inserting, manipulating, deleting cells, columns, and rows, as well as searching for and replacing data.
Module 5: Formatting a Worksheet
Discover how to enhance the visual appeal and readability of your worksheets by modifying fonts, adding borders and colors to cells, applying number formats, aligning cell contents, and using cell styles.
Module 6: Checking and Printing the Spreadsheet
Learn how to check for spelling and grammar errors, define page layouts for printing, and refine page layouts while exploring Excel’s printing functionality.
Module 7: Customizing the Excel Environment
This module delves into customizing Microsoft Excel 2016 to suit your specific needs, covering general, language, formula, proofing, and saving options, version control, ribbon customization, and enabling add-ins.
Microsoft Excel Level 2 (1 day)
Module 1: Problem Solving with Spreadsheets
This module focuses on using Excel to prepare and produce spreadsheets that address specific problems. You’ll learn how to customize the view and preferences of the spreadsheet.
Module 2: Advanced Calculations
Explore advanced calculations, including working with range names, formulas, functions, and applying them to provide alternative solutions to problems.
Module 3: Organizing Worksheet Data with Tables
Learn how to create and modify tables, use subtotal features, and utilize database functions to organize data effectively.
Module 4: Visualizing Data with Charts
Discover the power of data visualization with Excel as you create, modify, format charts, add trendlines, and work with advanced charting options.
Module 5: Inserting Graphics
Enhance your worksheets’ visual appeal by inserting and modifying graphical objects, layering and grouping them, and incorporating SmartArt.
Module 6: Applying Formatting and Special Effects
Improve worksheet readability through various formatting and special effects, including international symbols and themes.
Module 7: Auditing Worksheets
This module covers evaluating formulas, troubleshooting invalid data, using the trace cells feature, and performing What-If Analysis scenarios.
Module 8: Working with Multiple Worksheets
Learn how to format worksheet tabs, manage worksheets, control views, and handle large worksheets for efficient printing.
Microsoft Excel Level 3 (1 day)
Module 1: Enhancing Workbooks
Customize workbooks further, create and use templates, and protect files to enhance workbook functionality.
Module 2: Automating Worksheet Functionality
Speed up repetitive tasks with automatic worksheet functionality, including updating workbook properties, creating and editing macros, applying conditional formatting, and adding data validation criteria.
Module 3: Analyzing and Presenting Data
Master data analysis and presentation with topics like creating Sparklines, data list outlines, statistical analysis with the Analysis ToolPak, and interactive data with Power View.
Module 4: Importing and Exporting Data
Learn to import and export data efficiently, including exporting Excel data, importing delimited text files, integrating Excel data with the web, and creating web queries.
Module 5: Managing Large Workbooks
Efficiently manage and manipulate data within large workbooks through consolidation, merging, sorting, and filtering.
Module 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
Harness the power of PivotTables for data analysis and explore filtering data with slicers and creating PivotCharts.
Module 7: Analyzing Data with Logical and Lookup Functions
Delve into specialized Excel functions for text analysis, logical operations, lookup functions, date functions, financial functions, and more.

This Excel training program aligns with the Microsoft Office Specialist certification.

Learners should possess basic knowledge of using Windows 10 and be proficient in reading and writing in English.

MS Word

In today’s digital age, electronic word processing has become an integral part of our daily lives. Whether we’re composing professional documents or simply jotting down notes, the convenience of using a computer to create and edit text is something we often take for granted. In the business world, proficiency in word processing software is essential, spanning across various professions, from managers and lawyers to clerks, reporters, and editors. Whether you’re an executive secretary or a website designer, understanding the intricacies of electronic word processing is a valuable skill.
Microsoft Word is a versatile tool designed to simplify the creation of professional-looking documents. Its robust features and powerful tools can not only make your work efficient but also enjoyable. In this course, you will learn how to use Microsoft Word to create, edit, format, and proofread documents. The Microsoft Word course is divided into three levels: Essentials, Intermediate, and Advanced, aligned with the Microsoft Office Specialist certification.

Microsoft Word Level 1 (1 day)
Module 1: Getting Started with Word
In this module, you’ll become acquainted with the Word interface, learn how to create basic documents, and utilize the built-in help system effectively.
– Identify the components of the Word interface
– Create a Word document
– Use the help system in Microsoft Word
Module 2: Editing a Document
Discover efficient techniques for navigating and modifying text within documents, including text selection and modification features.
– Navigate and select text
– Modify text
– Find and replace text
Module 3: Formatting Text and Paragraphs
Learn how to apply character formatting, control paragraph layout, manage lists, and apply styles to enhance your documents.
– Apply character formatting
– Align text using tabs
– Display text as list items
– Manage lists
– Control paragraph layout
– Insert section breaks
– Apply borders and shading to text
– Apply styles to text
– Insert automatic fields
– Manage formatting
Module 4: Working with Multiple Documents
Master the art of handling multiple documents, including opening, arranging, and moving text between them.
– Open and arrange multiple documents
– Manipulate text between active documents
Module 5: Using and Creating Templates
Explore the world of templates in Microsoft Word, learning how to create, modify, and utilize them effectively.
– Create a document using a template
– Create and modify a template
Module 6: Inserting Graphic Objects
Discover how to insert symbols, special characters, images, text boxes, pull quotes, and even videos into your Word documents.
– Insert symbols and special characters
– Add images to a document
– Create text boxes and pull quotes
Module 7: Controlling Page Appearance
Gain control over your document’s appearance by adding page borders, watermarks, headers, footers, footnotes, section breaks, and adjusting page layout settings.
– Apply a Page Border and Color
– Add a Watermark
– Add Headers and Footers
– Control Page Layout
– Insert footnotes and endnotes
Module 8: Proofing a Document
Learn how to ensure the accuracy and professionalism of your documents by using spell check, grammar checks, and other proofing tools.
– Check Spelling and Grammar
– Utilize Other Proofing Tools
– Check Accessibility
Microsoft Word Level 2 (1 day)
Module 1: Adding Tables
Unlock the power of tables to organize information effectively within your documents. Learn how to insert, modify, format tables, and even convert text to tables.
– Insert a table
– Modify a table
– Format a table
– Convert text to a table
Module 2: Working with Tables and Charts
Delve into managing table-based data with features like sorting, controlling cell layout, performing calculations within tables, and creating charts.
– Sort table data
– Control cell layout
– Perform calculations in a table
– Create a chart
Module 3: Using Images in a Document
Explore various techniques for resizing, cropping, adjusting, and integrating images, screenshots, and videos into your Word documents.
– Resize an image
– Adjust image appearance
– Integrate pictures and text
– Insert and format screenshots
– Add videos to a document
Module 4: Creating Custom Graphic Elements
Learn to insert, modify, and format various shapes, such as arrows, callouts, mathematical symbols, and more, to enhance your documents.
– Draw shapes
– Add WordArt and drop caps to text
– Create complex illustrations with SmartArt
Module 5: Inserting Content Using Quick Parts
Discover the power of building blocks and Quick Parts, which enable you to save and reuse content elements efficiently.
– Insert building blocks
– Create and modify building blocks
– Insert fields using Quick Parts
Module 6: Controlling Text Flow
Fine-tune text flow within complex documents by setting paragraph flow options, inserting columns, and linking text boxes.
– Control paragraph flow
– Insert columns
– Link text boxes to control text flow
Module 7: Using Mail Merge
Master the art of mail merge, an invaluable time-saving tool in Word. Explore the Mail Merge Wizard and create envelopes, labels, and data sources.
– Learn about mail merge features, including manual tools and the Mail Merge Wizard
– Merge envelopes and labels
– Create a Data Source Using Word
Module 8: Customizing the Word Environment
Tailor the Microsoft Word interface to your specific needs by customizing various elements and settings.
– Customize the Word interface
– Set additional save options
– Manage additional file types
Microsoft Word Level 3 (1 day)
Module 1: Enhancing Workbooks
Customize workbooks further, create and utilize templates, and protect your files effectively.
– Customize workbooks
– Create and use templates
– Protect files
Module 2: Automating Worksheet Functionality
Speed up repetitive tasks by adding automatic worksheet functionality, including updating workbook properties, creating and editing macros, applying conditional formatting, and adding data validation criteria.
– Update workbook properties
– Create and edit a macro
– Apply conditional formatting
– Add data validation criteria to a workbook
Module 3: Analyzing and Presenting Data
Learn to analyze and present data effectively by creating Sparklines, data list outlines, performing statistical analysis with the Analysis ToolPak, and creating interactive data with Power View.
– Create Sparklines
– Create a Data List Outline
– Perform statistical analysis with the Analysis ToolPak
– Create interactive data with Power View
Module 4: Import and Export Data
Master the art of importing and exporting data to and from Excel, including exporting Excel data, importing delimited text files, integrating Excel data with the web, and creating web queries.
– Export Excel data
– Import a delimited text file
– Integrate Excel data with the web
– Create a web query
– Import and export XML data
Module 5: Managing Large Workbooks
Effectively consolidate, link, sort, and filter data within spreadsheets to manage large workbooks efficiently.
– Consolidate data
– Merge workbooks
– Sort and filter data
Module 6: Analyzing Data within PivotTables, Slicers, and PivotCharts
Harness the power of PivotTables for data analysis and explore filtering data with slicers, as well as creating PivotCharts.
– Create a PivotTable
– Filter data using slicers
– Analyze data using PivotCharts
Module 7: Analyzing Data with Logical and Lookup Functions
Explore specialized functions for text analysis, logical operations, lookup functions, date functions, financial functions
, and more.
– Use text functions
– Use logical functions
– Use lookup functions
– Use date functions
– Use financial functions
– Use specialized functions

This Word training program aligns with the Microsoft Office Specialist certification.

Learners should have basic knowledge of using Windows 10 and be proficient in reading and writing in English.

Serviced 4 Provinces

20 Accredited Courses

10 Staff Members

50 Satisfied Clients

Level 1 BBBEE

MS Power Point

Microsoft PowerPoint is a versatile and user-friendly presentation program that empowers users to create compelling visual presentations. This version of PowerPoint introduces new features and connectivity options to enhance collaboration and productivity. This course is designed to provide novice computer users with a quick and comprehensive introduction to PowerPoint. It covers various aspects of the interface, demonstrates how to create, save, and deliver a basic presentation, and discusses essential formatting techniques.
By the end of this course, participants will feel confident in creating new presentations, giving them a polished and professional appearance, and effectively saving and delivering their slide shows.

Microsoft PowerPoint Level 1 (1 day)
Module 1: Getting Started with PowerPoint
Introduce yourself to the PowerPoint environment and learn how to navigate, create, and save a PowerPoint presentation. Utilize the help system effectively.
– Navigate the PowerPoint Environment
– Create and Save a PowerPoint Presentation
– Use Help
Module 2: Developing a PowerPoint Presentation
Explore how to customize PowerPoint’s default blank template and utilize fundamental tools for building a presentation. Learn to select presentation types, build and structure slides, edit text, and navigate through presentations.
– Select a Presentation Type
– Build a Presentation
– Lay Out a Presentation
– Edit Text
– View and Navigate a Presentation
Module 3: Format the Presentation
Discover techniques for formatting presentations, including paragraph formatting, bulleted and numbered lists, text alignment, spacing options, and formatting text boxes.
– Format Paragraphs
– Bulleted and Numbered Lists
– Text Alignment
– Spacing Options
– Format Textboxes
Module 4: Insert Graphical Elements
Learn to enhance your presentations by inserting images and WordArt. Graphics play a vital role in conveying your message effectively.
– Insert WordArt
– Insert Images
Module 5: Customize the PowerPoint
Customization is key to personalizing your presentation. Learn how to add sections, headers, and footers to streamline changes across multiple slides.
– Create and Manage Sections
– Add Headers and Footers
Module 6: Preparing to Deliver your Presentation
Before presenting, ensure your presentation is ready. Learn to review, print, and deliver your PowerPoint presentation confidently.
– Review Your Presentation
– Print Your Presentation
– Deliver Your Presentation
Microsoft PowerPoint Level 2 (1 day)
Module 1: Work with Images, Drawings, and Objects in MS PowerPoint
Delve into the world of images, drawings, and SmartArt in PowerPoint. Discover how to insert pictures, shapes, and SmartArt diagrams effectively.
– Insert Pictures/Images into a Presentation
– Insert Shapes
– Insert SmartArt
Module 2: Customize Master Slides in a Presentation
Master slides are essential for controlling the theme and slide layouts of a presentation. Learn to modify slide masters, slide layouts, notes masters, and handout masters.
– Modify Slide Masters and Slide Layouts
– Modify the Notes Master and Handout Master
Module 3: Modifying Objects in Your Presentation
Master the art of object manipulation, including selecting, editing, resizing, compressing, changing, and resetting images, shapes, and text boxes.
– Edit Objects
– Arrange Objects
– Animate Objects
– Modify SmartArt
– Format Characters
Module 4: Adding Tables to Your Presentation
Tables are a powerful tool for organizing data. Learn to create and format tables, and import tables from other MS applications.
– Create a Table
– Format a Table
– Insert a Table from Other MS Applications
Module 5: Adding Charts to Your Presentation
Effectively convey complex data through charts and graphs. Learn to create, format, and manipulate charts in PowerPoint.
– Create a Chart
– Format a Chart
– Manipulate a Chart
Module 6: Apply Animation Effects and Transitions
Make your presentation engaging by adding animation effects and transitions. Learn to apply and customize animations and transitions.
– Apply Animation Effects
– Apply Transitions
– Customize Animations and Transitions
Microsoft PowerPoint Level 3 (1 day)
Module 1: Modifying the PowerPoint Environment
Harness advanced customization options to control the PowerPoint environment. Customize the ribbon categories, Quick Access Toolbar, and tailor your PowerPoint experience.
– Explore Advanced Customization Options
– Customize the Ribbon Category
– Customize the Quick Access Toolbar
Module 2: Customizing Design Templates
Master the art of creating and using design templates in PowerPoint. Learn to create, save, and edit templates to ensure consistency and efficiency in your presentations.
– Create a Template for Presentation Purposes
– Save a Template with a Specific Name in a Specific Folder
– Use a Created Template to Produce a Presentation
– Edit a Created Template According to User Requirements
Module 3: Manipulating Graphical Elements and Drawn Objects
Understand the importance of visuals in presentations. Learn to group, distribute, add or hide background graphics/images, apply effects, and convert graphics/images for effective presentation.
– Group and Ungroup Drawn Objects on a Slide
– Distribute Selected Graphics/Images and Drawn Objects Relative to the Slide Space
– Add or Hide Background Graphics/Images in Slides
– Apply Effects to Drawn Objects
– Convert Graphics/Images to Facilitate Printing and Factual Requirements
Module 4: Working with Media
Enhance presentations by incorporating audio and video elements. Learn how to add audio and video, making your presentations engaging and memorable.
– Add Audio to a Presentation
– Add Video to a Presentation
Module 5: Collaborating on a Presentation
Discover collaborative features in PowerPoint, including adding comments, reviewing presentations, and sharing presentations on the web.
– Add Comments to a Presentation
– Review a Presentation
– Store and Share Presentations on the Web
Module 6: Customizing a Slide Show
Take control of your slideshow with annotations, slide show setup, custom slide shows, hyperlinks, action buttons, and recording options.
– Annotate a Presentation
– Set Up a Slide Show
– Create a Custom Slide Show
– Add Hyperlinks and Action Buttons
– Record a Presentation
Module 7: Securing and Distributing a Presentation
Protect sensitive presentations by securing them and controlling access. Learn to broadcast slide shows and create videos or CDs for distribution.
– Secure a Presentation
– Broadcast a Slide Show
– Create
a Video or a CD

This PowerPoint training program aligns with the Microsoft Office Specialist certification.

Participants should have a basic knowledge of using Windows 10 and be proficient in reading and writing in English.

MS Outlook

Email has become a ubiquitous method of communication, whether for personal or business purposes. In most organizations, regardless of size, email is the primary means of information exchange among employees. As email’s popularity and usage continue to grow, organizations often implement corporate email management systems like Microsoft® Office Outlook® to streamline communication, manage messages, and schedule meetings.
This course focuses on using Outlook to efficiently send, receive, and organize email messages, manage contact information, schedule appointments and meetings, create tasks and notes, and tailor the Outlook interface to suit your preferences.

Microsoft Outlook Level 1 (1 day)
Module 1: Understanding Electronic Messaging
Gain a comprehensive understanding of electronic messaging, including its benefits, limitations, and etiquette.
– Explore the Advantages of Email
– Recognize Email’s Limitations
– Learn Email Etiquette
Module 2: Getting Started with Outlook
Master the basics of using Outlook, including navigating the interface, performing essential email functions, and utilizing Outlook’s help features.
– Navigate the Outlook Interface
– Perform Basic Email Functions
– Utilize Outlook Help
Module 3: Composing Messages
Learn how to compose effective email messages, including addressing recipients, checking spelling and grammar, formatting message content, and attaching files.
– Create Email Messages
– Check Spelling and Grammar
– Format Message Content
– Attach Files and Items to Messages
Module 4: Reading and Responding to Messages
Discover various methods for reading and responding to messages in Outlook. Customize your reading options, work with email attachments, and prioritize your communication.
– Safely Handle Incoming Emails
– Customize Reading Options
– Manage Email Attachments
Module 5: Working with Multiple Email Messages
Efficiently handle multiple email messages, switch between them, and manipulate text across various messages.
– Manage Multiple Email Messages
– Manipulate Text Across Messages
Module 6: Customizing the Email Application
Tailor the Outlook interface to your preferences by adjusting toolbar menus and changing view headings.
– Customize Toolbar Menus
– Modify Current View Headings
Microsoft Outlook Level 2 (1 day)
Module 1: Legal, Ethical, and Organizational Considerations
Understand the legal, ethical, and organizational implications of using email, including legislation, security, and virus protection.
– Explore Legal Implications of Email Use
– Examine Organizational Email Facilities
– Address Security Considerations
Module 2: Configure Advanced Message Options
Enhance your email messages by incorporating advanced characters and objects. Learn to modify message settings, properties, and options.
– Improve Email Messages
– Insert Advanced Characters and Objects
– Modify Message Settings, Properties, and Options
Module 3: Managing Messages
Efficiently manage your email messages using tags, flags, folders, and search features. Optimize your mailbox to keep it organized.
– Use Tags, Flags, and Other Commands
– Organize Messages in Folders
– Search for Messages
– Manage Your Mailbox
Module 4: Managing Contacts
Learn how to create, update, view, and organize your contacts within Outlook.
– Create and Update Contacts
– View and Organize Contacts
Module 5: Working with Tasks and Notes
Master tasks and notes in Outlook, including creating, managing, and organizing them effectively.
– Create and Manage Tasks
– Manage Notes
Microsoft Outlook Level 3 (1 day)
Module 1: Advanced Message Management
Discover advanced message management techniques to efficiently handle a growing inbox. Customize email settings, manage automatic message content, and employ automatic replies, sorting, filtering, and junk mail management.
– Customize Email Settings
– Manage Automatic Message Content
– Utilize Automatic Replies
– Sort and Filter Messages
– Organize Messages
– Manage Junk Mail
Module 2: Managing Your Calendar
Effectively manage your calendar in Outlook by viewing appointments, managing meetings, and printing your schedule.
– View Your Calendar
– Manage Appointments
– Coordinate Meetings
– Print Your Calendar
Module 3: Advanced Calendar and Task Management
Fine-tune your calendar with advanced options, manage additional calendars, handle meeting responses, and assign and manage tasks effectively.
– Configure Advanced Calendar Options
– Manage Additional Calendars
– Handle Meeting Responses
– Assign and Manage Tasks
Module 4: Advanced Contact Management
Leverage advanced contact management options, including electronic business cards, advanced contact features, forwarding contacts, and exporting contacts.
– Edit Electronic Business Cards
– Manage Advanced Contact Options
– Forward Contacts
– Export Contacts
Module 5: Sharing Workspaces with Others
Explore the capability to delegate access to your mail folders, share your calendar, and collaborate on contacts with others using Microsoft Exchange email accounts.
– Delegate Access to Mail Folders
– Share Your Calendar
– Collaborate on Contacts
Module 6: Managing Outlook Data Files
Learn how to back up Outlook data files and configure data file settings to safeguard your important information.
– Back Up Outlook Data Files
– Configure Data File Settings
Module 7: Managing Email Security
Understand the importance of email security and learn to configure email message security settings, including encryption and digital signatures.
– Configure Email Message Security Settings

This Outlook training program aligns with the Microsoft Office Specialist certification.

Participants should have a basic knowledge of using Windows 10 and be proficient in reading and writing in English.

MS Access Database

Data plays a pivotal role in today’s world, permeating various aspects of our lives, from business and education to research and daily activities. Regardless of your profession or industry, data management is a skill that’s increasingly valuable. This course focuses on using Microsoft Office Access, a relational database application, to help you and your organization efficiently collect, manage, and utilize large volumes of data. Whether you’re a data specialist, researcher, accountant, or sales professional, Access can be a versatile tool for your data management needs.

Microsoft Access Level 1 (1 day)
Module 1: The Basics
Start your journey by understanding the fundamentals of Access, from creating databases to navigating the interface.
– Getting Started
– Signing In
– Creating a Database
– Database Terminology
– Saving and Opening Databases
Module 2: Your First Database
Dive deeper into database management by learning about security, relationships, and how to navigate and explore database objects.
– Understanding Security
– Navigating Database Objects
– Changing Object Views
Module 3: Working with Tables and Records
Learn how to create tables, manage records, and explore different table views to efficiently handle data.
– Creating Tables
– Exploring Table Views
– Adding, Editing, and Deleting Records
– Searching and Printing Records
Module 4: Formatting Tables
Enhance the visual presentation of your data by formatting tables, adjusting column and row dimensions, and applying text formatting.
– Selecting Data
– Adjusting Column and Row Dimensions
– Applying Text Formatting
– Adding Colors and Gridlines
– Checking Spelling
Module 5: Creating Forms
Discover how to create user-friendly forms to input data, whether from existing objects or from scratch.
– Creating Forms from Objects
– Using Form Wizards
– Creating Forms from Scratch
– Understanding Form Views
– Utilizing Forms
Module 6: Formatting Forms
Customize forms by adding bound and unbound controls, adjusting themes, using the Format Painter, and including images and logos.
– Understanding Bound and Unbound Controls
– Changing Form Themes
– Using the Format Painter
– Adding Fields and Controls
– Incorporating Images and Logos
Module 7: Creating Reports
Learn how to create informative reports, whether from existing objects, using the Report Wizard, or from scratch.
– Creating Reports from Objects
– Utilizing the Report Wizard
– Building Reports from Scratch
– Exploring Report Views
– Printing Reports
Module 8: Formatting Reports
Enhance the appearance of your reports with themes, formatting options, grouping and sorting data, adding controls, and including page numbers, headers, and footers.
– Applying Themes
– Using the Format Painter
– Grouping and Sorting Data
– Adding Controls and Images
– Including Page Numbers and Headers/Footers
Module 9: Creating Basic Queries
Master the art of querying data with basic queries, including sorting and filtering techniques.
– Understanding Query Types
– Creating Queries with the Query Wizard
– Running and Exploring Queries
– Sorting and Filtering Query Results
Module 10: Creating Advanced Queries
Take your querying skills to the next level with parameter queries, crosstab queries, make-table queries, multiple table queries, append queries, delete queries, and update queries.
– Creating Parameter Queries
– Designing Crosstab Queries
– Generating Make-Table Queries
– Formulating Multiple Table Queries
– Performing Append, Delete, and Update Queries
Module 11: Managing Your Database
Ensure the health of your database by learning about essential maintenance tasks such as compacting and repairing, encryption, backup, export, and printing.
– Compacting and Repairing Databases
– Encrypting Databases with Passwords
– Backing Up Your Database
– Exporting Database Objects
– Printing Database Objects
Module 12: Customizing the Interface
Tailor the Access interface to your preferences by adjusting the Ribbon, Quick Access Toolbar, hiding or showing tabs, creating custom Ribbon tabs, and resetting interface changes.
– Collapsing and Pinning the Ribbon
– Customizing the Quick Access Toolbar
– Hiding and Showing Ribbon Tabs
– Creating Custom Ribbon Tabs
– Resetting Interface Changes
Microsoft Access Level 2 (1 day)
Module 1: SQL and Microsoft Access
Explore advanced data management tasks such as importing and exporting information, copying data between Office programs, and using SQL statements.
– Importing Data into Access
– Exporting Data from Access
– Copying Data between Office Programs
Module 2: Using the SELECT Statement
Master the SELECT statement to retrieve specific data from tables, apply conditions, and sort data effectively.
– Selecting All Data
– Selecting Specific Data
– Selecting Conditional Data
– Sorting Data with ORDER BY
Module 3: Using SQL Joins
Learn about SQL joins to merge data from different tables, use aliases, sort joins, and implement outer joins for comprehensive data retrieval.
– Creating Simple Joins
– Employing Alias Names
– Sorting Joined Data
– Understanding Outer Joins
Module 4: Using Subqueries
Explore subqueries to build more complex queries by nesting queries, using aggregate functions, and employing the IN keyword.
– Understanding Subqueries
– Creating Subqueries
– Subqueries with Aggregate Functions

This Access training program aligns with the Microsoft Office Specialist certification.

Learners should have basic knowledge of using Windows 10 and be proficient in reading and writing in English.