An organisation development specialistLinked In

Access Introduction 2007

Duration 2 days

Designed for

Anyone wishing to use Access for the first time or those who have never received formal training

Pre-requisites

It would be beneficial if delegates have attended the Introductory sessions for Microsoft Word and Excel before completing this course

Course Aims

By the end of this course, delegates will be able to build a simple database, including Tables, Forms Querying and Reports. Delegates will also be able to interrogate a simple database and be able to produce labels.

Course content

  • Database Concepts and Terminology
  • Access Databases
  • Creating New Databases
  • Using Database Templates
  • Relational Databases
  • Creating Tables (Manual & Templates)
  • Field Properties
  • Editing Table Design
  • Entering Data in Datasheet View
  • Changing the Datasheet Layout
  • Copy, Move, Deleting Data
  • Spell Checking Data
  • Formatting Tables in Datasheet View
  • Filtering Records
  • Queries & Dynasets
  • Sorting Data
  • Totaling Records
  • Relating Tables
  • Creating Forms (Manually & Autoform)
  • Editing Form Design
  • Calculations within Forms
  • OLE Objects within Forms
  • Split Forms
  • Creating Select Queries
  • Calculations in Queries
  • Producing Cross Tabulated Results
  • Customising Queries with Parameters
  • Queries with Calculated Fields
  • Queries to Summarise Data
  • Queries with Parameters
  • Action Queries
  • Report & Layout Views
  • Printed Reports
  • Using the Report Wizard
  • Report Autoformats
  • Report Design Mode
  • Adding Graphics/Logos
  • Calculated and Statistical Fields
  • Including Graphs in Reports
  • Label Generation



Database Workshop

During the afternoon of the second day delegates are encouraged to design and build their own database under the watchful eye of their trainer. Delegates are welcome to bring in their own data or project, or alternatively can choose to concentrate on one key area ie Reports from the database they will have produced during the course

More