Access Fundamentals

Duration: 2 day | Book this course
Cost: $810.00 + GST

Course Description

This class takes participants through the basics of Microsoft Access – from understanding database terminology all the way through to creating a basic database.  Topics include: working with existing databases; creating new databases and working with objects (tables, forms, queries and reports).  Participants are shown how to plan, create, edit and print objects. Participants will also learn how to create, manage, and modify basic table relationships.  In addition, the course will cover how to import and export data in Access.

Prerequisites

Participants should have completed the Basic Computer Skills course or, preferably have a working knowledge of Microsoft Excel.

Who Should Take This Course
This course is designed for new users of Microsoft Access.  If you are unsure, please complete a Training Needs Assessment form by clicking here or email admin@ardito.co.nz.

Course Objectives

Upon completing this course, you will have learned how to:

  1. Key concepts and Terminology
  2. Designing a database and documentation
  3. Working with existing databases (navigating, adding and editing data)
  4. Creating a flat-file & relational database
  5. Working with and creating Tables
  6. Creating basic forms and subforms
  7. Creating and editing Queries (including calculated queries)
  8. Creating and editing Reports
  9. Creating mailing labels
  10. Importing data from Excel
  11. Using Access data to create a mail merge in Word

Course Outline

Key concepts and Terminology

Overview of databases

  • Flat file and relational databases

Designing a basic database

  • Defining your needs
  • Basic Design Rules
  • Documentation

Objects

  • Tables
  • Forms
  • Queries
  • Reports

Working with existing database

  • Navigation
  • Adding data & editing

Creating a database

  • Creating a flat-file database
  • Creating a relational database

Working with Tables

  • Setting table properties
  • Define primary key
  • Adding & deleting records
  • Sorting and searching for data

Creating Forms

  • Creating Forms and subforms
  • Editing forms
  • Navigating through forms

Queries

  • Creating queries
  • Calculated queries

Reports

  • Creating, editing and printing reports
  • Creating mailing labels

Data collaboration

  • Importing data from Excel
  • Using Access data to create a mail merge in Word