Search results - Using SQL to Analyse Access Data I
|Type||Day and Weekend|
1 Wellington Square
|Dates||Sat 23 to Sun 24 Mar 2013|
Day: Week End
Time of meeting: 10.00am - 5.30pm Sat & Sun
Number of meetings: 2
|Application status||Course ended|
|Course contact||If you have any questions about this course, please email firstname.lastname@example.org.|
OverviewPart 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.
(same for both days)
Saturday 23 - Sunday 24 March 2013
10.00am Session 1
11.30am Session 2
2.00pm Session 3
4.00pm Session 4
5.30pm Course disperses
Dr Robert Lockhart
Role: Director of Studies
Ms Judith A Harley
is a physics graduate and freelance computer consultant who advises on, and designs, commercial and private database, spreadsheets, and Visual Basic...more
Recommended reading1. 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
AccommodationAccommodation 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.
- Programme Fee
- Tuition (includes coffee/tea): £160.00
- Baguette (Sat & Sun): £7.00
- Full Lunch (Sat & Sun): £22.00