MS Access Essentials

Course Duration: 8 Hours Frequency of Lessons: 1 Day Course
Date: Call on 79888609 for
next available slot
   
Time: 8.00am - 4.45pm Tutor: Mr Matthew Xuereb
       
Description:
A MS Access 2016 course covering all the essentials required to be able work fluently with MS Access.
       
Course Program:
8.00 am Welcome Coffee & Course Registration
8.30 am Part 1: Database and Access Basics
  • What is a database?
  • Overview of important database terms
  • What is MS Access
  • Creating a Simple Access Database
  • Creating and Manipulating Tables
  • Adding, editing and deleting data to tables
  • Using Access for Mail Merge
10.30 am Coffee Break
10.45 am Part 2: Database Tables and Relationships
  • Field data formats
  • Setting properties to fields
  • Adding and Removinf tables
  • Key fields (Primary, Secondary and Foreign Keys)
  • Relationships
  • Filters
  • Queries
1.00 pm Light Lunch
2.00 pm Part 3: Forms and Reports
  • Sorting
  • Forms Wizard
  • Forms Design
  • Reports
  • Switchboard
  • Backing up of Data
4.30 pm Concluding Remarks
       
Learning Material:
Full course notes are given printed to the students. Each student is also provided with a unique username that is used to access online self study material, video turorials and examples via our online learning system.
       
Certification: Upon completion of the course, students will be given a certificate of attendance.
   
Tuition Fee: € 170    
       
Call on 79888609 to apply for this course.