MS Access - Database essentials

Organise and retrieve data effortlessly using Access databases. Learn the basics including tables, reports and queries. Sound computer knowledge required.

Entry Requirements

a solid understanding of computers is essential

Student Instructions

Pen and paper for note taking. Optional but highly recommended – a Memory stick/USB flash drive as this is the most efficient way of saving and retaining your work.

Topics

Working with Database objects including table, query, form and report
Managing data, relationships and primary keys
Creating and customising queries, creating and customising forms, creating useful reports.
Setting field properties and optimising relationships

Career Prospects

office work

Delivery Style

Teacher instruction, followed by independent student work using a text book. This course is information based and designed to cater to a wide range of learner needs. It is predominately self paced with facilitator assistance.

Outcomes

Students will gain basic knowledge and skills in producing an Access database