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 ICDL Databases module, some additional learning may be needed.

Who should attend?

Anyone intending to sit the ICDL Databases module 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.