Send to Friend

Access Advanced

 
Aims:

Upon completion, delegates will be able to design a database and enhance functionality with advanced queries and macros.

Prerequisites:

Must have attended the Microsoft Access Introduction course, or have a good working knowledge of the product.

Duration:

Two Days

Fees:

Course fees for this particular course will depend on your chosen Training solution. Please click on the links below for corresponding course fees:

PDF Course Download

Download PDFYou can download a PDF version of the course.

Download Access Advanced course outline.

If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.

If you are interested in our Access Advanced course call us on
0113 243 2226
Enquire about
this course Now

 

Course Dates

Available dates
20th - 21st October 2008
19th - 20th November 2008
15th - 16th December 2008
21st - 22nd January 2009
23rd - 24th February 2009

Advanced Queries

  • Self-joins
  • Inner and Outer joins
  • Parameter queries
  • Derived field queries
  • Calculated fields
  • Combining fields
  • AutoLookup queries
  • Advanced query wizards
  • Query-by-Form queries

Action queries

  • Update queries
  • Make table and Append queries
  • Delete queries

Advanced Form Design

  • Form controls
  • Combo- and list boxes
  • Tab controls
  • Main and subforms
  • AutoLookup forms
  • Non-table based forms
  • Multiple table forms
  • Advanced form properties

Database Tools

  • Table Analyser
  • Database Documentor
  • Performance Analyser

Importing and exporting data

  • Text files
  • Spreadsheet files
  • Attaching tables

Database Security

  • Encrypting and decrypting
  • Database file security
  • Object-level security

Compacting and repairing databases

Macros

  • Command buttons
  • Creating macros
  • General macro functions
  • Using macros
  • Creating filter buttons on forms
  • AutoExec macros
  • Creating Switchboards
  • Database start-up properties
  • Custom menus and toolbars
 

If you are interested in our Access Advanced course call us on
0113 243 2226
Enquire about
this course Now