Microsoft Access 2010 UpgradeDownload Course Outline

This is the outline of our Access 2010 Upgrade course - Duration: 1 day

With Microsoft Access 2010, following from Access 2007, there has been a major overhaul of the user interface and many things have changed. The menus, toolbars and database window have been replaced by a single palette of commands called The Ribbon and the Object Navigation Pane. There are many enhancements to the creation of Tables, Forms and Reports, particularly with the new Layout Views and while these are intuitive and very powerful they are very different from previous versions of Access. So when you upgrade you will be both frustrated and confused depending on your level of experience.  

This course will allay your fears and resolve your frustration with using the new version of Access. To get the best from this course you should be a reasonably competent user of Microsoft Access (2003 or earlier).

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment. If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.

Microsoft Access 2010 Upgrade course content

Download a PDF course outline using the link on the right.

The 2010 Access Environment

  • Use the New Start Up Screen to find favourite databases or create new databases.
  • Use and customise the Navigation Pane to find objects and related objects.
  • Use Tabbed screens or change back to overlapping windows.
  • Use the New View Icons.
  • Find your way around the Access Ribbon and Access Contextual Tabs.
  • Use the New Filter Options on Tables, Queries and Forms.
  • Use the Object Dependencies Window to find related tables and other dependent objects.
  • Use the Calendar for entering Dates

What’s New In Tables

  • Create New Tables in Datasheet View
  • Add and edit fields in tables using the Datasheet
  • Attach files to tables using the New Attachment Field
  • Format text in Memo fields using Rich Text
  • Use Alternate Fills for visual clarity
  • Add Fields from Other Tables (Lookups)
  • Populate lookup fields with multiple values.

What’s New in Queries

  • Use the Design Contextual tab to create and run Queries.

What’s New in Forms

  • Use the New Automatic Form Options to create new forms.
  • Add existing Fields to forms from other tables.
  • Use the New Control Layout Tools.
  • Control property sheet docking.
  • Use the New Layout View
  • Format forms using the new Form AutoFormats
  • Add Title and Date/ Time Controls.

What’s New in Reports

  • Use the New Layout View to change report design
  • Sort and Group Records on a Report using the New Layout View.
  • Add Group and Grand Totals using the New Group and Sort Pane.
  • Use the New Report View

We also offer this course as Live Online Learning - follow this link to learn more.