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

Simply Training Logo

MS Excel

MS Excel training is offered by Simply Training. Simply Training can help you deliver real benefits for your employee IT training programmes through our Training Project Management service.

by Simply Training [Claim Listing ]
Essential Skills Logo

Office Essentials

Essential Skills provides quality technology-based business software training tailored to you and your organisation. We will work with you to develop and deliver training solutions that fit participant’s needs and increase their productivity.

by Essential Skills [Claim Listing ]
PD Training Logo

Microsoft Word 2010 Intermediate Training

Microsoft Word 2010 is the most widely used word processing software used to create, edit and save professional documents in most organisations.

by PD Training [Claim Listing ]
knowitinc Logo

Microsoft Word Training

Microsoft Word training courses to use Word proficiently and save time. This course provides the essential skills needed to create, edit, format, and print Word documents.

by knowitinc [Claim Listing ]
Computer Learning Centre Logo

Excel (Accelerated Introduction)

Excel is a hugely powerful office tool that enables people to analyse data much more efficiently. In this introductory course, learn the basics of Excel and watch your data analysis efficiency go through the roof.

by Computer Learning Centre [Claim Listing ]

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