Click Here for Course Booking Information or Call us on             0845 257 9950

 

 

  Inspire - Inform - Improve  

Microsoft Access

Introduction

 

Database Concepts

  • Database concepts and terminology
  • Exploring the Access environment
  • Planning and designing databases
  • Getting help
  • Closing a database and Access

Access basics

  • Exploring tables and forms
  • Examining Queries
  • Exploring reports

Creating databases

  • Creating a database
  • Using the Table Wizard
  • Working in Design View

Working with fields and records

  • Changing the design of a table
  • Adding and deleting records
  • Finding and editing records
  • Sorting and filtering records

Querying tables

  • Creating and using queries
  • Modifying query results and queries
  • Using calculations in queries

Creating and using forms

  • Creating forms by using AutoForm
  • Using the Form Wizard
  • Using Design view
  • Finding, Sorting, and filtering records

Creating and using reports

  • Using the Report Wizard and queries
  • Creating, modifying, and printing reports

Importing, exporting, and linking objects

  • Importing Access objects
  • Exporting Access objects
  • Exporting and importing XML documents
  • Linking Access objects