COURSES
SERVICES
ABOUT US
MOBILES
   Join us on:
   Share:
  
    | Evaluation  |  Trainers  | Looking to link to us? | Site Map
  
 IT Training Solutions Homepage

   0191 377 8377
   enquiries@ittrainingsolutions.co.uk
Delegate
Feedback

View All

"This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
T. S. Bell Truck and Van
Excel 2007 / 2010 Level 2 - January 2012

"Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
J. M. The Cyrenians
VBA using Excel - December 2011

"Today I've had the most enjoyable and informative training session of my professional career, can't say more than that!"
R. D. Centre West
Train the Trainer - September 2011

"Very well presented, easy to follow and trainer willing to answer any questions."
I. R. Solar Solve
Dreamweaver Level 1 - October 2011

"I found the course to be very valuable and will definitely be able to put my new skills into action in my job."
A. K. Rettig (UK) Ltd
Excel 2003 Level 2 - September 2011

"Excellently presented. Never felt rushed or out of depth. Trainer very helpful."
N. W. Mouchel
Access 2007 / 2010 Level 1 - September 2011

"Course both covered the syllabus and was flexible enough to be tailored to our specific needs in certain areas"
M. C. Nova International
Excel 2007 / 2010 Level 2 - July 2011

"Learnt above and beyond what I expected, made very welcome which led to a good working atmosphere"
R. M. Petrofac
Word 2003 Level 1 - June 2011

"Amazing! Fountain of knowledge!"
L. D. Aesica Pharmaceutical
InDesign Level 1 - June 2011

"Great experience, really worthwhile once again"
L. C. EnCore Envelopes
Excel 2007 / 2010 Level 3 - April 2011

"Very good way to teach. Nice mix of theory and practice"
K. F. Durham University
Access Level 2 - May 2010



Access 2007 / 2010 Level 3



     

Date Location Duration Cost
19 Apr 2012 (Thu)
20 Apr 2012 (Fri)
Washington 2 £ 395
24 Jul 2012 (Tue)
25 Jul 2012 (Wed)
Washington 2 £ 395
24 Sep 2012 (Mon)
25 Sep 2012 (Tue)
Newcastle 2 £ 395
22 Nov 2012 (Thu)
23 Nov 2012 (Fri)
Washington 2 £ 395
All prices exclude VAT
Please contact us to discuss private course dates and locations

 

Course Overview

This course is for delegates who have sound skills in the use of Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use Access data in other Office applications. Access 2007 Level 3 is ideal for those who are responsible for structuring data into properly designed tables, analysing data and automating tasks using Access, as well as producing advanced report outputs.

Prerequisites

Objectives

Course Content

Creating multiple table queries

    Selecting tables
    The type of joins in a query
    Changing the properties of a join in a query
    Performing group and total calculations
    Entering a criteria with a Group and Totals Query
    Querying for unique values
    Parameter queries

Action queries

    Make Table query: Making a table from the results of a query
    Update query: Updating values in a table using a query
    Append query: Adding the results of a query to a table
    Delete query: Deleting all the records in a table that are displayed by the query
    Find Duplicates/Unmatched query
    Adding a tab control

Customising reports

    Printing a report
    Adding an extra band to a report
    Creating a chart or labels report

Advanced form design

    Unbound forms
    Using command buttons
    Passing values to queries from a field on a form
    The Expression Builder
    Events on forms for triggering macros or Visual Basic code
    Different events on forms and form controls

Macros

    Creating a new macro
    The MsgBox macro
    Using macros in form events
    Passing values between forms to filter data
    Custom toolbars: customising toolbars
    Editing the button on the toolbar
    Removing an icon from the toolbar
    Custom menus: customising a menu
    Attaching toolbars and menu bars to objects
    The AutoExec macro and startup options - controlling what happens when your database starts
    Changing the splash screen for your application
    Keyboard shortcuts to run macros: Customising shortcuts

Database utilities

    Compacting and repairing a database
    Making ACCDE file
    Converting Access 2007 to previous versions

Security in Access

    Setting a password to open a database
    Splitting your database into a frontend and backend application

Training Options

  • Scheduled public courses at one of our training venues
  • Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
  • Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
  • For further information please contact us on 0191 377 8377

What's Included

  • 1 delegate per computer
  • Telephone and email support
  • Relaxed refreshment area at our training venues
  • Lunch and refreshments when training is delivered at our training venue
  • Comprehensive course manual and exercises
Microsoft and Microsoft Access are Registered Trademarks


Microsoft Access 2007/2010 training courses in North East England, Durham, Washington, Newcastle. How to build and manage databases in Microsoft Access.


 
 No additional fee for 
 credit card payments 

Please wait a moment whilst we retrieve the course schedule for you.
Thank you.

ACCESSIBILITY:  Decrease Text Size
Increase Text Size