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

Master IT Logo

Microsoft Word

Having trouble with formatting your word documents. Our tutors can provide step-by-step training to ensure you are able to understand how Microsoft Word works.

by Master IT [Claim Listing ]
Linkit Group Logo

Microsoft Word

This course is designed for all staff who Create reports on a daily basis,Are involved with the review and publication of reports created by their team members Need to create educational assignments and reports

by Linkit Group [Claim Listing ]
knowitinc Logo

Microsoft Office

This training will provide the skills to efficiently use Outlook to manage your Emails, Calendar Appointments and Meetings, Tasks and Notes.

by knowitinc [Claim Listing ]
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 ]
UCOL (Manawatu Campus) Logo

Introduction to Microsoft PowerPoint

Learn the basics of creating a presentation in UCOL's free Introduction to Microsoft PowerPoint course. Following on from UCOL's Introduction to Computing course, continue your learning experience with this Introduction to Microsoft PowerPoint Course.

by UCOL (Manawatu Campus) [Claim Listing ]

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