Course Aims

For participants to understand the principles of a database and manage client, supplier and other data using a database with tools to manipulate the data according to the needs of the organisation.

The skills participants will develop will be to

Understand data formats

Create tables and relationships

Input, manage and update data in a database

Sort data according to different needs

Use queries to manipulate and retrieve data as required

Use forms and reports

The course is for

Those who are new to databases or need a refresher course and need to use databases to store, manage and manipulate data for professional uses in a professional format.

Topics covered

Introducing Access, navigating the window, toolbars and menus

The components of a database, fields, records, datatypes, objects

Designing tables, creating relationships and entering data

Sorting and filtering data, and deleting records

Creating and modifying forms

Creating simple queries

Create and customise reports

The benefits

Information databases using a PC will save space and cost, allowing data to be retrieved in seconds for any variety of needs and available on-demand.  A data rich organisation will be in a position to respond to clients and the market much more proactively, securing business and achieving targets.

Stand alone module duration: 1 day