Access - Accelerated Introduction

by Computer Learning Centre Claim Listing

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.

$150

Contact the Institutes

Fill this form

Advertisement

Computer Learning Centre Logo

img Duration

3 Hours

Course Details

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

  • Wellington Branch

    Level 1/2 Woodward Street, Wellington

Check out more MS Access courses in New Zealand

Ara Institute of Canterbury Ltd Logo

Access Enhanced

Enhance your knowledge and build your skills in Microsoft Access 2019/Office 365. Learn; forms, reports, advanced queries, import data from an external source, and create user instructions. We recommend you have completed Access for Beginners or have the equivalent knowledge.

by Ara Institute of Canterbury Ltd [Claim Listing ]
Step by Step Auckland Logo

Microsoft PowerPoint Training

This is an easy programme to learn if students have a basic understanding of word processing. Learn how to produce professional PowerPoint presentation’s for use in a work environment.

by Step by Step Auckland [Claim Listing ]
Master IT Logo

Microsoft PowerPoint

All those tricky extras – not so tricky when someone shows you how. Our tutors can provide step-by-step Training in Microsoft PowerPoint.

by Master IT [Claim Listing ]
NorthTec Logo

Microsoft Word 365

This short course will teach you all the basics plus lots of tips and tricks to have you confidently using Word 365 in your work or study environment.

by NorthTec [Claim Listing ]
Bay Software Consultancy Limited Logo

Microsoft PowerPoint

Microsoft PowerPoint course is offered by Bay Software Consultancy Limited. Our schedule of public courses provides beneficial training to all clients ranging from educating beginners through to up skilling advanced computer users.

by Bay Software Consultancy Limited [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy