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 and different geographical locations.

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: Thursday, February 15th, 2018

On the 9th February 2018, LEAD Training Services held its annual Award Ceremony at the Xara Lodge in Rabat. Present for this event were over 300 students who attended LEAD’s accredited professional short courses during 2017 and successfully achieved their CPD Award Qualifications.

Special guests for this ceremony included the Mr. Martin Borg, and Educational Management and Quality Control expert Mr. Paul Gauci Executive Head of BOV Training Centre and trainer with LEAD Training Services. All of these, together with Mr James Grech Managing Director of LEAD Training Services delivered short speeches during this event. …read more »