SQL and VBA Training Courses

SQL (Structured Query Language) is a specialised language designed for managing data in relational databases by accessing and manipulating information. SQL is an ANSI and ISO standard, and is the de facto standard database query language. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server. It is widely used in both industry and academia, often for large, complex databases.

This tool enables users to:

• Create new databases.
• Create new tables in a database.
• Execute queries against a database.
• Retrieve data from a database.
• Insert, update and delete records in a database.
• Create stored procedures in a database.
• Create views in a database.
• Set permissions on tables, procedures, and views.

Our SQL Training Courses

Foundation SQL training course - While no prior knowledge of SQL is required to attend this SQL Foundation Course, knowledge of database design techniques would be an advantage. The SQL training course primarily uses the SQL 2003 ANSI/OSI standard so the techniques learnt can be applied to any number of databases, including SQL Server, Oracle, Access and MySQL.

View our SQL Foundation course here

VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. As its name suggests, VBA is closely related to the programming language Visual Basic but can normally only run code within a host application (e.g. Excel, Access, etc.) rather than as a standalone application. VBA can be used in the major Microsoft Office programmes, and is most frequently used to control functionality and automate repetitive tasks in Excel, Access and Project by means of macros (which are also known in VBA as procedures).

Examples of tasks that could be carried out using VBA are:

• Automating report generation and chart creation in Microsoft Excel.
• Performing data processing in Microsoft Excel.
• Automating Microsoft Access forms, reports and applications.
• Automating communication between Microsoft Excel and databases.
• Automating communication between Microsoft applications.
• Building professional- looking wizards (i.e. floating dialog boxes) quickly.
• Performing analysis tasks in Microsoft Excel, e.g. modelling, optimization, etc.

Our VBA Training Courses

We offer five VBA courses in the use of the tool:

VBA in Excel - Part 1. This course is an introduction to Visual Basic programming in Excel and looks at structures, syntax and coding standards. While previous programming experience would be an advantage, it is not essential. Delegates attending the VBA in Excel – Part 1 course must be confident creating and manipulating Microsoft Excel spreadsheets and creating formulas, as well as in recording and running macros.

VBA in Excel Part 2 - Spreadsheet Developer. This course follows on from the VBA in Excel – Part 1 course and is designed for those who are already creating VBA code and who now need to learn more about what is available and how to use it to create automated solutions. Delegates will learn how to: use arrays to store and re-use data; use objects within the Excel data model to manipulate information; write file search routines; and create functions and complex user forms.

VBA in Excel Part 3 - Application Integration. This course is aimed at those who are already creating VBA code and who now need to learn more about how to pass information between the different applications and create integrated solutions. The course covers: connecting to other applications; using the other applications' object models; and passing data to and from Word, PowerPoint, Outlook and Access.

Microsoft Access Developer, VBA in Access Part 1 - Automation. This course enables existing experienced users of Access to use VBA to automate their databases. The VBA in Access Part 1 course covers: writing code for use on command buttons, forms and reports; setting up user messages; using the debug tools; writing error handling routines and editing Access error messages; and writing functions.

Microsoft Access Developer, VBA in Access Part 2 - Access Objects and DAO.  Following on from the VBA in Access Part 1, this course is designed for existing experienced users of Access. Delegates will learn to use the Access Object Model, use the DAO (Data Access Object Model), and transfer information to Word and Excel.

View our VBA courses here