Key facts

Type	Day and Weekend
Location	Oxford
Address	Rewley House 1 Wellington Square OX1 2JA
Dates	Sat 23 to Sun 24 Mar 2013 Day: Week End Time of meeting: 10.00am - 5.30pm Sat & Sun Number of meetings: 2
Subject area(s)	Computing
Fees	From £160.00
Application status	Course ended
Course code	O12P211COR
Course contact	If you have any questions about this course, please email ppdayweek@conted.ox.ac.uk.

Overview

Part one of two linked weekends - second weekend 18-19 May 2013.

SQL is a specific query language with commands designed for interrogating data. It is a standard query language for Microsoft Access and many other database packages. The course concentrates on developing efficient, well-defined sets of SQL commands. Topics:

SQL keywords - SELECT, FROM, WHERE, ORDER BY, DISTINCT, AND, OR, INTO, UPDATE.
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, combos, lists, check boxes, option groups, calendar
VBA Object properties - Name, control source, row source, columns, column width, bound column, caption, text, enabled, visibles.
VBA Object events - AfterUpdate, Click, Activate, Load, give/lose focus, NotInList
Programming structures - Private Sub…End Sub; If…End If; Do…Loop; For…Next; With…End With
Programming concepts - Working with objects; Object-event driven code; Defining and using memory variables; Scope of memory variables; Manipulating numbers, dates, and text
Functions and methods - ARequery, Dropdown, Refresh; Message & Input boxes; Setfocus.
Miscellaneous - Concatenation; Manipulating data collections and recordsets; Memory recordsets; Parameter queries; Calculated fields; Standard and self-referencing combos, lists, options, and calendars for automated data selection.

Programme details

Programme
(same for both days)

Saturday 23 - Sunday 24 March 2013

9.45am Registration

10.00am Session 1

11.00am Coffee/tea

11.30am Session 2

1.00pm Lunch

2.00pm Session 3

3.30pm Tea/coffee

4.00pm Session 4

5.30pm Course disperses

Staff

Recommended reading

1. Access for Dummies – this covers the basic features of Access; students need to be familiar with most of these before attending either course
2. Access Programming For Windows For Dummies

Accommodation

Accommodation is often available in Rewley House for those who wish to stay on the night before a course. Please contact our Residential Centre on 01865 270362 for details of availability and prices.

Fee options

Programme Fee

Tuition (includes coffee/tea): £160.00

Catering

Baguette (Sat & Sun): £7.00

Full Lunch (Sat & Sun): £22.00

Apply for this course