Access expert: project with VBA
Tackle an advanced computing project. Create and customise combo boxes, attach macros to the event property, and create and use variables in VB modules. Knowledge required: advanced Access course or equivalent knowledge and experience.
Key course information
Dates
19/02/12 - 26/02/12
Day(s)
Sun
Duration
2 weeks
Time
10:00 - 17:00
Fees
Full fee: £122
Senior fee: £75
Concession: £61
Venue
KS - Keeley Street
Course code
CDB07
Availability
This course has finished
This course has finished
Still got questions?
computing@citylit.ac.uk or call 020 7492 2515
Course outline
What is the course about?
This course focuses on advanced methods of data management through powerful Visual Basic for Applications (VBA) tools.
What topics will we cover?
Performing a mail merge to a selected customer.
Implementing a menu structure.
Creating and customising a combo box with and without using wizard.
Writing a macro.
Actions and methods.
Multiple actions.
Creating Visual Basic modules using a variety of commands.
Using variables in Visual Basic modules.
Form controls and properties.
Customised forms.
By the end of this course you should be able to:
Write programs to maximise Access functionality.
Write VBA programs.
Utilise advanced statements and macros to automate repetitive, tedious or complex tasks.
What level is the course and do I need any particular skills?
This course is suitable for people who would like to use VBA to enhance their usage of Access for more professional results. A thorough understanding of table design and field properties, forms and report design, advanced queries and basic macros is expected.
You should also be able to follow spoken and written instructions and be comfortable carrying out mathematical calculations.
How will I be taught, and will there be any work outside the class?
Each student has their own computer.
Presentations will be made using computers, interactive whiteboard, overhead screen and printed notes.
Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.
Do I need to have an interview before I can enrol?
No.
What feedback will I get?
You will receive regular feedback from your tutor throughout the course, as and when appropriate. At the end of the course you and your tutor are asked to assess the progress you have made.
How will I be able to give my views on the course?
Please complete the evaluation form at the end of your course. These are monitored and help us to continually improve our courses.
How do I find out if I can get some support for my learning?
You may be interested in: education and careers advice; financial and childcare support; disability support; support for Deaf and hearing-impaired students; dyslexia support; English and maths support; counselling, and library services (supported learning centre). To find out what may be available to you, and how to apply, see page 213 of the 11/12 course guide, or visit www.citylit.ac.uk/students
When I've finished, what course can I do next?
General information and advice on courses at City Lit is available from the Information and Advice Shop, open Monday to Friday 12:00 – 19:00 during term time, and Monday to Friday 12:00 – 17:00 out of term time. See the course guide for term dates and further details.
Who can I contact for further information?
Tel: 020 7492 2515
computing@citylit.ac.ukAdvice times:
Tuesday 17.30 - 18.30; Wednesday 12.30 - 13.30
You do not need to book an appointment, just come along on the days and at the times listed.
To enrol on a course, call 020 7831 7831.
Browse full range of courses
- Visual arts
- Art foundation and portfolio preparation courses
- Art history
- Basketry
- Bookbinding, paper, book arts and conservation
- Calligraphy
- Ceramics
- Design
- Digital arts and graphics
- Drawing
- Drawing and painting from life
- Fashion and textiles
- Jewellery
- Mosaics
- Offsite and studio development courses
- Painting
- Printmaking
- Sculpture
- View all in Visual arts
- Find out more about the Visual arts department
- Photography
- Beginners
- Computer based photography courses
- Documentary and photojournalism
- Exhibiting your photographs
- History, theory and talks about photography
- Lighting and studio techniques
- Photographing London
- Photography and contemporary art practice
- Portfolio and project creation
- Printing courses
- Taking photography further: computer-based
- Taking photography further: specialist
- The business of photography
- Traditional darkroom and techniques
- View all in Photography
- Find out more about the Photography department
- Languages
- Drama, dance and speech
- Accredited courses
- Acting - advanced
- Acting - follow-on
- Acting - introductory
- Arts administration
- Comedy
- Communication courses for speakers of other languages
- Communication skills for business
- Dance and movement
- Directing
- Drama teaching
- Drama therapy
- Follow on
- Internet broadcasting
- Musical theatre
- Performance skills
- Professional skills for actors
- Professional theatre company
- Stage combat
- Technical theatre
- TV, radio and sound
- Voice, speech and communication
- View all in Drama, dance and speech
- Find out more about the Drama, dance and speech department
- Humanities
- Anthropology
- Business and economics
- Communications and study skills
- Creative writing
- English
- English for speakers of other languages
- Film
- History and politics
- Journalism
- Latin America
- Literature
- London walks
- Philosophy
- Public relations
- Religious studies
- Science
- View all in Humanities
- Find out more about the Humanities department
- Music
- Cello
- Clarinet
- Classical guitar
- Flute
- Instrument playing
- Instrumental
- Instrumental ensembles
- Jazz and popular music
- Music access course
- Music appreciation
- Music foundation
- Music technology
- Musicianship
- Piano and keyboards
- Record your performance
- Recorder
- Singing
- String ensembles
- Ukelele
- Violin
- View all in Music
- Find out more about the Music department
- Health and movement studies
- Alexander technique
- Anatomy and physiology
- Complementary health studies
- Continuing professional development for therapists
- Energy and healing
- Fitness
- Fitness workouts
- Health and fitness teacher training
- ITEC Unit 349 business practise for complementary therapists
- ITEC Unit/s 345/343 reflective practise for aromatherapy/reflexology
- Lifestyle, energy and health
- Massage and bodywork: introductory level
- Massage and bodywork: professional practitioner level
- Massage: professional level
- Meditation and stress management
- Movement classes
- Nutrition and food safety
- Professional development for movement instructors
- Self-defence
- Yoga
- View all in Health and movement studies
- Find out more about the Health and movement studies department
- Computing
- Apple Mac
- Basic computing
- Computerised accounts and bookkeeping
- Courses leading to a qualification
- Design and illustration
- Desktop publishing
- Digital Inclusion
- Explore your interests using a computer
- Keyboard skills
- Microsoft Office 2007 applications
- Programming
- Technical computing
- Web page design
- Windows and file management
- View all in Computing
- Find out more about the Computing department
- Psychology, counselling & personal development
- English, maths & ESOL
- Deaf education
- Careers in care work
- Access to higher education
- Progress - courses for people with learning difficulties
- Speech therapy
- Teacher & management training
Contact us
Computing
Tel: 020 7492 2515
Advice times:
Tuesday 17.30 - 18.30; Wednesday 12.30 - 13.30
You do not need to book an appointment, just come along on the days and at the times listed.
To enrol on a course, call 020 7831 7831.
Computing
City Lit’s wide range of part-time, evening and weekend computer courses range from beginner level to advanced qualifications, covering the major Microsoft Office applications, desktop publishing, web design, multimedia packages and programming
