Access - Accelerated Introduction

Participants can bring work that they would like to put on a database. Over the 3 hour course participants can apply their new skills to work that is relevant to them and they can take their work away with them.

BASICS

  • Starting and exiting Access
  • Using the menus and help
  • Opening and closing a database
  • Aspects of the database window

USING A DATABASE

  • Using a database
  • Changing from table to form view
  • Moving and resizing columns and rows
  • Formatting the table

CREATING A TABLE

  • Create a table
  • Define fields
  • Choose data types and field properties
  • Setting default entries and validating data
  • Delete, insert and rearrange fields
  • Using the primary key and indexes

FIND, SORT AND FILTER

  • Finding a record
  • Sorting the database
  • Create a filter, specify criteria. apply and save

WORKING WITH QUERIES

  • Entering query criteria
  • Choosing columns to show
  • Calculating totals and averages
  • Saving and modifying a query

CREATING REPORTS

  • Designing a report using Report Wizard
  • Grouping Fields
  • Summary Information
  • Detail Properties, Headers and Footers

Class Details

Venue:

Level 2 Prime Property House
2 Woodward Street
Corner Lambton Quay & Woodward Street
Wellington

Dates

Date Time Cost
Wed 14 - Wed 14 August 10 am - 1 pm $205.00

Dates don't suit? Call or E-mail.