This course provides an overview of the redesigned user interface and interactive features of Microsoft Office Access 2007. This course is designed for experienced Access users who have worked with earlier versions of Microsoft Access, ideally Microsoft Access 2003, and who have or are planning to upgrade to Microsoft Access 2007.

Module 1: The new look & Feel of Microsoft Access 2007

• Changes to the interface
• Using the Office button
• Working with the ribbon
• Understanding tabs, groups and commands
• Using contextual tabs
• Using the quick access toolbar
• Using the mini toolbar
• Customising the environment
• Using zoom

Module 2: Navigating with Microsoft Access 2007

• The new Access 2007 Navigation pane
• Creating Custom Groups (to organize forms and reports in a single table

Module 3: Working with Tables & Forms

• Working with tables in Access 2007
• Working with Forms in Access 2007
• Creating custom slide layouts

Module 4: Queries and Reports in Access 2007

• New ways to query your database
• Generating Reports in Access 2007

Module 5: Formatting in Access 2007

• New and enhanced ways to format reports
• New and enhanced ways to format tables

Module 6 – Working with External Data

• Importing and Exporting Data
• Importing & Exporting Records from / to Microsoft Outlook
• Understanding compatibility between different versions

Module 7 –SharePoint Integration

• Discussion of how Access 2007 integrates with SharePoint

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk