Microsoft Access Introduction

Contact us for dates, pricing and how we can customise courses to your requirements: contact us

Microsoft Access Introduction

Duration: 1 days

Microsoft Windows knowledge.

This course is for users who have limited or no database knowledge.

The Basics
  • Database concepts and terminology
  • Definition of a Database
  • Definition of a Table
  • Defining a Relational Database
Creating Databases
  • Creating a database
  • Using the table wizard
  • Working in design view
  • Creating forms by using AutoForm
  • Using the form wizard
  • Using design view
  • Finding, sorting and filtering records
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
Importing, Exporting and Linking Objects
  • Importing Access objects
  • Exporting Access objects
  • Linking Access objects
  • Using the report wizard and queries
  • Creating, modifying and printing reports