Bill Elliott IT Consultancy Telephone +44(0)1268 764244
12 Drummond Place Facsimile +44(0)1268 761571
Wickford Essex Mobile
+44(0)7970 015538
SS12 9LL Email bill@billelliott.net
United Kingdom To print this page, use this Window's File menu to set Page Setup to A4 Portrait and Click the Print Icon above.

 

 

 

 

 

Course Outlines
All Trademarks Acknowledged
Microsoft Office 97
Word Processing:
Word 97 Introduction                                                                                                                S71001
The Word screen, help facilities, creating a new document, moving around in a document, selecting/deleting text, inserting the date and time, using the toolbars, undo/redo, saving/opening/closing a document, previewing/printing, hard spaces/hyphens, formatting/indenting paragraphs, line spacing, tabs, numbering/bullets, format painter, page layout (margins, paper size/orientation, numbering, view), cut/copy/paste, drag & drop editing, using multiple windows, finding/replacing text, introduction to tables, labels, spell checking, autocorrect, autoformat, changing fonts and text size, changing the appearance of text, headers/footers, shortcut menus.
Word 97 Intermediate                                                                                                               S71002

Tables (entering text, inserting/deleting/moving/copying rows and columns, performing calculations, entering/editing formula and functions, changing column width and row height, table alignment, borders and shading, autoformat, converting table to text and text to table), creating and formatting newspaper style columns and converting existing text, document sorting, mailmerge (creating main document and datasources, toolbars, mergefields) thesaurus, grammar checker, paragraph formatting (text flow, drop capitals, borders and shading, lines), sections (margins, paper size, page layout, headers and footers page numbering), pictures, clipart.

