Taking Access, SQL and Visual Basic Further

Course details

Code
O19P206COR
Fees
From £182.00

Dates
Sat 04 Apr 2020 - Sun 05 Apr 2020
Time
09.45 - 5.30

Taking Access, SQL and Visual Basic Further

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 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.

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), UPDATE, APPEND.

SQL CONCEPTS:
Linking data: Equi-joins; Left, Right, Inner, and Outer joins.

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

PROGRAMMING STRUCTURES:
(Private Sub&End Sub; If&End If; With&End With), Do&Loop; For&Next;

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:
Requery, Dropdown, Refresh; (Message & Input boxes); IsDate.

MISCELLANEOUS:
(Concatenation; Manipulating data collections and recordsets; Memory recordsets; Parameter queries); Calculated fields; Combos, lists, and options for automated data selection.

Accommodation

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 res-ctr@conted.ox.ac.uk 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.

Fees

Tuition (includes coffee/tea): £182.00
Baguette lunch (both days): £10.00

Funding

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.

Concessionary fees for short courses

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.

Dr Cezar Ionescu

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.

Application

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