Inspire IT deliver IT Training in the Microsoft Suite throughout Ireland. We also deliver training in Web Design
Advanced Access

Advanced Access training coursesCourse Objectives:

At the end of this course participants will be able to understand more advanced operations associated with database design. You will see how to create drop down menu's in tables, how to create advanced forms and reports.

Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry, Laois, Offaly and Wexford.

We will travel onsite anywhere in Ireland

Prior to to course we will discuss your requirements and develop the course content to suit your needs.

  • All participants receive handouts and course files of the course content if they want to review the information at a later date.
  • 6 months FREE E-mail Support after course.
  • Inspire IT are flexible with start and finish times for courses. We have delivered training courses that started at 7am and finished at 2pm due to clients preference.

For more information please E-mail Alan Joyce at info@inspiresit.ie or contact him at 085 1055651

 

Tables

  • Field Properties
  • Lookup Fields
  • Default Values
  • Validation Rules/Text
  • Input Masks

Relationships

  • Applying a Primary Key
  • Applying Relationships
  • Creating other relationships
  • Querying Related Tables
  • Applying Joins
  • Referential Integrity
  • Updating and Deleting Records
  • Viewing a subdatasheet

Queries

  • Creating a query
  • Action Queries
  • Append Query
  • Delete Query
  • Make Table Query
  • Update Query
  • Crosstab Query

Forms

  • Main/Subform Wizard
  • Linking Forms
  • Multiple Table Forms

 

Form Controls

  • Calculated Fields
  • Command Button
  • Combo Box
  • List Boxes
  • Check Boxes
  • Option Groups
  • Tab Control
  • Form Headers and Footers
  • Printing Forms

Reports

  • Grouped Report
  • Calculated Fields
  • Calculating Percentages
  • Report Headers & Footers
  • Printing Reports

Import and Export Data

  • Importing Data
  • Exporting Data
  • Linking Data

Macros

  • Macro Actions
  • Create a New Macro
  • Attaching a Macro to a Control
  • Create Macros from Controls
  • Multiple Action Macros

 

 
  Back to courses  
HOME | MICROSOFT OFFICE | WEB DESIGN | ONE TO ONE | CONSULTANCY | TESTIMONIALS | ECDL | ECDL ADVANCED | BLOG | PROFILE SITEMAP
Contact Us: 085 1055651 E-mail: info@inspiresit.ie Skype: inspireitweb
Website Designed by Inspire IT Web Design & SEO Specialists All right reserved Inspire IT 2010
Click here to go back to the homepage