Word 97 Advanced                                                                                                                   S71003
Outlining (headings, body text, sub text, applying styles, promoting/demoting, reorganising a document, compiling a table of contents, printing an outline), master documents (creating master/sub documents, re-arranging, splitting, merging, removing), DDE linking, embedding, graphs, macros (recording, running, assigning to key combinations/toolbar buttons), forms (text fields, check boxes, drop down lists, running macros from forms), fillin command.
Spreadsheets:
Excel 97 Introduction                                                                                                               S71004
The Excel screen, help facilities, toolbars, formula bar, saving/opening/closing files, wizards, moving around worksheets, selecting cells/ranges/sheets, rows/columns, undo/redo, renaming cells/sheets, inserting, deleting, moving, copying, drag and drop, in cell editing, numbers/text, formulae and functions, autosum, series, adjusting column widths/row heights, formatting cells (number formats, custom number formats, alignment of entries, fonts, borders and patterns) format painter, drawing tools, text boxes, page layout, previewing/printing, spell checker, views, auditing, finding/replacing, creating embedded charts, chart sheets, formatting chart items and changing chart data.
Excel 97 Intermediate                                                                                                             S71005
Logical and lookup functions (if, sumif, countif & vlookup), outlining (automatic and manual) linking (using names in linking formula, redirecting/ viewing/ opening/ updating links, linking to other applications) embedding data and graphic objects, data consolidation, protection (password, preventing files from being opened and changes from being saved, hiding/unhiding), customisation of workspace settings and toolbars, templates, lists (dataforms, sorting, filtering subtotals).
Excel 97 Advanced                                                                                                                 S71006
Creating & using styles (by definition, redefining), Error handling and Auditing features (iserror function, tracer arrows precedents, dependants) Pivot tables (creating, adding fields, subtotal summary, refreshing, viewing, grouping, ungrouping) moving sheets between workbooks, data analysis tools (goal seek, solver), scenarios, notes, view manager, macros (creating, assigning, running, editing), Additional functions (Transpose, Convert, Randbetween, Networkdays).
Graphics
Powerpoint 97 Introduction                                                                                                    S71007
Screen, toolbars, views (slide view, outline, slide sorter view, notes view, slide show), working with slides, editing slide masters, changing defaults for all presentations, creating a custom template, slide layout, templates, working with text, title text and body text, using the text tool, typing text into shapes, making text word-wrap, text ruler, spell-check OLE objects, drawing tools, terminology, boxes, ellipses & other autoshapes, resizing objects, moving objects, connecting objects, rotate/flip, rotate or flip a clip art object, inverting text objects, lines & arcs, freeform tool, fills & shadows, changing object defaults, working with objects.
Powerpoint 97 Intermediate                                                                                                  S71008
Moving & aligning objects, stacking objects, cutting, copying, pasting & duplicating objects, using clipart, inserting clipart, replacing a clipart picture, re-sizing clipart, recolour picture, creating graphs, inserting a graph, edit a graph, insert a graph from excel, insert an excel worksheet, insert a word table, organisation charts, formatting the organisation chart, wordart, create animated slides, animate text and objects, animate the elements of a chart, change the order in which animated objects appear on a slide, add an effect to an animated object after it appears.
Powerpoint 97 Advanced                                                                                                      S71009
Insert a video on a slide, insert music or sound on a slide, insert a cd audio track on a slide, inserting a black slide at the close of your presentation, running a presentation on screen, transitions, bullet builds setting slide timings while rehersing, custom shows, save as powerpoint show, tips for presentations, printing a presentation, printing slides, shortcut keys, tips & hints, design tips & hints, action buttons and hyperlinks, publishing presentations on a Web Site.
Microsoft Office 2000, 2002 & 2003
Word Processing:
Word 2000/2002/2003 Introduction                                                                                         S01010
The Word screen, help facilities, creating a new document, moving around in a document, selecting/deleting text, inserting the date and time, using the toolbars, undo/redo, saving/opening/closing a document, previewing/printing, hard spaces/hyphens, formatting/indenting paragraphs, line spacing, tabs, numbering/bullets, format painter, page layout (margins, paper size/orientation, numbering, view), cut/copy/paste, drag & drop editing, using multiple windows, finding/replacing text, introduction to tables, labels, spell checking, autocorrect, autoformat, changing fonts and text size, changing the appearance of text, headers/footers, shortcut menus.
Word 2000/2002/2003 Intermediate                                                                                        S01011
The Word screen, help facilities, creating a new document, moving around in a document, selecting/deleting text, inserting the date and time, using the toolbars, undo/redo, saving/opening/closing a document, previewing/printing, hard spaces/hyphens, formatting/indenting paragraphs, line spacing, tabs, numbering/bullets, format painter, page layout (margins, paper size/orientation, numbering, view), cut/copy/paste, drag & drop editing, using multiple windows, finding/replacing text, introduction to tables, labels, spell checking, autocorrect, autoformat, changing fonts and text size, changing the appearance of text, headers/footers, shortcut menus.
Word 2000/2002/2003 Advanced                                                                                            S01012
Outlining (headings, body text, sub text, applying styles, promoting/demoting, reorganising a document, compiling a table of contents, printing an outline), master documents (creating master/sub documents, re-arranging, splitting, merging, removing), DDE linking, embedding, graphs, macros (recording, running, assigning to key combinations/toolbar buttons), forms (text fields, check boxes, drop down lists, running macros from forms), fillin command.
Spreadsheets:
Excel 2000/2002/2003 Introduction                                                                                        S01013
The Excel screen, help facilities, toolbars, formula bar, saving/opening/closing files, wizards, moving around worksheets, selecting cells/ranges/sheets, rows/columns, undo/redo, renaming cells/sheets, inserting, deleting, moving, copying, drag and drop, in cell editing, numbers/text, formulae and functions, autosum, series, adjusting column widths/row heights, formatting cells (number formats, custom number formats, alignment of entries, fonts, borders and patterns) format painter, drawing tools, text boxes, page layout, previewing/printing, spell checker, views, auditing, finding/replacing, creating embedded charts, chart sheets, formatting chart items and changing chart data.
Excel 2000/2002/2003 Intermediate                                                                                       S01014
Logical and lookup functions (if, hlookup, vlookup), outlining (automatic and manual) linking (using names in linking formula, redirecting/ viewing/ opening/ updating links, linking to other applications) embedding data and graphic objects, data consolidation, protection (password, preventing files from being opened and changes from being saved, hiding/unhiding), customisation of workspace settings and toolbars, templates, lists (dataforms, sorting, filtering subtotals).
Excel 2000/2002/2003 Advanced                                                                                           S01015
Creating & using styles (by definition, redefining), Error handling and Auditing features (iserror function, tracer arrows precedents, dependants) Pivot tables (creating, adding fields, subtotal summary, refreshing, viewing, grouping, ungrouping) moving sheets between workbooks, data analysis tools (goal seek, solver), scenarios, notes, view manager, macros (creating, assigning, running, editing), Additional functions (Transpose, Convert, Randbetween, Networkdays).
Databases:
Access 97/2000/2002/2003 Introduction                                                                                 S01016
Database design, Access screen, creating/saving/opening/closing databases, help facilities and cue cards, toolbars, wizards, creating tables, adding fields/names/data-types/descriptions, inserting/deleting/rearranging fields, primary key, field properties, saving table design, entering data into datasheets, adding/editing/saving records, selecting data/rows/columns, moving/copying/deleting data, datasheet view (moving columns, changing column width, hiding/showing and freezing columns, changing font/row height) saving table layout, finding/replacing data, filtering records, creating queries (select, crosstab and parameter queries, renaming fields, calculated fields, totals, combining text fields), relationships, creating and using forms and reports.
Access 97/2000/2002/2003 Intermediate                                                                                S01017
Advanced form design (adding controls, combo/list boxes, subforms, expressions and functions), graphs, action queries, union queries, advanced reporting (grouping data, running sum, percentages, headers/footers, page numbering, sub reports, templates).
Access 2000/2002/2003 Advanced                                                                                        S01018
Macros (event properties, groups, actions and arguments, referring to forms and reports, conditions, autokeys, autoexec) introduction to Access Basic, customising menus/toolbars, database security, object linking and embedding, mailmerge with Word.
Graphics:
Powerpoint 2000/2002/2003 Introduction                                                                              S01019
Screen, toolbars, views (slide view, outline, slide sorter view, notes view, slide show), working with slides, editing slide masters, changing defaults for all presentations, creating a custom template, slide layout, templates, working with text, title text and body text, using the text tool, typing text into shapes, making text word-wrap, text ruler, spell-check OLE objects, drawing tools, terminology, boxes, ellipses & other autoshapes, resizing objects, moving objects, connecting objects, rotate/flip, rotate or flip a clip art object, inverting text objects, lines & arcs, freeform tool, fills & shadows, changing object defaults, working with objects.
Powerpoint 2000/2002/2003 Intermediate                                                                             S01020
Moving & aligning objects, stacking objects, cutting, copying, pasting & duplicating objects, using clipart, inserting clipart, replacing a clipart picture, re-sizing clipart, recolour picture, creating graphs, inserting a graph, edit a graph, insert a graph from excel, insert an excel worksheet, insert a word table, organisation charts, formatting the organisation chart, wordart, create animated slides, animate text and objects, animate the elements of a chart, change the order in which animated objects appear on a slide, add an effect to an animated object after it appears.
Powerpoint 2000/XP Advanced                                                                                            S01021
Insert a video on a slide, insert music or sound on a slide, insert a cd audio track on a slide, inserting a black slide at the close of your presentation, running a presentation on screen, transitions, bullet builds setting slide timings while rehersing, custom shows, save as powerpoint show, tips for presentations, printing a presentation, printing slides, shortcut keys, tips & hints, design tips & hints, action buttons and hyperlinks, publishing presentations on a Web Site.
Personal Computers, Microsoft Windows 98 , 2000, XP, 2003
Personal Computers
Introduction to Personal Computers                                                                                S11022 ½ Day Course
Course History of personal computers, introduction to the hardware (disk drives, monitor, keyboard, mouse), printers, the operating system, the concept of files, directories, diskettes (handling, formatting), types of storage media, care of p/c's, backups/restore, overview of word processing, spreadsheet and database software packages, data protection.
Microsoft Windows
Introduction to Windows 98                                                                                             S81023 ½ Day Course
The environment, (screen, mouse, start button, taskbar), working with windows (moving, sizing, minimise/maximise, restore, close, scrollbars, cascading), the toolbar, menus and right clicks, working with groups (programs, my documents, settings, control panel, printers), the desktop, help facilities, wordpad, explorer, organising files and folders (creating, deleting, copying & moving).
Introduction to Windows 2000/XP                                                                                    S01024 ½ Day Course
The environment, (screen, mouse, start button, taskbar), working with windows (moving, sizing, minimise/maximise, restore, close, scrollbars, cascading), the toolbar, menus and right clicks, working with groups (programs, my documents, settings, control panel, printers), the desktop (my computer, the briefcase, network neighbourhood, recycle bin), help facilities, wordpad, explorer, organising files and folders (creating, deleting, copying & moving), formatting disks, find, shortcut methods, changing the start button, data integrity (scandisk, defrag), exiting Windows.
Desktop Publishing:
Microsoft Publisher
Publisher 98/2000 Introduction                                                                                          S01025
Overview, the Publisher screen, help facilities, starting a new publication, saving, closing, opening, design considerations and steps, margins, grids, column grids, horizontal grids, page set-up, adding/editing text, fonts, spacing, formatting text picture overview, characters, drawing tools, tabs, tables overview, creating/adding text to a table, printing.
Publisher 98/2000 Intermediate                                                                                         S01026
Text flow, picture revisited, picture frames revisited, adding/editing/positioning pictures, special characters, more drawing tools, more tables,changing/enhancing tables, wordart, bulleted lists, styles, backgrounds, spell checking, find and replace.
Publisher 98/2000 Advanced                                                                                              S01027
Graphic & typographic design techniuques, the psychology of visual comunication, how people perceive and evaluate what they see, getting your message across, reprduction considerations, liasing with your printing company, the design gallery, links with other applications,Publisher and the Web. General Computing Courses
Microsoft Outlook
Outlook 97 Introduction                                                                                                     S71028
Overview of Outlook 97, Composing and Sending messages, Working with messages, Message Options, Working with address books, Recalling and printing, Message handling options, Inserting text into a message, Creating Signatures, Scheduling appointments, Assigning categories, Editing appointments,Adding and editing contacts, Working with File Attachments.
Outlook 98 Introduction                                                                                                     S81029
Overview of Outlook 98, Overview of Outlook Today, Creating and sending messages, Acting on messages, Working with address books, Recalling and printing, Message handling options, Inserting text into a message, Creating Signatures, Creating and using personal folders, Using the Organise Page, Scheduling appointments, Assigning categories, Editing appointments, Inserting events, Creating and sending meeting requests, Working with meeting requests, Managing meeting responses, Managing tasks, Adding and editing contacts, More about File Attachments.
Outlook 2000/2002/2003 Introduction                                                                                 S01030
Overview of Outlook 2000, Composing and Sending messages, Working with messages, Working with Message Options, Working with address books, Recalling and printing, Message handling options, Inserting text into a message, Scheduling appointments, Editing appointments,Adding and editing contacts.
Outlook 2000/2002/2003 Intermediate                                                                                S01031
Refreshing Introductory skills, Overview of the Outlook 2000 expanded functions, Working with Categories, More about contacts, Using the Organise Page, Scheduling appointments, Assigning categories, Editing appointments, Inserting events, Creating and sending meeting requests, Working with the Task List.
Outlook 2000/2002/2003 Advanced                                                                                     S01031
Refreshing Intermediate skills, Creating and sending meeting requests, Working with meeting requests, Managing meeting responses, Managing tasks, Microsoft Exchange Server Options, Out of Office Rules, Out of Office Rules Wizard, Working with the Journal, Working with Notes, Working with Personal and Public Folders, Attaching and Inserting Outlook Objects
General Computing Courses
Microsoft Project 98
Project 98 Introduction                                                                                                      S81033
Fundamentals of project management & the Project 'Life-cycle', examining MS Project, overview of the planning process, defining project tasks & information, linking tasks and observing the critical path, modifying task relationships, constraints, organising the task list into an outline, viewing levels of detail, creating/assigning a base calendar, entering and assigning resources, working with project costs, resolving time restrictions/resource conflicts, exploring views, generating project reports, sorting/filtering project data, creating custom filters.
Project 98 Intermediate/Advanced                                                                                    S81034
Reviewing the project management process, creating a baseline plan, previewing a baseline report, modifying the environment for tracking, entering data for completed tasks, entering actual data for tasks in progress, adjusting the schedule of future tasks, setting/displaying an interim plan, working-hour considerations, customising resource reports, adding a sub project to a master project, working with multiple projects that share the same resource pool, importing/exporting data, working with views/toolbars and global settings.
Microsoft Project 2000
Project 2000 Introduction                                                                                                   S01035
Fundamentals of project management & the Project 'Life-cycle', examining MS Project, overview of the planning process, defining project tasks & information, linking tasks and observing the critical path, modifying task relationships, constraints, organising the task list into an outline, viewing levels of detail, creating/assigning a base calendar, entering and assigning resources, working with project costs, resolving time restrictions/resource conflicts, exploring views, generating project reports, sorting/filtering project data, creating custom filters.
Project 2000 Intermediate/Advanced                                                                                S01036
Reviewing the project management process, creating a baseline plan, previewing a baseline report, modifying the environment for tracking, entering data for completed tasks, entering actual data for tasks in progress, adjusting the schedule of future tasks, setting/displaying an interim plan, working-hour considerations, customising resource reports, adding a sub project to a master project, working with multiple projects that share the same resource pool, importing/exporting data, working with views/toolbars and global settings.
General Computing Courses
Adobe Acrobat v4.00 & v5.00
Adobe Acrobat: Portable Document Files                                                                         S11037
What is Adobe Acrobat? Which version does what? What is a pdf file? Why are they used? Versions how is a file converted to the pdf format? The adobe acrobat create dialog box, pdf distiller and writer, preparing word and excel files for conversion, avoiding the need to scroll in a pdf file, orientation of the original file, if the file still requires scrolling, inserting hyperlinks into an original file that still work in the pdf version, hyperlink "pros" and "cons", inserting hyperlinks into original files prior to conversion to the pdf format, differences in word and excel files, managing pdf documents, printing pdf documents, amending pdf documents, annotating pdf documents, inserting, extracting and deleting document pages.
Paint Shop Pro: Manipulating and Managing Images
Paint Shop Pro v6.0 & v7.0                                                                                                 S11038
What is Paint Shop Pro and what does it do? Tool Palettes and options, colours, palettes, colour specifications for RGB/HSL and hexadecimal Web Page use, colour depth and resolution, pixels and screen settings, changing image contrast, brightness and colours, special visual effects, image layers, cutting, copying and pasting images and layers, graphic file types, graphic file types and Web Page considerations, GIFs and JPGs, animating images and Web Sites, text and buttons, "vector" image, special effects, selecting parts of an image, rotating and "flipping" images.
Graphic Design:
Graphic Design in Information Technology                                                                         S11039
What is Graphic Design? Differences between Graphic Design on Paper and on the screen, the psychology of vision and perception, "I'm no designer, but I know what I like!", what factors influence Graphic Design? PC software packages that permit Graphic Design, am I likely to have those pages? Types of Graphic Design software packages, terminology, acquiring images, what are digital cameras and scanners? Colour depth and resolution, graphic file types, space and performance considerations for files containing graphics, reproducing your designs, Graphic Design and Internet Web Sites.
Digital Information Technology Equipment
Introduction to Digital Cameras and Scanners                                                                    S11040
What do I use Digital Cameras and Scanners for? How do Digital Cameras differ from regular Cameras? How good are the ones I got with my computer, basic photographic techniques and skills, how do I decide which equipment suits my needs? Digital cameras, Web Camera and videophone hardware and software, Scanner hardware and software, how do I install my equipment? How do I install my software? Do I always get everything I need when I buy my equipment, terminology, what is a USB port? What does TWAIN mean? Types of digital image files, colour depth and resolution, what are pixels? Converting images from one type to another, setting your scanner options, differences between B&W, colour and line drawings when setting scanner options, what does "dots per inch" mean? How do I select which "dots per inch" setting to use? How do I get my equipment to work with my software? Care and maintenance of your equipment.
Internet, Web Site Design and Email
Introduction to the Internet and Email including World Wide Web (WWW) Essentials
Introduction to the Internet and Email                                                                                 S11041/S11043
What is the Internet? A history of the Internet. What do I need to access the internet? Specification for PCs accessing the internet. How do I obtain the software package I need for Internet access. Terminology. What is a Web Browser? What is a Web Site? What is a Home Page? What is an Internet address? What does http:// mean? What is a domain and what does .co.uk and .com mean? What is email and how can I access that as well as a Web Site? What do organisations such as AOL do? How does my PC access the Internet and run my email? Who is handling my email messages? Deaning with incoming messages, message folders & organising your messages, deleting and moving your messages, composing & sending messages, attaching files to messages, saving files attahed to incoming message, sending messages with pictures.
Web Site Design
Introduction to Web Site Design                                                                                          S11043
Web Site structure and pre-requisites, why do I need a Web Site? Web Sites for commercial use, your Web Site as a part of your marketing strategy. What can I include in my Web Site? Overview to Text, Images, Tables and Files. What does a Web Site consist of? Terminology. What is HTML? What does http:// mean? What are Links? The five types of Links explained. What are Web Pages? The Web Site as an electronic book, deciding on the number of Web Pages in your Web Site, Web Site navigation and Links, inserting Web Page, background images, inserting images within Web Pages, manipulating images, choosing the appropriate image type, Web Page "anatomy", positioning Text and Images on Web Pages, using Tables to control the layout of your Web Pages, what is and is not possible on a Web Page, Web Page Graphic Design considerations, designing your Web Pages so as to present a coherent Web Site, using Web Page content to capture your visitor's interest, writing your own Web Page HTML code, using software to write code for you. Which package do I need to write HTML? Am I likely to already have that package? How do I view my pages when I design them? Which packages that I may already have can help me when designing my Web Pages? Are special Web Site design packages available? What are they and can I afford them and do I really need them? Testing my site, selecting an ISP, deciding on a domain name and type, checking already registered domain names, using a File Transfer Protocol package to publish your site and domain on your ISP's system, publicising your new site, maintaining your site, costs. What is a search engine and do I need to register with one? Internet, Web Site Design and Email
Third Party Web Site Design Application Courses
FrontPage 98 Introduction                                                                                                      S11044
What is possible & what is not, Viewing a completed Web Site, Using the FrontPage Explorer Using the FrontPage Editor, Web Page anatomy, Web Page Elements, Creating a Web Page, Applying a Theme, Formatting Text, Inserting Images, Overview of Page Navigation & Links, Types of Links, Creating Internal Links, Overview of Web Site Publishing.
FrontPage 98 Intermediate                                                                                                     S11045
More about Image, Background Images, page images, background colours, text attributes, Links revisited, testing & revising links, Text Link colours, using images as Link Objects, Image Maps, Creating a Navigation Bar, Adding Web Extras, Text Animations, Scrolling Text, Creating Tables, using Tables to control page text, Tables, Table Tag Attributes, Modifying the HTML code yourself.
FrontPage 98 Advanced                                                                                                         S11046
Tables Revisted, Drawing Tables, Working with Page Frames, Creating & Modifying Frames, Working with Forms, Forms, Search Forms, Assigning Web Tasks, Importing Data Working with Databases, Static & Dynamic Web Pages, Publishing your Web Site, Image Types, Colour Depth & Resolution, Hyperlink Images, Hotspots, Hover Functions, Rollover Images, Page Transition. Proprietary Web Site Design Application Courses
FrontPage 2000 Introduction                                                                                                  S11047
What is possible & what is not, Viewing a completed Web Site, Using the FrontPage Explorer Using the FrontPage Editor, Web Page anatomy, Web Page Elements, Creating a Web Page, Applying a Theme, Formatting Text, Inserting Images, Overview of Page Navigation & Links, Types of Links, Creating Internal Links, Overview of Web Site Publishing.
FrontPage 2000 Intermediate                                                                                                 S11048
More about Image, Background Images, page images, background colours, text attributes, Links revisited, testing & revising links, Text Link colours, using images as Link Objects, Image Maps, Creating a Navigation Bar, Adding Web Extras, Text Animations, Scrolling Text, Creating Tables, using Tables to control page text, Tables, Table Tag Attributes, Modifying the HTML code yourself.
FrontPage 2000 Advanced                                                                                                      S11049
Tables Revisted, Drawing Tables, Working with Page Frames, Creating & Modifying Frames, Working with Forms, Forms, Search Forms, Assigning Web Tasks, Importing Data Working with Databases, Static & Dynamic Web Pages, Publishing your Web Site, Image Types, Colour Depth & Resolution, Hyperlink Images, Hotspots, Hover Functions, Rollover Images, Page Transition.
Introduction to VBA Programming in Excel                                                                           SXVBA1
Course Introduction · Recording a New Macro · Editing and re-saving a recorded macro · Running a macro · Running Macros Automatically · Recording versus Writing a macro · Writing a macro · To write new procedures, we use the Microsoft Visual Basic editor. · Absolute and Relative Cell References · Absolute Cell Reference: Definition · Relative Cell Reference: Definition · Relative Cell Reference Macro · Summary of the differences between the Absolute & Relative macros · Practical Applications for Macros · 'What can macros do?' · 'Anything you want them to do!' · Using a macro to add records to a Data List · Navigation Keys · Alternative Method of Running a Macro · Inserting a Command Button, into a Worksheet, and assigning a macro to it. · Running the AddOrder Macro, using the Command Button · More Practical Applications for Macros · Setting Cell Formats, using a Macro · The Format Cells, Font Dialog Box · Tidying Things Up: With … End With and Line Continuation · With … End With · Line Continuation · The Line Continuation Characters · Exercise 9: Convert Formulas to Values & Line Continuation Usage · Making Decisions in Macros · Exercise 10: Cell Formats, Fill Colour · Excel ColorIndex Codes · If … Then · If … Then … Else · If … Then … ElseIf · Do … Loops · Do … Until · Useful Functions and other "good stuff" · MsgBox() function · InputBox() function · Toggle States · User Defined Functions · Calling Procedures · Objects, Properties, Methods and Collections · For … Next · Making the For … Next expression work harder · For … Next and Tables · Macros and the Personal.xls Workbook · Working with 'Global Macros' · Running 'Global Macros'
Introduction to Macros and VBA Programming in Access                                                     SAVBA1
Course Introduction · Course Prerequisites · Before We Start · When to Use VBA and When to Use Macros · Writing Macros · Where are Macros Written? · The Macro Object Design Window · Special Access Macros · The AutoExec Macro · Creating an AutoExec Macro: Overview · Testing Our First Macro: AutoExec · Overview of the Automation Process for our Database · Other methods of running Macros · Attaching Macros to Command Button Events · Applying the Attaching Macros method to the automation of our Database? · Attaching Macros to a range of Command Buttons designed to open All our Data Entry Forms · Definitive list of data entry Forms, within the sample Database: · Returning to frmWelcome from each of the Data Entry Forms · Using the same method for automatically running our Reports · Returning to the Reports Selector after opening and either viewing or printing a Report · Definitive list of Reports, within the sample Database: · Creating Command Buttons and Attaching Macros to their Events · Command Buttons and Macros on frmWelcome, which open each of our Data Entry Forms · Command Buttons and Macros on each of our Data Entry Forms which return us to frmWelcome · Creating a frmWelcome Command Button, Macro & Event: Overview · Creating a Command Button, Macro & Event to Return to frmWelcome: Overview · Converting Macros to VBA Code · The Macro Conversion Process · Class Object Modules and Standard Modules · The Anatomy of VBA Code · Function Procedures · Sub Procedures · Property Procedures · Functions Versus Sub Procedures · Variables · Constants · Scope · Dim · Procedures can contain: · Keywords (Starting and Ending the Procedure and setting Scope) · Declarations (Variables & Constants) · VBA Code Statements and Arguments · A First Real Look at VBA Macro Converted Code · A Detailed Analysis of the Keywords, and VBA Code in the mcrClose frmWelcome and Open frmJobs Data Entry Form Converted Macro · Where to next? · What is so important about Error Handling? · Error Trapping Code in a Converted Macro · Using and Modifying VBA Macro Converted Code in Event Procedures · Creating an 'On Click' Event Procedure, for attachment to a frmWelcome Command Button, to replace the existing Macro · Our first two 'On Click' Event Procedures, now replace our first two Macros · A reminder of the Event Procedures we have created · Customising Event Procedure Error Trapping · Message Boxes: MsgBox · Simulating two Errors, in order to modify existing or write customised Procedures with which to trap them. · Overview of Simulated Error #1: · MsgBox Error$ · Overview of Simulated Error #2: · Event Procedure Code for Trapping Error Codes 3022, 3058 & 0 · Using Procedures to Automate Reports · Automating the opening and closing of our first Report · Automating the other Reports · Automating Database Application closure · Appendix 1 · MS-Access Trappable MS-Jet Error References · Finding the Error Reference Screens, from the Help Menu · Trappable Microsoft Jet Errors : Complete Listing