An Introduction to Access, SQL and Visual Basic
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 introduces sets of SQL commands and VBA code within the Access framework within queries and form objects.
No previous knowledge of SQL or VBA is required, as all the necessary SQL and VBA code will be taught on these courses.
Participants must be familiar with Access basics - the creation, use, and modification of simple tables, queries, forms, and reports.
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
Statistical Database Functions: Dmax, Dmin.
VBA TOOLBOX TOOLS:
Text boxes, labels, command buttons, lists.
VBA OBJECT PROPERTIES:
Name, backcolor, font, height, width, top, left, control source, row source, columns, caption, text, visible.
VBA OBJECT EVENTS:
Click, Activate, Load, give/lose Focus, Mouse events.
Private Sub&End Sub; If&End If; With&End With
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:
Message & Input boxes; SetFocus; Open; Close; IsNumeric.
Program comments; Concatenation; Manipulating data collections and recordsets; Memory recordsets; Parameter queries; Calculated fields; lists and other options for automated data selection.
Tuition (includes tea/coffee): £176.50
Baguette lunch (both days): £9.80
Full lunch (both days): £28.00
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.
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