ACC-H

Microsoft Access programming skills

Microsoft Access courses third level
Form of participation
Form of training
Length of training
  • 3 day (3×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Trainer recommendation

Endrődi Tamás

Endrődi Tamás trainer

MS Access-based software is often looked down upon by Java and C# programmers, but business users with limited IT knowledge can still create small applications. These can be a great help in replacing Excel-based records that were popular in the past century. Modern Access applications are now linked to SQL Server databases and appear in many areas of business. Personally, I haven’t been working with Access software for too long—only 27 years. Over this time, I’ve built systems for commercial and goods trading, as well as education management, pharmaceutical, and waste management systems. In fact, my cattle reproduction management system also runs on Access.

Suggested For

The course is designed for students with advanced MS Access skills who want to take advantage of the programming possibilities in MS Access and develop more complex, interactive applications. The course assumes a basic level of programming knowledge, and the necessary Visual Basic programming skills will be covered in the course.

Outline

MS Access application design, steps

  • databases / application location
  • defining transactions
  • define functional specification
  • standard user interface design, design
  • programming, refinement, testing

Use of macros

  • creating, writing and customising key handling macros
  • automations

Overview of the VBA environment

  • VBA interface, menus, tools

Visual Basic basics

  • operations with variables, variable and data types, operators
  • statements, conditional statements
  • user event handling, data validation
  • loop organization
  • using functions, writing custom functions
  • writing and calling procedures
  • debugging, repair procedures and tools
  • ADO (ActiveX Data Object) record management
  • writing queries, table operations

User interface design and development

  • integration, customisation and parameterisation of buttons, menus, toolbars
  • user interactivity management
  • managing, customising and programming forms
  • exception and error handling, data validation
  • linking databases, programming for user interfaces

XML technology basics, XML data management in MS Access

Program refinement and completion, testing, debugging

Designing and building complex applications

Outline (PDF)

Prerequisites

Completion of or knowledge of the basics of Database Management in Microsoft Access, Building Access-based Applications - Creating Forms and Reports and Programming Excel in Visual Basic.