Choose from our list of courses
Course Programmes
Assist Accountancy & Payroll Services
Exam Results
Current Courses
Join the
Assist Training
& Consultancy Ltd
mailing list
Email:


24 Barrington Street
Limerick, Ireland.
353 (0) 61 317500
353 (0) 61 316517
info@assisttraining.ie

© Images and content
copyright

Website Designed By
Graphic Index

Hit Counter

1 Day Corporate Training

Computer Training Courses

Advanced Access - Level 1

Course Level: Advanced

Click the escalator to choose another level

Course Objectives:

Advanced Features of Microsoft Access.

Prerequisites:

Advanced knowledge of use and design of tables, forms, queries, reports.

Duration:

1 Day

Course Content:
Session 1 - Introduction
  • Introduction to the course
  • Discussion of needs
Session 2
  • Normalisation of Data
  • Integrating Tables
  • Relationships
  • Attaching Tables
Session 3
  • Queries - QBE versus SQL
  • Crosstab
  • Self joins
  • Parameter
  • Aggregate queries
  • Action Queries - Update, Delete, Append
  • Removing Duplicates
Session 4
  • Jet DLL
  • Replication (Access 95)
Session 5
  • Security - password
  • Restricting Access
Session 6
  • Presenting Data
  • Forms and Reports
  • Controls
  • Properties on Forms
  • Simple Code
Session 7
  • Building Applications
  • - Introduction to best practice

*Optional parts of the course depending on ability and requirements of participants

Advanced Access Level 2

Course Objectives

VB and SQL programming for Access.

Prerequisites:

Attendance at Advanced Access Level 1 course. Or good knowledge of, and proficiency in, all topics listed for Level 1

Duration:

1 Day

Session 1 - Introduction
  • Introduction to the course
  • Discussion of needs
Session 2
  • Code
  • Approaches to code
  • Visual Basic Introduction and Usage
  • Structures and parameters dealing with VBAPI and examples
Session 3
  • Queries
  • Code in queries
  • Jet DLL
  • SQL Language
Session 4
  • Building applications
  • Applying VB to building applications
  • Optimising Access functions with VB code
  • Modules in VB

*Optional parts of the course depending on ability and requirements of participants

Back to Top

Back Previous Level - Intermediate Access

Click here to reserve a place on this course
Home I Company Profile I Accreditations I Recruitment I FAQs I Links
Course Schedule I Delivery I Where We Are I Enquiry Form I Email Us
Welcome to the Assist Training website Assist Home Page About Assist Training Accreditations Recruitment FAQs Links Assist Home Page Course Schedule Delivery Where We Are Enquiry Form Email Us