Microsoft Access Programming

    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

    The fee for running in-house Microsoft Access courses in Colchester is £795, per day.
    The cost for running customized Microsoft Access courses in Luton is £795, per day.
    Our fee for delivering customized Microsoft Access training in Tyneside is £795, per day.
    The charge for running customized Microsoft Access training in Liverpool is £795, per day.
    Our price for delivering on-site Microsoft Access courses in Medway Towns is £795, per day.
    The fee for running customized Microsoft Access training in Doncaster is £795, per day.
    The fee for running customized Microsoft Access training in Exeter is £795, per day.
    Our charge for delivering on-site Microsoft Access courses in Farnborough/Aldershot is £795, per day.
    The charge for running customized Microsoft Access training in Greater Manchester is £795, per day.
    Our charge for delivering Microsoft Access courses in Chesterfield is £795, per day.
    Our price for supplying on-site Microsoft Access courses in Reading is £795, per day.
    Our price for delivering on-site Microsoft Access courses in Blackpool is £795, per day.
    Our fee for delivering in-house Microsoft Access courses in High Wycombe is £795, per day.
    The charge for running Microsoft Access courses in Chelmsford is £795, per day.
    The fee for running on-site Microsoft Access training in Edinburgh is £895, per day.
    Our price for delivering in-house Microsoft Access courses in Oxford is £795, per day.
    Our price for running on-site Microsoft Access training in The West Midlands is £695, per day.
    The fee for running on-site Microsoft Access training in Telford is £695, per day.
    The cost of supplying on-site Microsoft Access courses in Accrington/Rossendale is £795, per day.
    Our charge for supplying Microsoft Access courses in Sunderland is £795, per day.
    Our price for supplying in-house Microsoft Access courses in Derby is £695, per day.
    Our price for delivering customized Microsoft Access courses in Basingstoke is £795, per day.
    Our price for delivering customized Microsoft Access courses in Eastbourne is £795, per day.
    Our fee for delivering on-site Microsoft Access training in Northampton is £795, per day.
    The fee for running customized Microsoft Access training in Ireland is £895, per day.
    The charge for running in-house Microsoft Access courses in Preston is £795, per day.
    Our price for running Microsoft Access courses in Sheffield is £795, per day.
    Our price for running customized Microsoft Access training in Plymouth is £795, per day.
    Our price for supplying in-house Microsoft Access courses in Slough is £795, per day.
    Our charge for supplying on-site Microsoft Access training in Newport is £795, per day.
    The fee for running customized Microsoft Access courses in Torquay is £795, per day.
    Our price for delivering customized Microsoft Access courses in Burnley is £795, per day.
    Our fee for delivering customized Microsoft Access courses in Ipswich is £795, per day.
    The fee for running on-site Microsoft Access training in West Yorkshire is £695, per day.
    Our price for supplying Microsoft Access courses in Dundee is £895, per day.
    Our fee for delivering customized Microsoft Access courses in Cardiff is £795, per day.
    Our fee for delivering Microsoft Access courses in Bristol is £795, per day.
    The fee for running customized Microsoft Access training in Norwich is £695, per day.
    Our charge for supplying on-site Microsoft Access courses in Birkenhead is £795, per day.
    Our charge for delivering customized Microsoft Access courses in Coventry is £695, per day.
    Our fee for delivering on-site Microsoft Access courses in Warrington is £795, per day.
    Our price for delivering in-house Microsoft Access courses in Mansfield is £795, per day.
    The fee for running on-site Microsoft Access courses in Greater Glasgow is £895, per day.
    The charge for running customized Microsoft Access courses in Lincoln is £695, per day.
    Our charge for delivering customized Microsoft Access training in Wigan is £795, per day.
    The cost for running in-house Microsoft Access courses in Poole is £795, per day.
    The fee for running on-site Microsoft Access courses in Worcester is £795, per day.
    The charge for running customized Microsoft Access courses in Stoke-on-Trent is £695, per day.
    Our charge for supplying on-site Microsoft Access courses in Maidstone is £795, per day.
    Our price for running customized Microsoft Access training in Nottingham is £695, per day.
    Our price for supplying Microsoft Access courses in Basildon is £795, per day.
    The cost for running customized Microsoft Access courses in Hastings is £795, per day.
    Our charge for delivering customized Microsoft Access courses in Swindon is £795, per day.
    Our price for delivering customized Microsoft Access training in Brighton and Hove is £795, per day.
    The cost of supplying Microsoft Access courses in Cheltenham is £795, per day.
    Our price for running on-site Microsoft Access courses in Teesside is £795, per day.
    Our price for supplying customized Microsoft Access training in Cambridge is £695, per day.
    The charge for running customized Microsoft Access courses in Thanet is £795, per day.
    The charge for running customized Microsoft Access courses in Birmingham is £695, per day.
    The cost of supplying on-site Microsoft Access courses in Grimsby is £795, per day.
    The cost of supplying on-site Microsoft Access courses in Burton-upon-Trent is £795, per day.
    Our price for supplying on-site Microsoft Access courses in Greater London is £795, per day.
    The cost of supplying customized Microsoft Access courses in Crawley is £795, per day.
    The fee for running in-house Microsoft Access courses in York is £795, per day.
    Our charge for supplying customized Microsoft Access training in Leicester is £695, per day.
    Our fee for delivering customized Microsoft Access training in Southend-on-Sea is £795, per day.
    The cost of supplying in-house Microsoft Access courses in South Hampshire is £795, per day.
    The cost for running customized Microsoft Access training in Bedford is £795, per day.
    Our fee for delivering Microsoft Access courses in Barnsley is £795, per day.
    Our price for delivering in-house Microsoft Access courses in Blackburn is £795, per day.
    Our price for running Microsoft Access courses in Gloucester is £795, per day.
    Our charge for supplying customized Microsoft Access training in Bournemouth is £795, per day.
    Our price for supplying customized Microsoft Access training in Aberdeen is £895, per day.
    The fee for running on-site Microsoft Access courses in Peterborough is £695, per day.
    Our price for running customized Microsoft Access courses in Milton Keynes is £695, per day.
    The cost for running customized Microsoft Access courses in Kingston upon Hull is £795, per day.
    Our price for running Microsoft Access courses in Swansea is £795, per day.
    Our charge for supplying on-site Microsoft Access training in Belfast is £895, per day.