26/03/2015 - 23/04/2015    
9:30 am - 5:00 pm


Mayo, Mayo, Mayo

The “Web Based Database Training” course proposed will provide an introduction to data entry
and management of databases through web interfaces such that multi-user environments are
enabled. An intermediate training course will be provided to users who have already completed
the basic course.

Intro to on line database principles
The concept of back end and front end
Logging in and security settings
Structure, Model & Fields
Relationship tables
Data storage
Searching and entering contacts
Manually inputting data
Creating records
Merging data
Processing Postal Enrolments

Creating courses
Allocating courses
Accepting Online bookings
Payments and Worldnet
Integration with Accounts packages

Sorting data
Basic queries
Generating reports
Creating and Allocating Accommodation
Creating and allocating classes and groups
Detecting whether allocated students to groups/classes match in age range/ school

Creating advanced queries- SQL Query builder
Exporting data to Excel
Backing up the data.
Generating reports
Creating courses
Logging tasks
Administrator rights


Share This