New Zealand Community Education Centres

Microsoft Access - The Basics

An efficient means of managing data is by using databases, where information can be stored, linked and managed. Examine database concepts and create and modify databases and their various objects using MS Access. Good computer skills required.

Description

Data is everywhere. Whether you’re at the grocery store, office, laboratory, classroom, or ballpark, you’re awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades and statistics. 

Most job roles today involve some form of data management. In the case of data workers, it may be their primary task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales assistants or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data. 

A relational database application such as Microsoft® Office Access® can help you and your organisation collect and manage large amounts of data. Access is a versatile tool which you can use as a personal data management tool (for your use alone) or you can use as a construction set to develop applications for an entire department or organisation. In this course, you’ll use Access to manage your data, including: creating a new database; constructing tables; designing forms and reports and creating queries to join, filter, and sort data.

By the end of the course, you'll have had a basic introduction to using MS Access, including how to:
• Identify Access objects
• Start Access and open a database
• Create a database
• Create a table
• Create a query
• Create a report
• Use the form wizard to create a form 

Note:  Courses need a minimum number to go ahead so if we don't have enough enrolments a few days before the start date, we have to cancel. We'll let you know by email so please check yours regularly. If you need to cancel your registration, here are our terms and conditions: "What You Need to Know".

Prerequisites

You need to have good end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs and use a browser to access websites.

Related Courses