BE Banner
Business Enterprise Header Image

Intensive Computer Training

Looking to update your Computer skills?

Image of a man and woman working at a computerIntensive Computer training at the College offers high quality and professional value-for-money IT training. 1 and 2 day intensive courses aim to bring you up to speed with the latest Microsoft software applications such as Word, Excel, Access, Project and PowerPoint, as well as Macromedia applications, such as Dreamweaver.

Bespoke, tailor-made courses are also available for individuals on a one-to-one basis, or for organisations, as well as exclusive courses for the employees of a single company. Courses can be held at our modern computer suite based at the Lansdowne IT zone, or another location to suit you. Please contact us for more information on these options.

Contact Us
To find out more information about any of our courses please contact us on 01202 205799 or e-mail us at intensiveIT@bpc.ac.uk.
To book a place you can either phone or e-mail.
Search Courses | Print Course Datasheet | Email This Course

Access Advanced - Intensive


Related Courses:
Access Intermediate - Intensive
College Certificate | Short
Access Introduction - Intensive
College Certificate | Roll-on Roll-off

Course Code: TFLXPZ5073

Course Venue & Start Date:

Duration: 1 Day, Short

Start Day/Time: Tuesday 9.30am - 4.30pm

Qualification: College Certificate

Awarded by: Bournemouth & Poole College

Introduction:
This one day course is designed to give existing Access users additional skills on using the more advanced features and functions as well as maximising the effectiveness of this computer software.

Entry Requirements:
It is recommended that students have a good working knowledge of Access, i.e. have attended the Intermediate level course or have achieved Module 5 (Databases) of the European Computer Driving Licence (ECDL) or Access Core level Microsoft Office Specialist qualification.

Course Details:
You will review Access Database Principles

Performance and Design

  • Normalisation of data
  • Primary and secondary keys

Macros

  • Creating macros
  • Adding macros to command buttons
  • Event driven macros
  • Attaching macros to a form or report event

Forms

  • Advanced form features
  • Bound and unbound controls
  • Switchboard forms
  • Adding graphics to a form

Reports

  • Grouping data in reports
  • Creating calculations in reports
  • Adding graphics

Analysing Access Data in Excel

  • Embedding pivot tables and charts in Access

Designing a Database Application

  • Creating custom menus and toolbars
  • Attaching a custom menu/toolbars to a form
  • Menu form properties
  • Setting start up defaults

Database Documentation, Access and Internet

  • Using hyperlinks
  • Exporting datasheet views to HTML
  • Data Access pages

Course Assessment:
Progress monitoring is informal with continuous assessment throughout the day.

Course Progression:
On successful completion of the Advanced Microsoft Access Intensive you should be proficient in using the Access database package, and could progress onto another intensive short course at The College.

Specialist Resources:
This course is run by IT professionals in The College's IT Learning Zone at The Lansdowne campus or at a venue to suit.

Additional Information:

Cost:
Please call 01202 205205 for more information.

Associated Costs:

For further information:
Contact the College Helpline on 01202 205205 or email enquiries@thecollege.co.uk.

Footer links