Lead Training Services

Database Management through MS Excel and MS Access

Target audience

The target groups are students and adults who are highly motivated to pursue further studies and to extend their knowledge of MS Excel & Access as well as database management.


This bespoke programme can be provided either at our training centre or at the client’s premises. Laptops can be provided by us at an extra charge.


6.5 Hours

Overall course objectives

  • Understand how to set up data types of fields
  • Understand the consequences of modifying data types (text, memo, hyperlink, currency, date & time format)
  • Be familiar with validation rules, default values
  • Be familiar with mandatory data field or column.
  • Understand how to create a valid relationship
  • Be familiar with modifications of relationships and the use of referential integrity
  • Understand the principal relationships (one-to-one, one-to-many) and how to modify them
  • Understand how to apply inner, outer and self joins.
  • Know how to create, use a query to update, delete data and records in a table.
  • Understand the use of functions (SUM, AVERAGE, MIN, MAX, COUNT in queries)
  • Be familiar with refining a query (duplicates, unmatched values, highest, lowest range of values, Null and Not values)
  • Understand how to use list boxes, combo boxes, option groups
  • Know how to record and run a simple macro
  • Know how to import and export data in other formatsf

Who We Are

We are a team of specialists passionate about our work and with a common ambition to share learning experiences with people in the business community and civil society.

Under the brand name LEAD Training Services, our team has attracted an impressive pool of professional trainers from different areas of business.

This makes us the only professional training organisation in Malta that can offer cutting edge training programmes across a broad spectrum of topics. We do not believe in one-size-fits-all training programmes and in line with our belief we customise our programmes to our individual customer’s needs.

Let's Keep In Touch

Stay adjourned with our latest courses, news and events by subscribing to our newsletter. We will send you an email newsletter from time to time, and we promise to never sell your details to any third parties!

Our LatestNews

Posted on: Monday, February 25th, 2019

On the 7th February 2019, LEAD Training Services organised its annual award ceremony. This annual event was held at the Xara Lodge in Rabat.

A total of 343 students who successfully completed an accredited CPD Award course during the year 2018 were invited for this ceremony in order to be officially presented with the CPD Award Certificate.

…read more »