This VBA course is designed for anyone who uses Microsoft Access and wants to discover more than the basic capabilities of Microsoft Access and connect it to other applications.
No starting dates
-
Starting date to be confirmed
- Duration: 10 weeks (unconfirmed)
- Fees: £490 (unconfirmed)
- Location: Online (unconfirmed)
Microsoft Access VBA Programming Course overview
This fully hands-on Access VBA training course provides hundreds of example programs that you can modify and deploy in your own database work.
The course covers the three available object models (Access objects, DAO and ADO), explains the differences between them and how to use them confidently.
The course concludes with examples of how to extend Access to interact with the other Microsoft applications such as Excel, Word and Outlook.
Who is it for?
The Microsoft Access VBA programming short course teaches in-depth Microsoft Access VBA programming techniques that enable the developer to go beyond capabilities offered by basic Access usage and smooth out the rough edges that Access leaves behind.
Find out more about our Computer science and computing courses
Timetable
This practical short course takes the form of a series of evening classes taking place once a week.
City Short Courses follow the academic year, delivering courses over three terms. These include:
- Autumn - October
- Spring - January
- Summer - April
Benefits
- Delivered by an industry professional
- Taught in small groups
- Awarded a City, University of London certificate
What will I learn?
- Introduction and overview:
- The Visual Basic Editor
- Standard modules and class modules
- attaching buttons to forms and writing VBA procedures and functions
- Code generated by Command Button wizards
- Error handling code
- Debugging your programs by stepping through code and using the Immediate window.
- VBA:
- Basic programming with variables and data types
- If statements,
- VBA's inbuilt functions.
- Use Access objects to write programs to control Forms and Reports
- Transferring data to and from Excel and other databases
- Importing text files
- Placing advanced controls on Forms (subforms, combo boxes, toggle buttons, list boxes) and creating programs for their events
- An introduction to Access SQL:
- Select statements; Group By clauses
- Update, Insert and Delete statements
- Joins and Union queries.
- The three types of loop that are used to make programs repeat commands (Do loops, For loops, For Each loops)
- Programming the DAO (Data Access Objects), the object model that is intrinsic to Access, with an emphasis on Recordsets (programs that enable you to work with your data):
- Connecting to other databases
- Container objects.
- Programming the ADO (Active X Data Objects), a component of Microsoft's universal data access strategy, including ADO recordsets
- Connecting Access to other applications in both directions using OLE Automation and ADO, for example create an Excel chart from Access data.
Assessment and certificates
Teaching takes the form of theoretical explanation and pre-supplied programs to demonstrate the implementation of the theory. Short exercises take place in order to reinforce the your grasp of a topic.
The tutor is happy to answer questions and follow up your particular needs and interests where possible.
The short course assumes prior knowledge of Access and VBA, but revision materials are provided for you to follow up offline.
Eligibility
Working knowledge of MS Access; basic programming as taught in VBA in Excel.
English requirements
You will need a good level of spoken and written English to enrol on this course.