Log in |

Courses

Find courses

 

search box divider
You may also select one or more course types to refine your search:
icon representing day and weekend events Day & weekend events
icon representing weekly classes Weekly classes
icon representing online courses Online courses
icon representing professional development courses Professional development
icon representing Oxford qualifications Oxford qualifications
icon representing summer schools Summer schools
Filter results to only show:
Courses outside Oxford
Courses I can enrol on now
heading icon

Search results - Introducing Relational Databases - with Access, SQL and Visual Basic

Key facts

TypeDay and Weekend
LocationOxford
AddressRewley House
1 Wellington Square
Oxford OX1 2JA
DatesSat 24 to Sun 25 Nov 2012
Day: Week End
Time of meeting: 10am - 5.30pm Sat & Sun
Number of meetings: 2
Subject area(s)Computing
FeesFrom £160.00
Application statusCourse cancelled
Course codeO12P209COR
Course contactIf you have any questions about this course, please email ppdayweek@conted.ox.ac.uk.

Overview

Microsoft Access is a powerful relational database management system which allows database tables to be linked together through common fields. This eases data sharing and management, and minimises data duplication. This course introduces relationships - why they are needed and how they are designed and created - and develops techniques required for relational design. These techniques include developing suitable user interfaces and Access programming. Access contains two programming languages - Visual Basic for Applications (VBA) and Structured Query Language (SQL). SQL's commands query data whilst VBA is used for macro and module programming; both enhance forms and reports. Combining VBA and SQL is the most efficient way to write Access programs.

Participants are expected to be familiar with the basics of Access - the creation, use, and modification of simple tables, queries, forms, and reports. No previous experience of either relational techniques or of VBA/SQL programming is assumed or required.

Maximum: 16 students.
To top/display all

Programme details

SATURDAY 24 – SUNDAY 25 NOVEMBER 2012

(For both days)

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
To top/display all

Staff

Dr Robert Lockhart

Role: Tutor


Ms Judith A Harley

Role: Speaker

JUDITH HARLEY, MA, is a physics graduate and freelance computer consultant who advises on, and designs, commercial and private database,...more

To top/display all

Recommended reading

BACKGROUND READING

1. Access Programming For Windows For Dummies by Rob Krumm
2. QUE’s Special Edition Using Access by Roger Jennings

To top/display all

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 01865 270362 for details of availability and prices.

Accommodation in Rewley House is in modern, comfortably furnished rooms, all with tea/coffee making facilities, TV, telephone and private bath or shower rooms.

To top/display all

Fee options

Programme Fee
Tuition fee: £160.00
Catering
Baguette lunches (Sat and Sun): £7.00
To top/display all

Apply for this course

Sorry, this course is not currently accepting applications. If you have any questions about this course, please use the course enquiry form.

To top/display all