Pagoda Training Ltd
Helping clients deliver effective IT training projects
 
Microsoft Access 2007 Introduction - Course outline
   
Duration Two Days
Objectives The course will provide anyone involved in using an Access database with an understanding of the products features. It explores working with records, filtering data, designing and running queries, designing forms and designing and printing reports.
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

Introducing Access
 The Screen Layout
The Ribbon
The Quick Access Toolbar
The Navigation Pane
Database Objects
Getting Help

Managing Data
Navigating a Table
Entering Data
Editing Data
Sorting Data
Finding Data
Printing a Table

Filters
Creating a Filter in a Table
Saving a Filter as a Query

Tables
Creating Tables
Fields
Data Types
Field Properties
The Primary Key
Indexing
Normalisation

Designing Relational Databases
Creating Relationships
Types of Relationships
The Relationship Window
Referential Integrity

Queries
Creating Select Queries
Entering Criteria in a Query
Sorting Data in a Query
Using Wildcards
Multi Table Queries
Parameter Queries
Calculated Queries
Group and Summary Queries

Forms
Entering Data in a Form
Creating an AutoForm
Creating a Form with a Wizard
Customizing a Form in Design View
Customizing a form in Layout View
Setting Control Properties

Reports
Creating an Auto Report
Creating a Report with a Wizard
Print Preview
Printing Reports
Summarizing Data in a Report
Modifying Reports in Layout View
Grouping Data
Adding Headers and Footers

   
   
 

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