This fast paced, half-day course introduces you to Microsoft Access. Microsoft Access is a popular application for creating small databases that store data in a structured manner, enabling quick retrieval of information.

Please be aware that while the course covers most of the syllabus for ECDL Module 5: Databases, some additional learning may be needed.

Who should attend?

Anyone intending to sit the ECDL Module 5 assessment or those simply looking for an introduction to Microsoft Access.

Course outline

Database theory

  • Common uses of a database,
  • Components of a database,
  • Database design.

Tables

  • Creating tables,
  • Field properties,
  • Entering and editing records,
  • Table relationships.

Forms

  • Creating a form,
  • Form design,
  • Using a form.

Queries

  • Creating queries,
  • Running queries.

Reports

  • Creating a report,
  • Report design,
  • Grouping and totalling records.

Prerequisites

Delegates will be expected to have basic keyboard and mouse skills, although no experience of Microsoft Access is required.