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