An Introduction to Access, SQL and Visual Basic

Course summary

An Introduction to Access, SQL and Visual Basic



Overview

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.

Programme details

Programme Timing

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.

Topics


SQL KEYWORDS: 
SELECT, FROM, WHERE, ORDER BY, DISTINCT, AND, OR, INTO

SQL FUNCTIONS: 
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.

PROGRAMMING STRUCTURES:
Private Sub&End Sub; If&End If; With&End With

PROGRAMMING CONCEPTS:
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.

MISCELLANEOUS:
Program comments; Concatenation; Manipulating data collections and recordsets; Memory recordsets; Parameter queries; Calculated fields; lists and other options for automated data selection.

Fees

Tuition (includes tea/coffee): £176.50
Baguette lunch (both days): £9.80
Full lunch (both days): £28.00

Tutors

Ms Judith A Harley

Tutor

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.

Cezar Ionescu

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.

Application

Please use the 'Book' or 'Apply' button on this page. Alternatively, please contact us to obtain an application form.