Who is it for?
This course is for delegates who need to build, use or change their own simple database or need to understand how a database is used.
Description
A database is used to hold data about things that exist in the real world, for example people in a personnel system. This course will equip you with the necessary understanding and hands-on skills to build a simple database.
You will learn how to set up tables to hold your data and how to link these tables together in a meaningful manner. You will then learn how to use filters and queries to retrieve useful data from your tables.
Please note: this course outline is a guide only. Topics covered on the day depend on the number of delegates in the training session, their pace and interests.
Course content
-
Understanding the database
-
Using existing databases
-
Find, sort and filter records
-
Querying data
-
Working with reports
-
Data types
-
The primary key
-
Creating and amending forms
-
Creating a filter
-
Using report wizards
-
Creating a simple database
Course duration
1 day, normally between 9:30 and 4:30