ELECTUS
Adelaide, SA, Australia
http://www.electus.com.au/

Access Query and Reports

Using Simple Queries · Using Queries · The Simple Query Wizard · Creating a Query in Design View · Opening and Running a Query · Adding a Table to a Query Modifying Query Results · Sorting and Printing a Query · Adding Criteria to and Hiding a Field in a Query Creating Basic Reports · Using the Report Wizard · Using AutoReport · ......
 

This ½ day workshop provides an understanding about the value of the Pivot Tables and AutoFilter features within Excel. PivotTables are a great data analysis tool for management. They allow you to create multi dimensional data views by dragging and dropping column headings to move data around. Microsoft Excel also provides a very simple mechanism (AutoFilter) for filtering/s......
 

This workshop provides the necessary skills to utilise formulas and functions within an Excel worksheet. It also looks at some of the more advanced logical, date and many other in-built functions available within Excel. The in-built functions are special pre-written formulas that perform an operation or calculation on values in your worksheet, placing the result of the calculation in......
 

This course is designed to provide vocational education and training necessary to gain basic knowledge and skills common across all business roles. The course aims to give you skills in communication, teamwork, use of business technology and information handling. Units of competency encompass skills and knowledge for effective communication, sound teamwork, competent use of business tec......
 

This course is designed to provide vocational education and training necessary to gain basic knowledge and skills common across all business roles. The course aims to give you skills in communication, teamwork, use of business technology and information handling. Units of competency encompass skills and knowledge for effective communication, sound teamwork, competent use of business tec......
 

In this 2 day program, participants will gain the knowledge and skills to allow them to � You will learn to Ø Understand the Visual Basic environment Ø Write a simple program Ø Understand the basic use of Controls Ø Work with variables and operators Ø Work with menus and dialog boxes Ø Understand decision structures and loops Ø ......
 

This course aims to provide you with a good understanding of programming in Visual Basic for Applications (VBA), especially as it relates to Microsoft Word 2003. Course Content Recorded Macros · Recording a Simple Macro · Running a Recorded Macro · Assigning a Macro to a Toolbar · Editing a Recorded Macro VBA Concepts · Object Oriented and Event Driven · ......
 

This 3 day program aims to provide a good understanding of programming in Visual Basic for Applications (VBA), especially as it relates to Microsoft Excel. Course Content Recorded Macros · Macro Recorder Overview · Recording a Simple Macro · Running a Recorded Macro · Relative Recording · Running a Relative Recording · Viewin......
 

This 3 day program aims to increase your productivity by providing the skills and knowledge to program VBA in Access effectively. Development Basics · The Access Development Environment · The Importance of Splitting Databases · Maintaining Links · Using The Database Splitter · Using Queries for Reports and Forms · Access Ru......
 

This course expands upon the skills learnt in the Electus HTML Introduction course. By focussing in greater detail on the use of CSS (Cascading Style Sheets) in the construction of a website. The student will learn how to build websites that are: Search engine friendly Easier to maintain Have faster loading times Have increased accessibility across multiple platforms Yo......
 

This course aims to introduce participants to the basic elements of HTML (Hypertext Markup Language), the formatting language that underlies all sites on the World Wide Web. Despite the growing number of WYSIWYG (What You See is What You Get) html editors now available, the ability to write and edit HTML is still considered to be a necessity for those considering web authoring as a career. ......
 

In this 2-day program, participants will gain the knowledge and skills to allow them to create Flash movies. You will learn to Ø Create a new Flash file, import and manipulate images, convert bitmaps to vector graphics, create shapes using the Pencil and Pen tools and draw lines using the Line tool Ø Create shapes using Rectangle or Oval tools, create freeform shapes u......
 

In this 2-day program, participants will gain the knowledge and skills to allow them to use more animation techniques, ActionScript, behaviours, audio and video techniques. You will learn to Ø Create and edit movie clips Ø Create movie clip masks, guide a mask, mask a guide and apply, edit and delete Timeline effects Ø Apply basic ActionScript to create intera......
 

This course provides the tools to help professionals visualise existing ideas, information and systems and to prototype new ones. Students will learn how to fully utilise Visio’s drawing features to create professional looking drawings with increased efficiency. You will learn to Ø Create a new file and use interactive Help, navigate in a Visio file, manipulate stencils, s......
 

This course provides the tools to help professionals learn how to fully utilise Visio’s more advanced drawing features and to create cross-functional flowcharts, use layers, link data and create templates. You will learn to Ø Create cross-functional flowcharts, apply a background to a flowchart, add text to a flowchart and format the layout, create custom colors and add sh......
 

In this 1-day program, participants will gain the knowledge and skills to allow them to create newsletters, brochures and business forms using Publisher. You will learn to Ø Create a new publication using the Task Pane and Wizard Ø Navigate pages Ø Insert and edit personal information Ø Change the design......
 

In this 2-day program, participants will gain a working knowledge of the Microsoft Project application to create and manage projects. You will learn to Ø Work with the Project interface Ø Start and save a project Ø Define and change the working hours Ø Use a project template Ø Enter tasks, durations and milestones Ø Enter recurring t......
 

This 1-day program is designed to develop advanced skills including managing multiple projects. This course does not include Project Server. You will learn to Ø Create customised views, templates and outline codes Ø Manage large projects by creating master projects and subprojects Ø Share resources between projects using resource pools Ø Import infor......
 

This course aims to introduce students to advanced methods of video editing with the application Adobe Premiere. During the course students will learn the advanced features of editing and using 3rd party Transitions and Filters You will learn to Ø Create multiple motion layers on the timeline Ø Create multiple chroma key effects on the timeline Ø Use 3rd Party Filte......
 

In this 1 day program, you will gain the knowledge and skills to allow them to create slide presentations incorporating edited graphics, charts, and customised designs. You will learn how to minimise time spent building content and formatting by using PowerPoint’s templates and wizards. You will learn to Ø Create textual and graphical slides Ø Format the Slide Master ......
 

Pages:- 1 2 3 4

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.