giving people the skills to succeed  
search our website
Courses > IT Courses > What's New in Microsoft Access 2007
 
   
 
What's New in Microsoft Access 2007
 
Target Audience:  

Users of a previous version of Microsoft Access who are upgrading to Microsoft Office 2007.

 
   
Objectives:  

By the end of the course users will be familiar with the new field properties in tables and import/export routines.  Users will also be familiar with the new methods used to create and edit tables, queries, forms, and reports.

 
   
Prerequisites:  

Users should have a sound working knowledge of a previous version of Microsoft Access and be able to create database objects and manage relationships.

 
   
 
       
     
  Duration: Half Day
  Cost: £125 + VAT
     
 
  Course Date Location
     
Demand led
Call to request dates
     
     
         

Microsoft Access 2007

  • What’s New with the Access Screen

  • Working with the Navigation Pane

  • New Database Templates

  • Converting to the New File Format

 

Creating & Modifying Tables

  • Attachment Fields

  • Multi-valued Fields

  • Using Rich Text in Memo Fields

  • Importing & Exporting Data

 
 
   

Working in Datasheet View

  • Using the Totals Row

  • Sorting by Single or Multiple Columns

 

What's New with Queries

  • Working with Summary Queries

  • Recognising Query Types

 

Forms & Reports

  • Creating ‘One-Click’ Forms & Reports

  • The Layout View & Report View

  • Moving & Sizing Controls

  • Adding & Removing Controls in a Stack