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