Pagoda Training Ltd
Helping clients deliver effective IT training projects
 
Microsoft Access 2003 Intermediate - Course outline
   
Duration One Day
Objectives To design more advanced queries and action queries to automate data entry and editing processes. To develop more complex forms and reports.
Who should attend Those who understand relational database concepts and have been using Access, but who wish to design and build more complex applications.
Experience needed Delegates should have attended an introductory Access course, or gained the relevant experience through working with Access.
   
Content

Upgrading your Access 97/2000/2002 database
Working in Access 2003

Parameter queries
Calculated fields in queries
Concatenation of fields

Introduction to action queries
The update query
The append and delete queries
The make table query
The cross tab query

Forms based upon queries
Changing the design of a form
Adding controls to forms, for example a combo box
Subforms
Customising the properties of forms and controls

Modifying the design of a report
Sorting and grouping
Page breaks
Group totals
Calculated controls
Customising the properties of reports and controls
   
   
 

Pagoda Training Ltd, 2nd Floor, Thornborough Hall, Leyburn, North Yorkshire, DL8 5AB
Tel 01969 625596 Email training@pagoda.co.uk
Incorporated in England Registration No. 3132465
  Back to top