Beginners Microsoft Access Training

1 day - £215 + vat

Access TrainingThis is an intensive Access training course, introducing delegates to the concepts of creating relational databases using MS Access. Microsoft Access is a very powerful database application designed to save you time and make creating relational databases easier. Beginners access course will give attendees the skills needed to go on our advanced microsoft access training course.

Beginners Microsoft Access Course Objectives:

By the end of the Beginners Microsoft Access training course, delegates will be able to create a simple relational databases using Access

Microsoft Access Course Content

Introduction to Microsoft Access

  • What is a relational Database
  • What are Access Objects
  • Database design concepts
  • Relationships between tables

Working with an Access Table

  • What are fields and records
  • How to navigate through records
  • How to enter, edit and delete records
  • How to format tables
  • Filtering data in tables

Designing Access Tables

  • Using design view
  • Adding and naming fields
  • Assigning Field types
  • Assigning Field Properties
  • Creating Key Fields
  • Creating relationships

Designing Access Queries

  • Using And and Or statements
  • Parameter Queries
  • Autolookup Queries
  • Designing Forms

What are Access forms

  • Designing a Form using the Wizard
  • Formatting forms
  • Adding controls
  • Working with combo boxes

Access Report Design

  • Creating a report using the Wizard
  • Formatting Reports

Microsoft Access Training Course Prerequisites:

  • Delegates attending this access course should have reasonable general PC skills.
  • No prior knowledge of Access is required

Book this Microsoft Access training course one to one for £450 + vat

Microsoft Access Training Course Recommended Reading

Microsoft Access 2007 Step By Step by Microsoft Press - buy from amazon
 

Download course outline as pdf.

Share This

Bookmark and Share

+44 (0)1273 622272

Beginners Microsoft Access Training course dates

  • 23 Apr 2010
  • 24 Aug 2010
  • 17 Dec 2010

Training Grants

Training Grants

Follow Silicon Beach Training

Request more information about "Beginners Microsoft Access Training"

Home | Sitemap | Print |