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

Ntec Tertiary Group NZ
25 Federal St
Corner Swanson and Federal Streets
Auckland

Dates