Microsoft Access Programming (2 days – £1,190, plus VAT)

    G Com Solutions Limited deliver onsite Microsoft Access Programming all over the UK. We customize our Microsoft Access Programming to match our client’s specific requirements. If you are looking to extend your knowledge of Microsoft Access, then this may be just the course you are looking for.

    Access is much more than a way to create desktop databases. It’s an easy-to-use tool for creating applications that help you run your business.

    Microsoft Access Programming

    Microsoft Access Programming Outline

    Our Access programming course concentrates on the creation of modules. It shows users how to use Visual Basic for Applications (VBA) to control and manipulate the objects and data in their database solutions. This course is designed for experienced Access users wishing to use VBA for database application development.

    The Visual Basic Editor

    Using the Project Explorer window, Using the code window, The Property window, Using the Immediate window , Setting user options

    VBA Fundamentals

    Benefits of VBA, Modules and procedures, Standard modules and form modules, Understanding Access objects, Using the Object Explorer, Understanding object properties, Understanding object methods

    VBA Programming

    Creating sub procedures, Defining variables, VBA data types, Conditional statements, Using If statements, Using Select Case statements, Looping structures, Using For Next loops, Using While Wend loops, Calling a subroutine, Supplying parameters, Calling a funciton and supplying parameters, Returning a value

    Objects and collections

    Setting properties, Creating command buttons, Using ActiveX controls, Pop-up forms, Manipulating objects, Properties and methods, Manipulating collections, Using object variables, Understanding events

    Programming forms

    The Forms collection, The Me keyword, Opening and closing forms, The form module, Form and control properties, Form events, Selection controls, Populating a list control, Working with option groups

    Programming reports

    An introduction to the report module and events, Opening and closing reports, Passing arguments Using OpenArgs, Populating the report, Handling report-level errors, Working with subreports

    Error handling

    Overview of error handling, Errors in design/logic, Compile errors, Run-time errors, Getting feedback on errors, Replacing standard error messages

    Debugging

    Stepping through code, Using breakpoints, Stepping through procedures, Examining variables

    Microsoft Access Programming Locations

    We can deliver training on Microsoft Office at your offices, anywhere in the UK, or at our training centre in Peterborough:
    Pinnacle House, 4-5 Newark Rd, Peterborough PE1 5YD