An organisation development specialistLinked In

Access Introduction 2010 / 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

  • Introduction to Database Concepts and Terminology
  • Starting Access
  • Access Databases
  • Creating New Databases
  • Creating an Object
  • Creating a Table
  • Changing Tables
  • Entering Data in Datasheet View
  • Copy, Move, Delete
  • Changing the Datasheet’s Layout
  • Designing Forms
  • Types of Form
  • Changing Forms using the Forms Design Work Surface
  • Editing the Tab order
  • Calculations within Forms
  • Creating Forms from Scratch
  • Multiple Screen Forms
  • Filter/Sort Records
  • Queries & Dynasets
  • Sorting Data
  • Calculations in Queries
  • Grouping and Summarising Data
  • Producing Cross Tabulated Results
  • Customising Queries with Parameters
  • Using Filters
  • Queries to Link Data from Different Tables
  • Queries with Calculated Fields
  • Queries to Summarise Data
  • Queries with Parameters
  • Action Queries
  • Action (Update) Query
  • Action (Make table) Query
  • Action (Delete) Queries
  • Action (Append) Query
  • Printed reports
  • Using the Report Wizard
  • Report Design Mode
  • Calculated and Statistical Fields
  • Including Graphs in Reports
  • Organizing Reports 
  • Label Generation

Content may vary slightly depending on version being used

More