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.
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.
Using the Project Explorer window, Using the code window, The Property window, Using the Immediate window , Setting user options
Benefits of VBA, Modules and procedures, Standard modules and form modules, Understanding Access objects, Using the Object Explorer, Understanding object properties, Understanding object methods
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
Setting properties, Creating command buttons, Using ActiveX controls, Pop-up forms, Manipulating objects, Properties and methods, Manipulating collections, Using object variables, Understanding events
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
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
Overview of error handling, Errors in design/logic, Compile errors, Run-time errors, Getting feedback on errors, Replacing standard error messages
Stepping through code, Using breakpoints, Stepping through procedures, Examining variables
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