Access - Introduction

Course Details

Participants will be able to : create a table, make a query and auto form. Enter & edit records. Print tables, queries, standard reports and forms and use indexes

Participants can bring work that they would like to put on a database. In the course of the day they can apply their new skills to work that’s relevant to them. We’ll give them a disk and they can take their work away with them.

On our courses both keyboard and mouse skills are taught. All courses are instructor led and include comprehensive notes.

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 FORMS

• Add titles, fields and labels
• Edit and change the appearance of labels
• Select, size, and move controls (objects)
• Using your form

CREATING REPORTS

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

CONSULTANCY SESSION

• Participants can bring work that they would like to put on a database. In the course of the day they can apply their new skills to work that’s relevant to them.

Venue

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

Dates