Home > Training > Microsoft Courses > MS Access > Intermediate
Access 2007

Microsoft
Access 2007
Intermediate


Want to take advantage of the more advanced features of MS Access 2007?

Then come along to our full day Microsoft Access Intermediate course. Small class size for greater attention.

Date: Tuesday 21 September 2010
Venue: Sun House, 23 Queen Edith's Way, Cambridge CB1 7PH
Start Time: 9.30pm
End Time: 4.30pm
Price: £225 (+VAT)

How to book:

Unless otherwise agreed to, payment is due before the training event. Roem Limited reserves the right to refuse entry to any attendee should payment not have been received.

The price includes a buffet lunch and refreshments, a Microsoft Office Specialist (MOS) approved seminar handout with your own USB stick packed with exercise files for you to work through and take away, as well as one month post course advice.

The maximum class size is five, providing computer training in a friendly, non-threatening atmosphere. You will be led through each topic and there will be plenty of opportunity for hands-on exercises, questions and individual support. The practical work will be done on laptops using Access v2007.

   

I thought the training was absolutely superb. karen explained things clearly and gave me the confidence to try for myself. Her prompting was well timed and subtle. Course was extremley beneficial to me and i wouldn't hesitate to recommend her to anyone else.
Joanna Howell, Suffolk County Council

I found the day to be both productive and enjoyable. Thank you.
June Cheetham, Finrod Ltd, South Woodham Ferrers, Essex

Extremely useful course. Karen is an excellent trainer and host.
Alan Barton, St. John's College School, Cambridge

As always the course exceeded my expectations. Karen is an excellent trainer who knows her topic extremely well and has the ability to deal with every question, from the simple, to the stupid, right through to extremely complex ones! The venue and catering were top class ... I would not hesitate to recommend Roem Ltd to anyone with IT training needs.
AE Ruggles-Brise, Association of Rivers Trusts


Course outline:

Introduction

Modifying the design of a table

  • specifying a required field/ defining a default field value
  • setting a primary key for a table
  • adding a memo field to a table
  • additional table design topics

Working with multiple tables

  • displaying multiple tables on the Access desktop
  • resizing and repositioning the table window

Relating tables

  • creating a relationship between two tables in a database
  • displaying and using a subdatasheet

Working with a custom form

  • designing a custom form
  • adding a header and footer to a form
  • using a custom form to enter data

Intermediate query techniques

  • creating a query to extract information from multiple tables
  • creating a query to generate summary information
  • creating a crosstab query
  • creating a query to find unmatched records in a table
  • creating a query to find duplicate records in a table

Intermediate report techniques

  • creating a report of information in multiple tables
  • adding a calculated control to a report

Additional intermediate Access features

  • adding a lookup field to a table
  • defining an input mask for a field
  • viewing object dependencies
  • exporting an Access datasheet to Microsoft Office Excel

Final case study


Home   Courses   Word   Excel   PowerPoint   Access   Outlook   Windows   Disclaimer  

Microsoft Office & Microsoft Access are registered trademarks of the Microsoft Corporation
© Roem Ltd. All Rights Reserved
July 2010