Blue Pecan Logo
Office Training
Excel Training Office 2010 Training Project Training Prices Client Feedback Contact
0800 612 4105 mail:
Onsite Microsoft Access 2010 Training - we come to you!
Microsoft Office Training > Office 2010 Training > Access 2010 Beginner's Course
Access 2010 Training

Access 2010 Beginner's Training


This course is suitable for complete beginners or occasional user of Microsoft Access. The training will give delegates an introduction to four main object types in Microsoft Access: tables, queries, forms and reports.

To accompany the instructor lead training, each delegate will receive manuals and practise, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed.

For pricing click here

Course Outline
Introduction to Access
  • Overview of object types - tables, queries, forms and reports
  • Naming conventions
  • The New Navigation Pane
  • Tabbed documents
  • New Table Features
    • Total Row
    • Date selector
    • New sort and filter options
    • Formatting a datasheet
    • Changing the datasheet default
  • Fields and records
  • Data types
  • Field properties
  • Lookup fields
  • Data entry
  • Formatting data tables
  • Hiding columns
  • Freezing columns
  • Filter by selection
  • Filter by form
  • Importing tables from Excel
  • Linking Excel tables
  • New Sort and Filter options
  • The QBE grid
  • Adding fields to your query
  • Adding criteria to your query
  • AND criteria
  • OR criteria
  • Sorting a query
  • New Form Features
    • Creating a form
    • The new layout view and features
    • Add fields
    • Changing field properties
    • New Navigation forms
    • New Split form
  • Creating forms using the form creation wizard
  • Designing your form
  • Formatting and placement of form controls
  • The New Layout View
  • New Report Features
    • Creating a report
    • The new layout view and features
    • Add fields
    • Changing field properties
    • Adding sorts and groups
    • Adding Totals
    • New Conditional Formatting option
  • Creating reports using the report creation wizard
  • Designing your report
  • Formatting and placement of report controls
  • The New Layout View


Onsite Microsoft Office Training

Microsoft Office Computer Training Courses throughout Surrey, Sussex, Hampshire, Kent, Essex, Berkshire, Buckinghamshire, Dorset, Hertfordshire, Oxfordshire, Wiltshire and London including Crawley, Brighton, Portsmouth, Southampton, Winchester, Farnham, Guildford, Basingstoke, Salisbury, Bournemouth, Poole, Dorchester, Tunbridge Wells, Ashford, Canterbury, Maidstone, Gravesend, Croydon, Kingston-upon-Thames, Reading, Newbury, Oxford, Watford, Hemel Hempstead, Dartford, Stevenage, Milton Keynes, Basildon, Chelmsford, Southend on Sea and Colchester.



Copyright (c) 2013 Blue Pecan. All rights reserved. Sitemap