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.

Venue

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.

Duration

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: Monday, June 26th, 2017

Lead Training Services is pleased to announce the Autumn 2017 Intake for its exclusive accredited CPD Award Courses by the National Commission for Further and Higher Education (NCFHE).

Following is the list of courses for which Registrations are now open. …read more »