Pagoda Training Ltd
Helping clients deliver effective IT training projects
 
Microsoft Access 2003 Introduction - Course outline
   
Duration One Day
Objectives To provide users with an understanding of relational database concepts and to create a simple relational database using the four basic Access objects.
Who should attend Those who have little or no experience of relational databases. In many cases, those who are currently holding lists of data in a flat file (spreadsheet) database, but have identified that their data could be managed more efficiently.
Experience needed Delegates should have reasonable mouse and keyboard skills, and should be comfortable working with Windows applications.
   
Content Introduction to databases
Relational database concepts
The primary key
An overview of the four basic objects in Access

Starting Access
Opening an existing database
Viewing objects within a database

Creating an Access database
Designing tables (fields and data types)
Entering data in tables
Simple query design
Cut/Copy/Collect and Paste

Defining table relationships

Queries across related tables

Using the Forms Wizard
Using the Reports Wizard

Sorting data in tables/queries/forms
Filtering Data in tables/queries/forms
   
   
 

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