Taking Access, SQL and Visual Basic Further
Microsoft Access is a powerful Relational Database Management System containing two programming languages - Visual Basic for Applications (VBA) and Structured Query Language (SQL).
SQL is a specific query language with commands designed for interrogating - or querying data, and is a standard query language for many other database packages.
Whilst SQL is a potent software tool for managing data, VBA provides a broad range of commands for enhancing data control. Combining SQL with VBA is most efficient and effective in programming within Access.
This course builds on an earlier course, 'Access, SQL and Visual Basic: An Introduction' and delves into further levels of SQL and Visual Basic programming.
It concentrates on creating and developing efficient, well-defined sets of SQL commands and Visual Basic code within Access queries, forms and reports.
Participants must be familiar with the SQL and VBA content covered in the earlier Introduction course, and with Access basics - the creation, use, and modification of simple tables, queries, forms, and reports.
There is no requirement to have attended the introductory course on either 26-27 October 2019 or 7-8 March 2020, but as this ‘Further’ course builds on the earlier introductory material, participants will be expected to have a good understanding of topics covered in the earlier course.
This course is one of a series of Access weekends held throughout the year.
9.45am Registration (Sat)
10.00am - 5.30pm (same for both days)
4 teaching sessions per day with breaks at 11.00am and 3.30pm for coffee / tea. Lunch at 1.00pm.
(SELECT, FROM, WHERE, ORDER BY, DISTINCT, AND, OR, INTO), UPDATE, APPEND.
Linking data: Equi-joins; Left, Right, Inner, and Outer joins.
Statistical Database Functions: DLookup, Dsum, Dcount, (Dmax, Dmin).
VBA TOOLBOX TOOLS:
(Text boxes, labels, command buttons), lists, combos, check boxes, option groups, calendar.
VBA OBJECT PROPERTIES:
(Name, caption, text, visible), control source, row source, columns, column width, bound column, enabled.
VBA OBJECT EVENTS:
(Click, Activate, Load), AfterUpdate, NotInList.
(Private Sub&End Sub; If&End If; With&End With), Do&Loop; For&Next;
Working with objects; Object-event driven code; Defining and using memory variables; Scope of memory variables; Manipulating numbers, dates, text, and Boolean values; the Me! Object; Access and VBA Built-in Constants.
FUNCTIONS AND METHODS:
Requery, Dropdown, Refresh; (Message & Input boxes); IsDate.
(Concatenation; Manipulating data collections and recordsets; Memory recordsets; Parameter queries); Calculated fields; Combos, lists, and options for automated data selection.
Accommodation is not included in the price, but depending on availability, it may be possible to stay at Rewley House on Friday and / or Saturday night. Please contact our Residential Centre on +44 (0) 1865 270362 or email firstname.lastname@example.org for details of availability and discounted prices.
Accommodation in Rewley House - all bedrooms are modern, comfortably furnished and each room has tea and coffee making facilities, Freeview television, and Free WiFi and private bath or shower rooms.
Tuition (includes coffee/tea): £182.00
Baguette lunch (both days): £10.00
If you are in receipt of a state benefit you may be eligible for a reduction of 50% of tuition fees.
If you do not qualify for the concessionary fee but are experiencing financial hardship, you may still be eligible for financial assistance.
Judith Harley, MA, is a physics graduate and freelance computer consultant who advises on, and designs, commercial and private database, spreadsheet, and Visual Basic applications. She has taught computing courses at Oxford University for over 20 years.
Director of Studies
Dr Cezar Ionescu is Associate Professor of Data Science with the Oxford University Department for Continuing Education. His main interests include functional programming, correctness of scientific computing and machine learning algorithms, and the role of computing science in education.
Please use the 'Book' or 'Apply' button on this page. Alternatively, please contact us to obtain an application form.
Terms and conditions
Terms and conditions for applicants and students on this course
Sources of funding
Information on financial support